Video Tutorial SQL Free Download

This video can run with Quick Time Player

Introduction
01. Introduction
02. What is SQL
03. Understanding the terminology
04. About the examples
05. Setting up the test environment on a PC
06. Setting up the example data on a PC
07. Setting up the test environment on a Mac
08.Setting up the example data on a Mac


SQL Quick Start
01. Quick-start introduction
02. Using the basic SELECT statement
03. Selecting columns
04. Selecting rows
05. Counting things


SQL Essentials
01. Organization Databases and tables
02. SQL syntax overview
03. Formatting SQL
04. Creating a database and tables
05. Inserting data
06. Reading tables with JOIN
07. Filtering data with WHERE LIKE and IN
08. Removing duplicates with DISTINCT
09. Sorting with ORDER BY
10. Updating data
11. Deleting data

IDs and Indexes
01. Creating relationships between tables
02. Accessing related tables with JOIN
03. About indexes

Strings
01. About the string functions
02. Finding the length of a string
03. Finding part of a string
04. Removing spaces with TRIM
05. Making strings UPPERCASE and lowercase

Numbers
01. When to use numeric functions
02. Finding the absolute value
03. Rounding numbers
04. Integer division and remainders

Dates
01. Dates and times
02. Date and time-related functions

Aggregates
01. How aggregates work
02. Removing duplicates with DISTINCT
03. Using aggregate functions

The CRUD Application
01. About the CRUD application
02. The SELECT functions
03. The INSERT functions
04. The UPDATE functions
05. The DELETE functions
06. Goodbye