Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Database for Beginners
Relational Databases
What are Databases? (7:24)
What is the Role of Databases in Application Programming (7:57)
Tables and Relations (7:57)
Primary and Foreign Keys, and Other Constraints (7:57)
Chapter 1 Lab Exercise
SQL Querying
What is Querying (2:40)
The ANSI SQL Standard (3:59)
DML, DDL and More (3:59)
Common Query Tools (3:59)
Chapter 2 Lab Exercise
Your First Queries
The SELECT Statement (6:17)
Limiting Output Columns (6:17)
Formatting and Sorting Output (6:17)
Column Aliases (6:19)
Chapter 3 Lab Exercise
Filtering your Results
The WHERE Clause (4:57)
Creating a Filter Condition (7:19)
Multiple Filter Conditions (7:19)
More Filter Operations (7:19)
Chapter 4 Lab Exercise
Consolidating your Data
Counting Records (5:14)
Common Aggregate Functions: SUM, AVG, MIN, MAX (5:14)
Do's and Don'ts when Consolidating (8:38)
Union and Other Multiset Consolidations (8:38)
Chapter 5 Lab Exercise
Grouping your Data
The GROUP BY Clause (8:38)
The HAVING Clause (5:36)
Do's and Don'ts when Grouping (5:36)
Chapter 6 Lab Exercise
Joining Tables
Table Aliases (6:54)
Inner Joins (6:54)
Outer Joins (14:08)
Self Joins (8:00)
Complex Multi Table Joins (8:00)
Chapter 7 Lab Exercise
Subqueries
Filtering Using Subqueries (8:00)
The EXISTS Clause (6:49)
Subqueries as Alternatives to Joins (6:49)
Derived Tables (6:49)
Chapter 8 Lab Exercise
Manipulating your Data
The INSERT Statement (20:46)
The UPDATE Statement (12:50)
The DELETE Statement (12:50)
Chapter 9 Lab Exercise
Transaction Control
What are Transactions? (5:24)
Initiating a Transaction (5:24)
The COMMIT and ROLLBACK Commands (5:24)
Chapter 10 Lab Exercise
Creating Database Objects and Adding Business Logic
Creating Tables (5:24)
Creating and Using Views (5:24)
Developing and Calling Stored Procedures (10:41)
Implementing Triggers (10:41)
Chapter 11 Lab Exercise
Lab Solutions
Subqueries as Alternatives to Joins
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock