Course Length:

2 Days

Course Description:

This MySQL training course is designed for students new to writing SQL queries using MySQL.

Who Should Attend:

Students new to writing SQL queries using MySQL will benefit from this course.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Understand how MySQL works
• Use SQL to output reports with MySQL
• Modify MySQL data with SQL
• Create a simple MySQL database

Prerequisites:

There are no prerequisites for this course.

Course Outline:

• Relational Database Basics
  1. Brief History of SQL
  2. Relational Databases
  3. Popular Databases
  4. SQL Statements
• Simple SELECTs with MySQL
  1. Introduction to the Northwind Database
  2. Some Basics
  3. SELECTing All Columns in All Rows
  4. Exploring the Tables
  5. SELECTing Specific Columns
  6. Sorting Records
  7. The WHERE Clause and Operator Symbols
  8. The WHERE Clause and Operator Words
  9. Checking Multiple Conditions
  10. Writing SELECTs with Multiple Conditions
• Advanced SELECTs with MySQL
  1. Calculated Fields
  2. Aggregate Functions and Grouping
  3. Built-in Data Manipulation Functions
• Subqueries, Joins, and Unions with MySQL
  1. Subqueries
  2. Joins
  3. Outer Joins
  4. Unions
• Inserting, Updating and Deleting Records with MySQL
  1. INSERT
  2. UPDATE
  3. DELETE
• Creating and Modifying Tables with MySQL
  1. Creating Tables
  2. Datatypes
  3. Altering Tables
  4. Renaming Tables
  5. Dropping Tables
• Views and Stored Procedures
  1. Creating Views with MySQL
  2. Dropping Views
  3. Creating Stored Procedures
  4. Benefits of Stored Procedures