• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course SQL Essential Training Author Bill Weinman SKU ISBN Release Date 2009-04-08 Duration 2.22 hrs / 47 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags SQL

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 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 4. IDs and Indexes Creating relationships between tables 01:06 Accessing related tables with JOIN 04:00 About indexes 01:11 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 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 7. Dates Dates and times 01:52 Date- and time-related functions 02:16 8. Aggregates How aggregates work 03:38 Removing duplicates with DISTINCT 00:59 Using aggregate functions 02:36 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 Conclusion Goodbye 00:32