SQL: STRUCTURED QUERY LANGUAGE
Course Overview
Objective: To introduce you to SQL so that you can effectively write
SQL to extract, update and delete data from/in a database. You will
also have an understanding of the principles governing Relational Databases
and how to use them with SQL.
Introduction: 1 day
Overview of SQL
The SELECT statement
Sorting Retrieved Data
Filtering Data
Calculated Fields
Inserting Data
Updating Records
Deleting Records
Understanding the Principles of Relational Databases
Using a Relational Database to Retrieve Data
Intermediate: 1 day
Brief Review of Select Statements
Include info on Comparison Operators - perhaps most part use exercises
to gauge how well they know the basics of SQL
Advanced Select Statements
Distinct
SELECT INTO
Ordering Data
Using AND & OR for comparison
Group By
SQL IN (and NOT IN)
SQL BETWEEN …. AND (and NOT BETWEEN)
SQL HAVING
Mathematical Operators - Advanced
SQL Aliases
SQL Joins
INNER JOINS
LEFT JOIN
RIGHT JOIN
SQL UNION
UNION ALL
Modifying the Database
SQL Creating Indexes
SQL Creating Tables
SQL Creating Databases
SQL DROP
Truncating Tables
SQL ALTER TABLE
SQL Functions
Aggregate Functions
Aggregate Functions and Access
Aggregate Functions and SQL Server
Scalar Functions