Lynda.com- SQL Essential Training

Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it's all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course.
Released on: 4/8/2009
Table of contents

1. Introduction
Introduction 1:36 20.5 MB
What is SQL? 1:26 1.4 MB
Understanding the terminology 3:37 3.6 MB
About the examples 2:27 2.7 MB
Setting up the test environment on a PC 8:28 15.8 MB
Setting up the example data on a PC 3:33 5.5 MB
Setting up the test environment on a Mac 10:46 16.3 MB
Setting up the example data on a Mac 3:56 4.1 MB
2. SQL Quick Start
Quick-start introduction 0:40 0.5 MB
Using the basic SELECT statement 1:34 1.6 MB
Selecting columns 5:54 4.9 MB
Selecting rows 2:35 2.4 MB
Counting things 3:48 2.9 MB
3. SQL Essentials
Organization: Databases and tables 1:24 1.7 MB
SQL syntax overview 2:08 1.7 MB
Formatting SQL 3:18 3.0 MB
Creating a database and tables 5:24 3.8 MB
Inserting data 2:22 1.9 MB
Reading tables with JOIN 5:18 4.4 MB
Filtering data with WHERE, LIKE, and IN 5:52 5.8 MB
Removing duplicates with DISTINCT 1:34 1.6 MB
Sorting with ORDER BY 4:09 3.7 MB
Updating data 1:48 1.5 MB
Deleting data 2:15 1.7 MB
4. IDs and Indexes
Creating relationships between tables 1:06 0.9 MB
Accessing related tables with JOIN 4:00 3.0 MB
About indexes 1:11 1.1 MB
5. Strings
About the string functions 2:48 2.3 MB
Finding the length of a string 1:12 1.1 MB
Finding part of a string 1:34 1.3 MB
Removing spaces with TRIM 2:22 1.7 MB
Making strings UPPERCASE and lowercase 0:51 0.8 MB
6. Numbers
When to use numeric functions 1:41 1.3 MB
Finding the absolute value 1:28 1.3 MB
Rounding numbers 1:56 1.7 MB
Integer division and remainders 4:08 3.8 MB
7. Dates
Dates and times 1:52 1.2 MB
Date- and time-related functions 2:16 1.8 MB
8. Aggregates
How aggregates work 3:38 3.1 MB
Removing duplicates with DISTINCT 0:59 0.8 MB
Using aggregate functions 2:36 2.3 MB
9. The CRUD Application
About the CRUD application 7:48 7.6 MB
The SELECT functions 5:46 6.8 MB
The INSERT functions 1:47 3.5 MB
The UPDATE functions 2:17 3.6 MB
The DELETE functions 3:02 3.8 MB
Conclusion
Goodbye 0:32 0.5 MB

Download: