Lynda.com - SQL Essential Training

Lynda.com - SQL Essential Training

Quote:

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

	Code: http://www.duckload.com/dl/g5LA2 http://www.duckload.com/dl/qNLA2