on-demand course

Learning SQL

with Ben Forta

July 2015

Beginner to intermediate

2h 44m

English

Pearson

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Learning SQL LiveLessons: Introduction
2m 10s
Learning Objectives
44s
1.1 Review database basics
6m 58s
1.2 Choose a DBMS
3m 3s
1.3 Get ready to learn SQL
35s
Learning Objectives
40s
2.1 Use the SELECT statement
1m 14s
2.2 Retrieve individual columns
2m 24s
2.3 Retrieve multiple columns
1m 11s
2.4 Retrieve all columns
1m 55s
2.5 Retrieve distinct rows
1m 6s
2.6 Limit retrieved data
1m 53s
2.7 Refine your SQL skills
5m 25s
Summary
50s
Learning Objectives
20s
3.1 Use ORDER BY
1m 49s
3.2 Sort by one column
1m 28s
3.3 Sort by multiple columns
2m 39s
3.4 Specify sort direction
1m 38s
Summary
42s
Learning Objectives
27s
4.1 Use WHERE
1m 21s
4.2 Use WHERE clause operators
4m 28s
4.3 Filter using a range
1m 5s
4.4 Filter for no value
1m 59s
Summary
1m 16s
Learning Objectives
30s
5.1 Combine WHERE clauses
3m 1s
5.2 Understand order of evaluation
3m 37s
5.3 Filter using IN
2m 2s
5.4 Negate using NOT
1m 19s
Summary
48s
Learning Objectives
21s
6.1 Filter using LIKE
7m 38s
Summary
47s
Learning Objectives
34s
7.1 Use concatenation
3m 41s
7.2 Use aliases
2m 18s
7.3 Perform mathematical calculations
2m 1s
Summary
39s
Learning Objectives
33s
8.1 Use string functions
4m 3s
8.2 Use date functions
3m 10s
Summary
51s
Learning Objectives
28s
9.1 Use aggregate functions
5m 50s
Summary
38s

Content preview from Learning SQL

13.3 Create an outer join

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Learning SQL

Guy Vaccaro

Learning SQL, 3rd Edition

Alan Beaulieu

Practical SQL

Anthony DeBarros

Head First SQL

Lynn Beighley

Publisher Resources

ISBN: 9780134193700

Learning SQL

with Ben Forta

Introduction

Lesson 1: Introducing SQL

Lesson 2: Retrieving Data

Lesson 3: Sorting Retrieved Data

Lesson 4: Filtering Data

Lesson 5: Advanced Data Filtering

Lesson 6: Using Wildcard Filtering

Lesson 7: Creating Calculated Fields

Lesson 8: Using Data Manipulation Functions

Lesson 9: Summarizing Data

Lesson 10: Grouping Data

Lesson 11: Working with Subqueries

Lesson 12: Joining Tables

Lesson 13: Creating Advanced Joins

Lesson 14: Combining Queries

Lesson 15: Inserting Data

Lesson 16: Updating and Deleting Data

Lesson 17: Where to Go from Here

Summary

Content preview from Learning SQL

13.3 Create an outer join

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.