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.

  7 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Related Courses

Related Categories