Books & Videos

Table of Contents

Chapter: Introduction

Learning SQL LiveLessons: Introduction

02m 10s

Chapter: Lesson 1: Introducing SQL

Learning Objectives

00m 44s

1.1 Review database basics

06m 57s

1.2 Choose a DBMS

03m 3s

1.3 Get ready to learn SQL

00m 36s

Chapter: Lesson 2: Retrieving Data

Learning Objectives

00m 40s

2.1 Use the SELECT statement

01m 14s

2.2 Retrieve individual columns

02m 23s

2.3 Retrieve multiple columns

01m 11s

2.4 Retrieve all columns

01m 55s

2.5 Retrieve distinct rows

01m 5s

2.6 Limit retrieved data

01m 52s

2.7 Refine your SQL skills

05m 25s

Summary

00m 50s

Chapter: Lesson 3: Sorting Retrieved Data

Learning Objectives

00m 20s

3.1 Use ORDER BY

01m 49s

3.2 Sort by one column

01m 28s

3.3 Sort by multiple columns

02m 39s

3.4 Specify sort direction

01m 38s

Summary

00m 42s

Chapter: Lesson 4: Filtering Data

Learning Objectives

00m 27s

4.1 Use WHERE

01m 20s

4.2 Use WHERE clause operators

04m 28s

4.3 Filter using a range

01m 5s

4.4 Filter for no value

01m 58s

Summary

01m 16s

Chapter: Lesson 5: Advanced Data Filtering

Learning Objectives

00m 31s

5.1 Combine WHERE clauses

03m 0s

5.2 Understand order of evaluation

03m 37s

5.3 Filter using IN

02m 2s

5.4 Negate using NOT

01m 19s

Summary

00m 48s

Chapter: Lesson 6: Using Wildcard Filtering

Learning Objectives

00m 22s

6.1 Filter using LIKE

07m 38s

Summary

00m 47s

Chapter: Lesson 7: Creating Calculated Fields

Learning Objectives

00m 34s

7.1 Use concatenation

03m 41s

7.2 Use aliases

02m 17s

7.3 Perform mathematical calculations

02m 0s

Summary

00m 39s

Chapter: Lesson 8: Using Data Manipulation Functions

Learning Objectives

00m 33s

8.1 Use string functions

04m 2s

8.2 Use date functions

03m 10s

Summary

00m 51s

Chapter: Lesson 9: Summarizing Data

Learning Objectives

00m 28s

9.1 Use aggregate functions

05m 49s

Summary

00m 39s

Chapter: Lesson 10: Grouping Data

Learning Objectives

00m 28s

10.1 Use GROUP BY

02m 56s

10.2 Use HAVING

03m 34s

Summary

00m 46s

Chapter: Lesson 11: Working with Subqueries

Learning Objectives

00m 36s

11.1 Use subqueries with WHERE

04m 52s

11.2 Use subqueries as calculated fields

02m 47s

Summary

00m 47s

Chapter: Lesson 12: Joining Tables

Learning Objectives

00m 29s

12.1 Create a basic join

05m 38s

12.2 Join multiple tables

02m 31s

Summary

00m 40s

Chapter: Lesson 13: Creating Advanced Joins

Learning Objectives

00m 33s

13.1 Use table aliases

02m 33s

13.2 Create a self-join

03m 7s

13.3 Create an outer join

02m 52s

13.4 Use joins with aggregate functions

01m 46s

Summary

00m 45s

Chapter: Lesson 14: Combining Queries

Learning Objectives

00m 31s

14.1 Use a UNION

02m 57s

14.2 Include/exclude duplicates

01m 17s

14.3 Sort combined queries

01m 20s

Summary

00m 46s

Chapter: Lesson 15: Inserting Data

Learning Objectives

00m 34s

15.1 Insert a row

02m 49s

15.2 Insert retrieved data

01m 19s

15.3 Copy to another table

01m 3s

Summary

00m 50s

Chapter: Lesson 16: Updating and Deleting Data

Learning Objectives

00m 27s

16.1 Update a row

02m 38s

16.2 Delete a row

01m 5s

Summary

01m 37s

Chapter: Lesson 17: Where to Go from Here

Learning Objectives

00m 36s

17.1 Understand table manipulation

03m 34s

17.2 Understand views

01m 50s

17.3 Understand stored procedures

01m 33s

17.4 Be familiar with a few more

04m 42s

Summary

00m 20s

Chapter: Summary

Learning SQL LiveLessons: Summary

00m 56s