SQL Essential Training Training DVD

1. Introduction

• Introduction
• What is SQL?
• Understanding the terminology
• About the examples
• Setting up the test environment on a PC
• Setting up the example data on a PC
• Setting up the test environment on a Mac
• Setting up the example data on a Mac

2. SQL Quick Start

• Quick-start introduction
• Using the basic SELECT statement
• Selecting columns
• Selecting rows
• Counting things

3. SQL Essentials

• Organization: Databases and tables
• SQL syntax overview
• Formatting SQL
• Creating a database and tables
• Inserting data
• Reading tables with JOIN
• Filtering data with WHERE, LIKE, and IN
• Removing duplicates with DISTINCT
• Sorting with ORDER BY
• Updating data
• Deleting data

4. IDs and Indexes

• Creating relationships between tables
• Accessing related tables with JOIN
• About indexes

5. Strings

• About the string functions
• Finding the length of a string
• Finding part of a string
• Removing spaces with TRIM
• Making strings UPPERCASE and lowercase

6. Numbers

• When to use numeric functions
• Finding the absolute value
• Rounding numbers
• Integer division and remainders

7. Dates

• Dates and times
• Date- and time-related functions

8. Aggregates

• How aggregates work
• Removing duplicates with DISTINCT
• Using aggregate functions

9. The CRUD Application

• About the CRUD application
• The SELECT functions
• The INSERT functions
• The UPDATE functions
• The DELETE functions

Conclusion

• Goodbye