Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to SQL Training
Class Files
Class Files and Setup
Relational Database Basics
Brief History of SQL
Relational Databases
Popular Databases
SQL Statements
Relational Database Concepts (6:25)
Simple SELECTs
Introduction to the Northwind Database
Exploring the Tables
SELECTing Specific Columns
Using SELECT Demo (6:15)
SELECTing Specific Columns (Exercise)
Sorting Records
Sorting Demo (5:06)
Sorting Results
The WHERE Clause and Operator Symbols
WHERE Clause Demo (6:51)
Using the WHERE clause to check for equality or inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
Using WHERE and ORDER BY Together
The WHERE Clause and Operator Words
WHERE Clause Operators Demo (5:51)
More SELECTs with WHERE
Checking Multiple Conditions
Multiple Conditions Demo (7:20)
Writing SELECTs with Multiple Conditions
Advanced SELECTs
Calculated Fields
Calculated Fields Demo (7:34)
Calculating Fields
Aggregate Functions and Grouping
Aggregate Functions Demo (6:54)
Working with Aggregate Functions
Built-in Data Manipulation Functions
Data Manipulation Demo (9:35)
Data Manipulation Functions
Subqueries, Joins and Unions
Subqueries
Subquery Demo (6:21)
Subqueries (Exercise)
Joins
Using Joins Demo (8:43)
Using Joins
Outer Joins
Unions
Outer Joins and Unions (8:34)
Working with Unions
Conditional Processing with CASE
Using CASE
Using Case Demo (8:18)
Working with CASE
Inserting, Updating and Deleting Records
INSERT
INSERT Demo (5:44)
Inserting Records
UPDATE and DELETE
UPDATE and DELETE Demo (5:54)
Updating and Deleting Records
Using the WHERE clause to check for equality or inequality
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock