Video Lectures Help
Having trouble viewing lectures? Try changing players. Your current player format is html5. Change to flash.
Introduction
(collapsed, click to expand)- Completed Introduction to the course (14 min)
Relational Databases
(collapsed, click to expand)- Completed The relational model (9 min)
- Completed Querying relational databases (6 min)
XML Data
(collapsed, click to expand)- Completed Well-formed XML (13 min)
- Completed DTDs, IDs & IDREFs (18 min)
- Completed XML Schema (13 min)
JSON Data
(collapsed, click to expand)- Completed Introduction to JSON data (14 min)
- Completed JSON demo (22 min)
Relational Algebra
Prerequisite: Relational Databases
(collapsed, click to expand)- Completed Select, project, join (18 min)
- Completed Set operators, renaming, notation (20 min)
SQL
Prerequisite: Relational Databases; Recommended: Relational Algebra
(collapsed, click to expand)- Completed Introduction to SQL (5 min)
- Completed Basic SELECT statement (10 min)
- Completed Table variables and set operators (11 min)
- Completed Subqueries in WHERE clause (20 min)
- Completed Subqueries in FROM and SELECT (8 min)
- Completed The JOIN family of operators (25 min)
- Completed Aggregation (25 min)
- Completed NULL values (6 min)
- Completed Data modification statements (15 min)
Relational Design Theory
Prerequisite: Relational Algebra
(collapsed, click to expand)- Completed Relational design overview (16 min)
- Completed Functional dependencies (28 min)
- Completed Boyce-Codd normal form (23 min)
- Completed Multivalued dependencies, 4th normal form (24 min)
- Completed Shortcomings of BCNF/4NF (12 min)
Querying XML
Prerequisite: XML Data
(collapsed, click to expand)- Completed XPath introduction
- Completed XPath demo (22 min)
- Completed XQuery introduction (5 min)
- Completed XQuery demo (16 min)
- Completed XSLT (23 min)
Unified Modeling Language (UML)
Prerequisite: Relational Databases
(collapsed, click to expand)- Completed UML data modeling (25 min)
- Completed UML to relations (28 min)
Indexes
Prerequisite: SQL
(collapsed, click to expand)- Completed Indexes (14 min)
Constraints and Triggers
Prerequisite: SQL
(collapsed, click to expand)- Completed Motivation and overview (13 min)
- Completed Constraints of several types (26 min)
- Completed Referential integrity (22 min)
- Completed Triggers introduction (15 min)
- Completed Triggers demo (part 1) (30 min)
- Completed Triggers demo (part 2) (13 min)
Transactions
Prerequisite: SQL
(collapsed, click to expand)- Completed Introduction to transactions (14 min)
- Completed Transaction properties (13 min)
- Completed Isolation levels (18 min)
Views
Prerequisite: SQL, Constraints and Triggers
(collapsed, click to expand)- Completed Defining and using views (14 min)
- Completed View modifications - introduction (9 min)
- Completed View modifications using triggers (33 min)
- Completed Automatic view modifications (23 min)
- Completed Materialized views (16 min)
Authorization
Prerequisite: SQL, Views
(collapsed, click to expand)- Completed Authorization (11 min)
Recursion in SQL
Prerequisite: SQL
(collapsed, click to expand)- Completed Basic recursive WITH statement - introduction (12 min)
- Completed Basic recursive WITH statement - demo (30 min)
- Completed Nonlinear and mutual recursion (21 min)
On-Line Analytical Processing (OLAP)
Prerequisite: SQL
(collapsed, click to expand)- Completed Introduction to OLAP (18 min)
- Completed OLAP demo (27 min)
NoSQL Systems
Prerequisite: SQL
(collapsed, click to expand)- Completed NoSQL Motivation (20 min)
- Completed NoSQL Overview (27 min)