Curriculum

9 Topics
Specialization Introduction video lesson
Course introduction video lecture
Course objectives video lecture
Topics and assignments video lecture
Get help and meet other learners in this course. Join your discussion forums!
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Optional textbook
Database management software requirements

17 Topics
Database characteristics video lecture
Organizational Roles video lecture
DBMS overview and database definition feature video lecture
Non-procedural access video lecture
Transaction processing overview video lecture
Data warehouse processing overview video lecture
DBMS technology evolution video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Powerpoint lecture notes for lesson 6
Powerpoint lecture notes for lesson 7
Optional textbook reading
Concept Quiz for Module 2
Learning check-in

20 Topics
Basics of relational databases video lecture
Integrity rules video lecture
Basic SQL CREATE TABLE statement video lecture
Integrity constraint syntax video lecture
Assignment 1 notes video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
University database SQL statements for Oracle and PostgreSQL
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
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
Concept Quiz for Module 3
Reflective Quiz for the Module 3 Assignment
Quiz for Module 3 practice problems

20 Topics
SQL Overview video lecture
SELECT statement introduction video lecture
Join Operator video lecture
Using Join operations in SQL SELECT statements video lecture
GROUP BY clause video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
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
Concept Quiz for Module 4
Reflective Quiz for the Module 4 Assignment
Quiz for the practice problems in Module 4

22 Topics
Query formulation guidelines video lecture
Multiple table problems video lecture
Problems involving join and grouping operations video lecture
SQL set operators video lecture
SQL modification statements video lecture
Query formulation errors video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Powerpoint lecture notes for lesson 6
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
Concept Quiz for Module 5
Reflective Quiz for the Module 5 Assignment
Quiz for practice problems in Module 5

14 Topics
Database development goals video lecture
Basic ERD notation video lecture
Relationship variations I video lecture
Relationship variations II video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Optional textbook reading
Practice problems for Module 6
Assignment for Module 6
Self evaluation for the Module 6 assignment
Concept Quiz for Module 6
Reflective Quiz for the Module 6 Assignment

18 Topics
Basic diagram rules video lecture
Extended diagram rules video lecture
ERD problems I video lecture
ERD problems II video lecture
ER Assistant Demonstration video
Software demonstration video for Visual Paradigm
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
ER Assistant download
Download for Visual Paradigm
Optional textbook reading material
Practice Problems for Module 7
Assignment for Module 7
Self evaluation for the Module 7 assignment
Concept Quiz for Module 7
Reflective Quiz for the Module 7 Assignment

14 Topics
Conceptual data modeling goals and challenges
Analyzing narrative problems
Design transformations I
Design transformations II video lecture
Powerpoint lecture notes for lesson 1 and extras
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Optional textbook reading material
Practice problems for Module 8
Assignment for Module 8
Self evaluation for the Module 8 assignment
Concept Quiz for Module 8
Reflective Quiz for the Module 8 Assignment

12 Topics
Data modeling problems I video lecture
Data modeling problems II video lecture
Finalizing an ERD video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Optional textbook reading material
Practice Problems for Module 9
Assignment for Module 9
Self evaluation for the Module 9 assignment
Concept Quiz for Module 9
Reflective Quiz for the Module 9 Assignment

12 Topics
Goals and steps of logical database design video lecture
Conversion rules video lecture
Conversion problems video lecture
Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Optional textbook reading material
Practice Problems for Module 10
Assignment for Module 10
Self evaluation for the Module 10 assignment
Concept Quiz for Module 10
Reflective Quiz for the Module 10 Assignment

16 Topics
Modification anomalies video lecture
Functional dependencies video lecture
Normal forms video lecture
Practical concerns video lecture
Normalization problems video lecture
Powerpoint lecture notes for lesson 1 and extras
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Optional textbook reading materials
Practice Problems for Module 11
Assignment for Module 11
Self evaluation for the Module 11 assignment
Concept Quiz for Module 11
Reflective Quiz for the Module 11 Assignment

23 Topics
Part 1: Outer Join Operators
Part 2: One-Sided Outer Join Problems in SQL
Nested queries video lecture
Membership exception problem Video lecture
Part 1: Relational division operator video lecture
Part 2: Containment exceptions video lecture
Summary of problem-solving guidelines video lecture
Course Conclusion
Part 1: Powerpoint lecture notes for outer join operators
Part 2: Powerpoint lecture notes for one-sided outer join problems in SQL
Powerpoint slides for nested queries in the SELECT statement
Powerpoint slides for the membership exception problem
Powerpoint slides for the relational division operator
Part 2: Powerpoint slides for containment exceptions in the SELECT statement
Powerpoint slides for summary of problem-solving guidelines
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
Concept Quiz for Module 12
Reflective Quiz for the Module 12 Assignment

  Write a Review

Database Management Essentials

Go to Free Course