Advanced MySQL Queries

Posted on by

This 1 day 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.

Goals

  • Learn to do conditional processing.
  • Learn to use ROLLUP and GROUP_CONCAT.
  • Learn to use character and non-character SQL functions.
  • Learn to use the LIMIT clause in SELECT and DML statements.
  • Learn to examine database components.

Outline

  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

To Hire an AMS MySQL Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!

Related posts:

  1. MySQL Development Training
  2. Advanced Crystal Reports 2011
  3. Advanced JavaScript Programming
  4. jQuery Fundamentals Training

Leave a Reply