
Advanced MySQL Queries
Course Length:
Delivery Methods:
Next Live Class:Apr 23, 2021 10AM-5PM ET
Course Topics
- 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.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Private classes are delivered for groups at your offices or a location of your choice.
Course Overview
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.
Course Outline
- Conditional Processing
- The IF Function
- The IFNULL Function
- The NULLIF Function
- The Case Expression
- Enhancing Groups With GROUP_CONCAT and ROLLUP
- About Group Processing
- Simple GROUP BY
- GROUP_CONCAT
- ROLLUP Function
- ROLLUP with IFNULL Function
- SQL Functions (Character)
- What Are SQL Functions?
- Character Functions
- Regular Expressions
- SQL Functions (Non-Character)
- Numeric Functions
- Date/Time Functions
- The LIMIT clause
- Using the LIMIT clause to display the first n records
- ORDER BY and LIMIT Clauses in UPDATE
- ORDER BY and LIMIT Clauses in DELETE
- Retrieving Database Information
- The SHOW and DESCRIBE Statements
- The INFORMATION_SCHEMA Tables
Class Materials
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this MySQL class:
- Basic SQL Skills
Prerequisite Courses
Courses that can help you meet these prerequisites:
Follow-on Courses
Register for a Live Class
$575.00
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors