SQL Advanced in MySQL Training Course

Training Course Outline: 

DQL (Data Query Language)

Correlation in FROM, WHERE, SELECT and HAVING clauses

Correlation and performance

Using CASE, IF, COALESCE functions

Using variables

Casting and converting

Dealing with NULL, NULL-safe operators

Using regular expresion with REGEXP operator

Usefull MySQL specific group by functions (GROUP_CONCAT, etc.)

GROUP BY WITH ROLLUP

EXISTS, ALL, ANY

Multitable OUTER JOIN

Reqriting subqueries as joins

DML (Data Modification Language)

Multi-row inserts

INSERT by SELECT

Using subqueries in DML statements

Using variables in DML queries

Locking tables and rows

Updating data in many tables

IGNORE clause

REPLACE clause

DELETE versus TRUNCATE

DDL (Data Definition Language)

Creating tables with select

Temporary tables

Stored Procedures

Short introduction to MySQL stored procedures

 

Code: 
sql02
Prerequisites: 

Good SQL knowledge.

Overview: 

This course has been created for people already acquainted with SQL. The course introduces you into secretes common to all SQL databases as well as MySQL specific syntax, functions and features.

Certification: 

NobleProg Certificate

Duration: 
8 teaching hours
Prices
Public: 
750 GBP per delegate

Public Course Dates

Datesort iconTraining OutlineVenueDetails/Book
2008-06-09 09:00 - 2008-06-09 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-07-08 09:00 - 2008-07-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-08-08 09:00 - 2008-08-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-09-08 09:00 - 2008-09-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-10-08 09:00 - 2008-10-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-11-08 09:00 - 2008-11-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-12-08 09:00 - 2008-12-08 17:00SQL Advanced in MySQL112/114 North Acton Road, NW10 6QH, LondonDetails/Book