Advanced MySQL Queries (SQL202)

This MySQL training class helps students master SQL using a MySQL database. The class is useful for people who have to write advanced reports against a MySQL database and for developers who will need to build applications with a MySQL backend.

1. Conditional Processing
   1. The IF Function
   2. The IFNULL Function
   3. The NULLIF Function
   4. The Case Expression
2. Enhancing Groups With GROUP_CONCAT and ROLLUP
   1. About Group Processing
   2. Simple GROUP BY
   3. GROUP_CONCAT
   4. ROLLUP Function
   5. ROLLUP with IFNULL Function
3. SQL Functions (Character)
   1. What Are SQL Functions?
   2. Character Functions
   3. Regular Expressions
4. SQL Functions (Non-Character)
   1. Numeric Functions
   2. Date/Time Functions
5. The LIMIT clause
   1. Using the LIMIT clause to display the first n records
   2. ORDER BY and LIMIT Clauses in UPDATE
   3. ORDER BY and LIMIT Clauses in DELETE
6. Retrieving Database Information
   1. The SHOW and DESCRIBE Statements
   2. The INFORMATION_SCHEMA Tables

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this MySQL class: