Module 1: Database Overview-Course Welcome
Course Overview
()
Instructor Welcome
()
Syllabus
Module 1: Database Overview-Module 1 Introduction
Introduction to Relational Databases
()
Database Introductory Resources
Before the Advent of Database Systems
Module 1: Database Overview-Lesson 1: Database Intuitions
Ch. 2 and 3 - Database Design
Database Application
()
Database Application Videos
Example Database Healthcare Management
()
Data Management for Manufacturing
Module 1: Database Overview-Lesson 2: Relational Database Management Systems
Ch. 4 and 5 - Database Design
Relational Database Management Systems
()
Module 1: Database Overview-Lesson 3: The Relational Model
Ch. 7 - Database Design
The Relational Model
()
Module 1: Database Overview-Module 1 Summary
Module 1 Summary
Module 2: Relational Algebra-Module 2 Introduction
Ch. 7 - Database Design and Ch. 1 - The Theory of Relational Databases
Relational Algebra Intro
()
Relational Algebra Concepts
()
Module 2: Relational Algebra-Lesson 1: Basic and Set Operations
Ch. 2 - Theory of Relational Databases
Relational Algebra Basic Operations
()
Module 2: Relational Algebra-Lesson 2: Joins
Ch. 16 - Database Design and Ch. 3 - The Theory of Relational Databases
Relational Algebra Joins
()
Relational Algebra Transforming Data
()
Module 2: Relational Algebra-Lesson 3: Complex Operations
Ch. 3 - The Theory of Relational Databases
Relational Algebra Division
()
Relational Algebra Modification
()
Module 2: Relational Algebra-Module 2 Summary
Module 2 Summary
Module 3: SQL-Module 3 Introduction
Introduction to SQL Language
()
Relational Query Languages: Introductory Reading
Module 3: SQL-Lesson 1: SELECT
Ch. 16 - Database Design
SQL Operation: SELECT
()
Module 3: SQL-Lesson 2: JOINs and Complex Queries
Ch. 16 - Database Design
SQL Operation: JOINs
()
Table Relationships
()
Complex Queries
()
Modifying Data
()
Module 3: SQL-Lesson 3: Data Definition Language
Ch. 15 - Database Design
Data Definition Language: Tables
()
Referential Integrity
()
Data Definition Language: Index
()
Data Definition Language: Views
()
Access Control
()
Conclusion
()
Module 3: SQL-Module 3 Summary
Module 3 Summary