Computer training mySQL

Computer training mySQL in English, French or Dutch

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 technical courses:

• Data modeling Training
• MySQL Training
• Oracle Training
• SQL server Training
• Windows XP Training
• Vista Training
• Windows 7 Training
• OS X Training
• Ubuntu Training
• CentOS Training
• Redhat Training
• Debian Training
• Windows 2003 server Training
• Windows 2008 server Training
• SQL server Training
• Exchange server Training
• Sharepoint server Training
• Linux server Training
• Apache Training
• WAN networks Training
• Wi-Fi Training
• Firewalls Training
• Network security Training
• IP6 Training
• Cisco Training
• VOIP Training
• Videoconference Training
• PC hardware Training
• PC configuration Training
• PC security Training

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 courses in Brussels