Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Database for Beginners
Relational Databases
What are Databases? (15:49)
What is the Role of Databases in Application Programming (15:49)
Tables and Relations (15:49)
Primary and Foreign Keys, and Other Constraints (7:57)
Chapter 1 Lab Exercise
SQL Querying
What is Querying (15:49)
The ANSI SQL Standard (15:49)
DML, DDL and More (3:59)
Common Query Tools (3:59)
Chapter 2 Lab Exercise
Your First Queries
The SELECT Statement (15:49)
Limiting Output Columns (15:49)
Formatting and Sorting Output (6:17)
Column Aliases (15:49)
Chapter 3 Lab Exercise
Filtering your Results
The WHERE Clause (4:57)
Creating a Filter Condition (7:19)
Multiple Filter Conditions (15:49)
More Filter Operations (15:49)
Chapter 4 Lab Exercise
Consolidating your Data
Counting Records (15:49)
Common Aggregate Functions: SUM, AVG, MIN, MAX (15:49)
Do's and Don'ts when Consolidating (15:49)
Union and Other Multiset Consolidations (15:49)
Chapter 5 Lab Exercise
Grouping your Data
The GROUP BY Clause (15:49)
The HAVING Clause (15:49)
Do's and Don'ts when Grouping (15:49)
Chapter 6 Lab Exercise
Joining Tables
Table Aliases (6:54)
Inner Joins (15:49)
Outer Joins (15:49)
Self Joins (8:00)
Complex Multi Table Joins (15:49)
Chapter 7 Lab Exercise
Subqueries
Filtering Using Subqueries (8:00)
The EXISTS Clause (15:49)
Subqueries as Alternatives to Joins (15:49)
Derived Tables (15: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? (15:49)
Initiating a Transaction (15:49)
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 (15:49)
Developing and Calling Stored Procedures (10:41)
Implementing Triggers (10:41)
Chapter 11 Lab Exercise
Lab Solutions
The WHERE Clause
Download
4.1.zip
Complete and Continue