Course Introduction-Specialization Introduction
Specialization Introduction video lesson
()
Get help and meet other learners in this course. Join your discussion forums!
Course Introduction-Course Introduction
Course introduction video lecture
()
Course Introduction-Course objectives
Course objectives video lecture
()
Powerpoint lecture notes for lesson 1
Course Introduction-Topics, assignments, and DBMS software
Topics and assignments video lecture
()
Powerpoint lecture notes for lesson 2
Optional textbook
Database management software requirements
Introduction to Databases and DBMSs-Database characteristics
Database characteristics video lecture
()
Powerpoint lecture notes for lesson 1
Introduction to Databases and DBMSs-Organizational roles
Organizational Roles video lecture
()
Powerpoint lecture notes for lesson 2
Introduction to Databases and DBMSs-DBMS overview and database definition feature
DBMS overview and database definition feature video lecture
()
Powerpoint lecture notes for lesson 3
Introduction to Databases and DBMSs-Non-procedural access
Non-procedural access video lecture
()
Powerpoint lecture notes for lesson 4
Introduction to Databases and DBMSs-Transaction processing overview
Transaction processing overview video lecture
()
Powerpoint lecture notes for lesson 5
Introduction to Databases and DBMSs-Data warehouse processing overview
Data warehouse processing overview video lecture
()
Powerpoint lecture notes for lesson 6
Introduction to Databases and DBMSs-DBMS technology evolution
DBMS technology evolution video lecture
()
Powerpoint lecture notes for lesson 7
Introduction to Databases and DBMSs-Concept Quiz and Review
Optional textbook reading
Relational Data Model and the CREATE TABLE Statement-Basics of relational databases
Basics of relational databases video lecture
()
Powerpoint lecture notes for lesson 1
Relational Data Model and the CREATE TABLE Statement-Integrity rules
Integrity rules video lecture
()
Powerpoint lecture notes for lesson 2
Relational Data Model and the CREATE TABLE Statement-Basic SQL CREATE TABLE statement
Basic SQL CREATE TABLE statement video lecture
()
Powerpoint lecture notes for lesson 3
University database SQL statements for Oracle and PostgreSQL
Relational Data Model and the CREATE TABLE Statement-Integrity constraint syntax
Integrity constraint syntax video lecture
()
Powerpoint lecture notes for lesson 4
Relational Data Model and the CREATE TABLE Statement-Assignment 1 Notes
Assignment 1 notes video lecture
()
Powerpoint lecture notes for lesson 5
Relational Data Model and the CREATE TABLE Statement-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading
DBMS installation and usage notes
Practice Problems for Module 3
Extra Problems for Module 3
Assignment for Module 3
Self Evaluation for the Module 3 assignment
Basic Query Formulation with SQL-SQL Overview
SQL Overview video lecture
()
Powerpoint lecture notes for lesson 1
Basic Query Formulation with SQL-SELECT statement introduction
SELECT statement introduction video lecture
()
Powerpoint lecture notes for lesson 2
Basic Query Formulation with SQL-Join Operator
Join Operator video lecture
()
Powerpoint lecture notes for lesson 3
Basic Query Formulation with SQL-Using join operations in SQL SELECT statements
Using Join operations in SQL SELECT statements video lecture
()
Powerpoint lecture notes for lesson 4
Basic Query Formulation with SQL-GROUP BY clause
GROUP BY clause video lecture
()
Powerpoint lecture notes for lesson 5
Basic Query Formulation with SQL-Concept Quiz, Lesson Examples, Practice Problems, and Assignment
Optional textbook reading
Lesson examples using SQL statements
Practice problems for Module 4
Extra problems for Module 4
Assignment for Module 4
Self evaluation for the Module 4 Assignment
DBMS installation and usage notes
Extended Query Formulation with SQL-Query formulation guidelines
Query formulation guidelines video lecture
()
Powerpoint lecture notes for lesson 1
Extended Query Formulation with SQL-Multiple table problems
Multiple table problems video lecture
()
Powerpoint lecture notes for lesson 2
Extended Query Formulation with SQL-Problems involving join and grouping operations
Problems involving join and grouping operations video lecture
()
Powerpoint lecture notes for lesson 3
Extended Query Formulation with SQL-SQL set operators
SQL set operators video lecture
()
Powerpoint lecture notes for lesson 4
Extended Query Formulation with SQL-SQL modification statements
SQL modification statements video lecture
()
Powerpoint lecture notes for lesson 5
Extended Query Formulation with SQL-Query Formulation Errors
Query formulation errors video lecture
()
Powerpoint lecture notes for lesson 6
Extended Query Formulation with SQL-Concept Quiz, Lesson Examples, Practice Problems, and Assignment
Optional textbook reading
Lesson examples using SQL statements
Practice problems for Module 5
Extra problems for Module 5
Assignment for Module 5
Self evaluation for the Module 5 assignment
DBMS installation and usage notes
Notation for Entity Relationship Diagrams-Database development goals
Database development goals video lecture
()
Powerpoint lecture notes for lesson 1
Notation for Entity Relationship Diagrams-Basic ERD notation
Basic ERD notation video lecture
()
Powerpoint lecture notes for lesson 2
Notation for Entity Relationship Diagrams-Relationship variations I
Relationship variations I video lecture
()
Powerpoint lecture notes for lesson 3
Notation for Entity Relationship Diagrams-Relationship variations II
Relationship variations II video lecture
()
Powerpoint lecture notes for lesson 4
Notation for Entity Relationship Diagrams-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading
Practice problems for Module 6
Assignment for Module 6
Self evaluation for the Module 6 assignment
ERD Rules and Problem Solving-Basic diagram rules
Basic diagram rules video lecture
()
Powerpoint lecture notes for lesson 1
ERD Rules and Problem Solving-Extended diagram rules
Extended diagram rules video lecture
()
Powerpoint lecture notes for lesson 2
ERD Rules and Problem Solving-ERD problems I
ERD problems I video lecture
()
Powerpoint lecture notes for lesson 3
ERD Rules and Problem Solving-ERD problems II
ERD problems II video lecture
()
Powerpoint lecture notes for lesson 4
ERD Rules and Problem Solving-ER Assistant Demonstration
ER Assistant Demonstration video
()
ER Assistant download
ERD Rules and Problem Solving-Visual Paradigm Demonstration
Software demonstration video for Visual Paradigm
()
Download for Visual Paradigm
ERD Rules and Problem Solving-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading material
Practice Problems for Module 7
Assignment for Module 7
Self evaluation for the Module 7 assignment
Developing Business Data Models-Conceptual data modeling goals and challenges
Conceptual data modeling goals and challenges
()
Powerpoint lecture notes for lesson 1 and extras
Developing Business Data Models-Analyzing narrative problems
Analyzing narrative problems
()
Powerpoint lecture notes for lesson 2
Developing Business Data Models-Design transformations I
Design transformations I
()
Powerpoint lecture notes for lesson 3
Developing Business Data Models-Design transformations II
Design transformations II video lecture
()
Powerpoint lecture notes for lesson 4
Developing Business Data Models-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading material
Practice problems for Module 8
Assignment for Module 8
Self evaluation for the Module 8 assignment
Data Modeling Problems and Completion of an ERD-Data modeling problems I
Data modeling problems I video lecture
()
Powerpoint lecture notes for lesson 1
Data Modeling Problems and Completion of an ERD-Data modeling problems II
Data modeling problems II video lecture
()
Powerpoint lecture notes for lesson 2
Data Modeling Problems and Completion of an ERD-Finalizing an ERD
Finalizing an ERD video lecture
()
Powerpoint lecture notes for lesson 3
Data Modeling Problems and Completion of an ERD-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading material
Practice Problems for Module 9
Assignment for Module 9
Self evaluation for the Module 9 assignment
Schema Conversion-Goals and steps of logical database design
Goals and steps of logical database design video lecture
()
Powerpoint lecture notes for lesson 1
Schema Conversion-Conversion rules
Conversion rules video lecture
()
Powerpoint lecture notes for lesson 2
Schema Conversion-Conversion problems
Conversion problems video lecture
()
Powerpoint lecture notes for lesson 3
Schema Conversion-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading material
Practice Problems for Module 10
Assignment for Module 10
Self evaluation for the Module 10 assignment
Normalization Concepts and Practice-Modification anomalies
Modification anomalies video lecture
()
Powerpoint lecture notes for lesson 1 and extras
Normalization Concepts and Practice-Functional dependencies
Functional dependencies video lecture
()
Powerpoint lecture notes for lesson 2
Normalization Concepts and Practice-Normal forms
Normal forms video lecture
()
Powerpoint lecture notes for lesson 3
Normalization Concepts and Practice-Practical concerns
Practical concerns video lecture
()
Powerpoint lecture notes for lesson 4
Normalization Concepts and Practice-Normalization problems
Normalization problems video lecture
()
Powerpoint lecture notes for lesson 5
Normalization Concepts and Practice-Concept Quiz, Practice Problems, and Assignment
Optional textbook reading materials
Practice Problems for Module 11
Assignment for Module 11
Self evaluation for the Module 11 assignment
Advanced Query Formulation with SQL-Outer join operators and one-sided outer problems in SQL
Part 1: Outer Join Operators
()
Part 1: Powerpoint lecture notes for outer join operators
Part 2: One-Sided Outer Join Problems in SQL
()
Part 2: Powerpoint lecture notes for one-sided outer join problems in SQL
Advanced Query Formulation with SQL-Nested Queries in the SELECT Statement
Nested queries video lecture
()
Powerpoint slides for nested queries in the SELECT statement
Advanced Query Formulation with SQL-Membership Exception Problem
Membership exception problem Video lecture
()
Powerpoint slides for the membership exception problem
Advanced Query Formulation with SQL-Relational Division Operator and Containment Exceptions in the SELECT Statement
Part 1: Relational division operator video lecture
()
Powerpoint slides for the relational division operator
Part 2: Containment exceptions video lecture
()
Part 2: Powerpoint slides for containment exceptions in the SELECT statement
Advanced Query Formulation with SQL-Summary of Problem-Solving Guidelines
Summary of problem-solving guidelines video lecture
()
Powerpoint slides for summary of problem-solving guidelines
Advanced Query Formulation with SQL-Course Conclusion
Course Conclusion
()
Advanced Query Formulation with SQL-Lecture Examples, Practice Problems, Quiz, and Assignment
Optional textbook reading material
Lesson SQL examples
Practice problems using the University Database
Extra problems using the Order Entry Database
Assignment for Module 12
Self evaluation for the Module 12 assignment