SQL Essentials

Course Outline

1. Introduction
   • What is SQL?
   • Installation Environment

2. SQL Quick Start
   • Quick-start introduction
   • Save Quick-start introduction
   • Using the basic SELECT statement
   • Save Using the basic SELECT statement
   • Selecting rows
   • Save Selecting rows
   • Selecting columns
   • Save Selecting columns
   • Counting rows
   • Save Counting rows
   • Inserting data
   • Save Inserting data
   • Updating data
   • Save Updating data
   • Deleting data
   • Save Deleting data

3. Fundamentals
   • Databases and tables
   • Save Databases and tables
   • SQL syntax overview
   • Save SQL syntax overview
   • Formatting SQL
   • Save Formatting SQL
   • Creating tables
   • Save Creating tables
   • Deleting a table with DROP TABLE
   • Save Deleting a table with DROP TABLE
   • Inserting rows into a table
   • Save Inserting rows into a table
   • Deleting rows from a table
   • Save Deleting rows from a table
   • Understanding NULL
   • Save Understanding NULL
   • Controlling column behaviors with constraints
   • Save Controlling column behaviors with constraints
   • Changing a schema with ALTER
   • Save Changing a schema with ALTER
   • Creating an ID column
   • Save Creating an ID column
   • Filtering data with WHERE, LIKE, and IN
   • Save Filtering data with WHERE, LIKE, and IN
   • Removing duplicates with SELECT DISTINCT
   • Save Removing duplicates with SELECT DISTINCT
   • Sorting with ORDER BY
   • Save Sorting with ORDER BY
   • Conditional expressions with CASE
   • Save Conditional expressions with CASE

4. Relationships
   • Understanding joins
   • Save Understanding joins
   • Accessing related tables with JOIN
   • Save Accessing related tables with JOIN
   • Using multiple related tables
   • Save Using multiple related tables

5. Strings
   • About SQL strings
   • Save About SQL strings
   • Finding the length of a string
   • Save Finding the length of a string
   • Selecting part of a string
   • Save Selecting part of a string
   • Removing spaces with TRIM
   • Save Removing spaces with TRIM
   • Making strings uppercase and lowercase
   • Save Making strings uppercase and lowercase

6. Numbers
   • About numeric types
   • Save About numeric types
   • Finding the type of a value
   • Save Finding the type of a value
   • Integer division and remainders
   • Save Integer division and remainders
   • Rounding numbers
   • Save Rounding numbers

7. Dates
   • Dates and times
   • Save Dates and times
   • Date- and time-related functions
   • Save Date- and time-related functions

8. Aggregates
   • How aggregates work
   • Save How aggregates work
   • Using aggregate functions
   • Save Using aggregate functions
   • Aggregating DISTINCT values
   • Save Aggregating DISTINCT values

9. Transactions
   • Why use transactions?
   • Save Why use transactions?
   • Using transactions
   • Save Using transactions

10. Triggers
    • Updating a table with a trigger
    • Save Updating a table with a trigger
    • Preventing automatic updates with a trigger
    • Save Preventing automatic updates with a trigger
    • Automating timestamps with a trigger
    • Save Automating timestamps with a trigger

11. Subselects and Views
    • Creating a simple subselect
    • Save Creating a simple subselect
    • Searching within a result set
    • Save Searching within a result set
    • Creating a view
    • Save Creating a view
    • Creating a joined view
    • Save Creating a joined view

12. A Simple CRUD Application
    • Touring the CRUD application
    • Save Touring the CRUD application
    • The SELECT functions
    • Save The SELECT functions
    • The INSERT, UPDATE, and DELETE functions
    • Save The INSERT, UPDATE, and DELETE functions