Lynda.com SQL Essential Training 2010
1. Introduction
Introduction 01:36 41.0 MB
What is SQL? 01:26 2.0 MB
Understanding the terminology 03:37 4.9 MB
About the examples 02:27 4.0 MB
Setting up the test environment on a PC 08:28 15.0 MB
Setting up the example data on a PC 03:33 5.4 MB
Setting up the test environment on a Mac 10:46 16.0 MB
Setting up the example data on a Mac 03:56 5.0 MB
14:31 2. SQL Quick Start
Quick-start introduction 00:40 0.6 MB
Using the basic SELECT statement 01:34 2.0 MB
Selecting columns 05:54 7.0 MB
Selecting rows 02:35 3.0 MB
Counting things 03:48 4.0 MB
35:32 3. SQL Essentials
Organization: Databases and tables 01:24 2.0 MB
SQL syntax overview 02:08 2.3 MB
Formatting SQL 03:18 4.0 MB
Creating a database and tables 05:24 5.0 MB
Inserting data 02:22 3.0 MB
Reading tables with JOIN 05:18 5.5 MB
Filtering data with WHERE, LIKE, and IN 05:52 7.0 MB
Removing duplicates with DISTINCT 01:34 2.0 MB
Sorting with ORDER BY 04:09 5.0 MB
Updating data 01:48 2.0 MB
Deleting data 02:15 3.0 MB
06:17 4. IDs and Indexes
Creating relationships between tables 01:06 2.0 MB
Accessing related tables with JOIN 04:00 4.0 MB
About indexes 01:11 2.0 MB
08:47 5. Strings
About the string functions 02:48 3.0 MB
Finding the length of a string 01:12 1.6 MB
Finding part of a string 01:34 2.0 MB
Removing spaces with TRIM 02:22 3.0 MB
Making strings UPPERCASE and lowercase 00:51 0.9 MB
09:13 6. Numbers
When to use numeric functions 01:41 2.0 MB
Finding the absolute value 01:28 2.0 MB
Rounding numbers 01:56 3.0 MB
Integer division and remainders 04:08 5.0 MB
04:08 7. Dates
Dates and times 01:52 2.0 MB
Date- and time-related functions 02:16 3.0 MB
07:13 8. Aggregates
How aggregates work 03:38 4.0 MB
Removing duplicates with DISTINCT 00:59 1.0 MB
Using aggregate functions 02:36 3.0 MB
20:40 9. The CRUD Application
About the CRUD application 07:48 8.0 MB
The SELECT functions 05:46 7.0 MB
The INSERT functions 01:47 3.0 MB
The UPDATE functions 02:17 3.0 MB
The DELETE functions 03:02 4.0 MB
00:32 Conclusion
Goodbye 00:32 0.5 MB
Download
http://hotfile.com/list/584079/12a7dd3