SQL and Table Design-Introduction and Why SQL
Introduction To The Course
()
Why SQL?
()
SQL and Table Design-Table Design
Table Design (Part 1 of 2)
()
Activity: Creating a Schema
Table Design (Part 2 of 2)
()
Reading: Schemas
Schema Building Exercise
()
SQL Database Terms-Database Terms
SQL Database Terms
Database Terms (Part 1 of 6)
()
Database Terms (Part 2 of 6)
()
Database Terms (Part 3 of 6)
()
Database Terms (Part 4 of 6)
()
Database Terms (Part 5 of 6)
()
Database Terms (Part 6 of 6)
()
More Database Terms to Know
Key Constraints and the USING Clause-Primary Key and Foreign Key Constraints
Primary Key Constraint (Part 1 of 2)
()
Primary Key Constraint (Part 2 of 2)
()
Primary Key Constraints
Foreign Key Constraint
()
Foreign Key Constraint and the Using Clause
()
Foreign Keys and the USING Clause
Functions, Subqueries, Pseudocolumns, and Views-Functions, Queries, Subqueries, and Pseudocolumns
Using SQL Functions within Queries
()
Subqueries
()
Subqueries Further Explained
More on Subqueries and Pseudocolumns
()
Functions, Subqueries, Pseudocolumns, and Views-Views
Views
()
Materialized Views
()
View versus Materialized View