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 expression with REGEXP operator
- Useful MySQL specific group by functions (GROUP_CONCAT, etc.)
- GROUP BY WITH ROLLUP
- EXISTS, ALL, ANY
- Multitable OUTER JOIN
- Rewriting 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
Requirements
Good SQL knowledge.
Testimonials (5)
Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.
Kurt - Complete Coherence
Course - SQL For Data Science and Data Analysis
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The training materials.
Mona Dobre - DB Global Technology
Course - SQL Advanced level for Analysts
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.