Introduction to SQL Training using MySQL

This SQL class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.

Brief History of SQL
Relational Databases
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Commercial Databases
Popular Open Source Databases
Valid Object References
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)

Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
Sorting Results
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
Using the WHERE clause to check for equality or inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
Using WHERE and ORDER BY Together
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
More SELECTs with WHERE
Checking Multiple Conditions
AND
OR
Order of Evaluation
Writing SELECTs with Multiple Conditions

Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Calculating Fields
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Selecting Distinct Records
Working with Aggregate Functions
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Data Manipulation Functions

Subqueries
Subqueries
Joins
Table Aliases
Multi-table Joins
Using Joins
Outer Joins
Unions
UNION ALL
UNION Rules
Working with Unions

Using CASE
Working with CASE

INSERT
Inserting Records
UPDATE
DELETE
Updating and Deleting Records

Data Types
Creating Tables
NULL Values
Primary Keys
Foreign Keys
Creating Tables
Adding and Dropping Columns
Renaming Tables
SQL Server
Oracle and MySQL
Dropping Tables

Creating Views
Dropping Views
Benefits of Views
Creating a View

Creating Stored Procedures
Dropping Stored Procedures
Creating a Stored Procedure
Benefits of Stored Procedures