SQL training

Computer training SQL course in English, French or Dutch

Oracle SQL training

1. Relational Database concepts

• Concept of database
• Database Management Systems (DBMS)
• Relational Database Management Systems (RDBMS)
• SQL Engine
• SQL vs. procedural code
• Tables
• Data types
• Normalization
• First normal form (1NF)
• Primary and candidate keys
• Limitations of 1NF
• Second normal form (2NF)
• Limitations of 2NF
• Third normal form (3NF)
• Boyce Codd normal form
• Database schemes
• Logical Data Model
• Relationship types
• Physical Data Model
• Foreign key
• Referential integrity
• Introduction to queries

2. Selection Queries

• Selecting: SELECT statement
• Choosing columns and tables with SELECT
• Filtering: WHERE statement
• DISTINCT
• Alias
• Logical operators: BETWEEN
• Logical operators: ALL
• Logical operators ANY
• Logical operators: EXISTS and IN
• Comparing EXISTS and IN
• Logical operators: NOT
• Logical operators: LIKE
• Aggregate functions and GROUP BY
• Counting: COUNT
• Restricting: HAVING
• Sorting: ORDER BY
• Sub-queries
• Set operations

3. Table creation and modification

• Table creation
• CREATE TABLE syntax
• CREATE TABLE examples
• Use of CONSTRAINT
• ALTER TABLE syntax
• ALTER TABLE examples
• Introduction to Indexes
• Indexes: advantages and disadvantages
• Indexes: examples
• When to create an index
• Index creation and destruction
• Views
• Views creation and destruction
• Remove a table: DROP
• Remove table data: TRUNCATE
• INSERT
• UPDATE
• DELETE

4. Using several tables: JOIN

• Join types
• Inner Join
• Self Join
• Inner Join limitations
• Outer Joins
• Left Join
• Right Join
• Full Join
• Crossed Join and Union Join

5. Using Transactions

• Integrity
• Concurrence and locking
• Transaction control
• COMMIT and ROLLBACK
• Transaction constraints

6. Stored Procedures and Triggers

• Stored procedures
• Advantages of using a stored procedure
• Example of a store procedure
• Triggers
• Example of a trigger
• Trigger with conditions
• BLOB fields
• Query optimization
• General optimizations
• Introduction to database security

 

MySQL course

• Features and benefits of MySQL
• Find information about products, support and training
• Install and start the MySQL server
• Basics of Relational Databases
• SQL and MySQL languages
• Understand Data/Column types with regard to efficient database design
• View a database design structure/content
• Create a database design using an efficient structure
• Extract basic database information using the SELECT command
• Troubleshoot syntax and understand typical warnings and errors
• Delete or modify a database
• Delete or modify table row data
• Grouping query data with Aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use of Simple Functions (String, Date, Numerical)
• Primary methods for exporting and importing data

 

MySQL Training

Relational Database Basics

• Brief History of SQL
• Relational Databases
• Popular Databases
• SQL Statements

Simple SELECTs with MySQL

• Introduction to the Northwind Database
• Some Basics
• SELECTing All Columns in All Rows
• Exploring the Tables
• SELECTing Specific Columns
• Sorting Records
• The WHERE Clause and Operator Symbols
• The WHERE Clause and Operator Words
• Checking Multiple Conditions
• Writing SELECTs with Multiple Conditions

Advanced SELECTs with MySQL

• Calculated Fields
• Aggregate Functions and Grouping
• Built-in Data Manipulation Functions

Subqueries, Joins, and Unions with MySQL

• Subqueries
• Joins
• Outer Joins
• Unions

Inserting, Updating and Deleting Records with MySQL

• INSERT
• UPDATE
• DELETE

Creating and Modifying Tables with MySQL

• Creating Tables
• Datatypes
• Altering Tables
• Renaming Tables
• Dropping Tables

Views and Stored Procedures

• Creating Views with MySQL
• Dropping Views
• Creating Stored Procedures
• Benefits of Stored Procedures

 

 

All programming courses:

• HTML Training
• XHTML Training
• XML Training
• CSS Training
• ActionScript Training
• Javascript Training
• Ajax Training
• PHP Training
• SQL Training
• Visual Basic Training
• Visual Studio Training
• C Training
• C# Training
• C++ Training
• ASP.net Training
• VB.Net Training
• Webservices Training
• Java Training
• Linux shell programming Training
• Delphi Training
• Cobol Training
• Object Oriented Programming
• Unified Modeling Language
• Flex

Some clients: Cefora, IBM, Holcim, CBR, Total, Bpost, Cisco, Shape,Colruyt, Telelingua, Nestlé, CPAS Molenbeek, Fabricom, Club Med, NATO, G4S, Fonds de participation, Roularta, Georg Fischer, SGC, STIB, Federal Police, Flemish Government, KBC, Fortis, ING, Tetrapak, Royal Canin, GSK, ULB, Starwood hotels, Jetair, Belgacom, VRT, National Bank of Belgium,...

More computer training in Brussels