Skip to main content
CS403: Introduction to Modern Database Systems
0%
Previous
Course Feedback Survey
Course Introduction
Course Syllabus
Unit 1: Introduction to Modern Database Systems
1.1: Characteristics of Databases
Before the Advent of Database Systems
Fundamental Concepts and Benefits of a Database
Introduction to Database Systems
1.2: Database Environments
Database Models
Types of Data Models and Data Modeling
Elements of Database Systems
1.3: Classifying Database Management Systems
Classification of Database Management Systems
Comparison of NoSQL Database Management Systems and Models
Classifying Database Management Systems: Regular and NoSQL
Unit 1 Assessment
Unit 1 Assessment
Unit 2: Database Architecture and Date Languages
2.1: Databases and the Three-Schema Architecture
Three-Schema Architecture
Data Modeling and a Framework for Database System Design
2.2: Tables, Views, and Indexes
The Relational Data Model
Relational Databases
Introduction to Relational Databases
Unit 2 Assessment
Unit 2 Assessment
Unit 3: The History of Databases
3.1: Before Computers
A Brief History of Databases
History of Databases
3.2: The Four Revelations
Database Models
Unit 3 Assessment
Unit 3 Assessment
Unit 4: The Entity-Relationship Model
4.1: Why Use an E-R Model?
Conceptual Designs
4.2: E-R Elements and Symbols
The Entity-Relationship Data Model
Entity-Relationships
Data Modeling: Entity-Relationship (E-R)
Data Models
Introduction to the Entity-Relationship Model
4.3: The Enhanced E-R Model
The Enhanced Entity-Relationship Model
Advanced Topics in E-R Modeling
Unit 4 Assessment
Unit 4 Assessment
Unit 5: The Relational Database Model
5.1: The Relational Model at a Glance
The Relational Data Model
The Relational Database Model
5.2: Mapping an E-R Diagram to a Relation
ER Model to Relational Mapping
Integrity Rules and Constraints
Unit 5 Assessment
Unit 5 Assessment
Unit 6: Relational Algebra
6.1: Basic Operations
Relational Algebra
The Relational Database Model
Relational Algebra
6.2: Derived Operations
Relational Algebra and Relational Calculus
SQL Data Manipulation Language
6.3: Set Operations
The Relational Database Model
6.4: Aggregate Functions
The Structured Query Language
Unit 6 Assessment
Unit 6 Assessment
Unit 7: Introduction to Data Normalization
7.1: Defining Normalization
Database Normalization
Normalization
Normalized Database Design
Entity Relationship Diagrams
7.2: Anomalies
Data Anomalies
7.3: Functional Dependencies
Functional Dependencies
7.4: From 1NF to BCNF
Normalizing a Relation to BCNF Based on Functional Dependencies
Unit 7 Assessment
Unit 7 Assessment
Unit 8: Introduction to SQL
8.1: What is SQL?
Introduction to SQL
Another Introduction to SQL
8.2: Data Definition Language (DDL)
SQL Structured Query Language
SQL Tutorial
Drop Table
Alter Table
8.3: Column- and Table-Level Constraints
SQL Tutorial
8.4: Data Manipulation Language (DML)
SQL Tutorial
SQL Insert, Update, and Delete Commands
Unit 8 Assessment
Unit 8 Assessment
Unit 9: Basic Select Statements
9.1: Basic Select Statements
SQL Tutorial
PostgreSQL Tutorial: AND, OR, NOT
9.2: Special Operators
SQL LIKE Operator
SQL BETWEEN Operator
SQL: Using WHERE Clause with NOT LIKE Operator and Escape Character
MySQL SELECT Statement
Select (SQL)
SQL ORDER BY Clause
Unit 9 Assessment
Unit 9 Assessment
Unit 10: The Join Statement
10.1: Introduction
INNER JOIN
SQL Data Manipulation Language
SQL JOINS
Aggregates and JOINs
10.2: Inner Joins
Inner vs. Outer Joins in SQL
SQL INNER JOIN
10.3: Outer Joins
SQL OUTER JOIN
SQL RIGHT JOIN
SQL Full Outer Join
10.4: The Group By Clause
GROUP BY
SQL GROUP BY Clause
10.5: Assessment
SQL Exercises
Unit 10 Assessment
Unit 10 Assessment
Study Guide
CS403 Study Guide
Course Feedback Survey
Course Feedback Survey
Certificate Final Exam
CS403: Certificate Final Exam
Archived Materials
Next
Side panel
Course Catalog
All categories
Arts & Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
General Knowledge for Teachers
Science and Math
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
Psychology
Sociology
Home
Specialization Programs
Specialization Programs
MBA Degree Program
Help
Getting Started
Help Center & FAQ
Search
Search
Search
Search
Close
Toggle search input
You are currently using guest access
Log in
Course Catalog
Collapse
Expand
All categories
Arts & Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
General Knowledge for Teachers
Science and Math
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
Psychology
Sociology
Home
Specialization Programs
Collapse
Expand
Specialization Programs
MBA Degree Program
Help
Collapse
Expand
Getting Started
Help Center & FAQ
Expand all
Collapse all
Open course index
CS403: Introduction to Modern Database Systems
Course Feedback Survey
Course Feedback Survey
Course Feedback Survey
Completion requirements
Click on
Course Feedback Survey
to open the resource.
