Skip to main content
CS403: Introduction to Modern Database Systems
0%
Focus Mode is ON. Click ‘X’ at right bottom to close it.
Previous
Course data
Course Introduction
Course Syllabus
Announcements
Unit 1: Introduction to Modern Database Systems
1.1: Characteristics of Databases
1.2: Database Environments
1.3: Classifying Database Management Systems
Unit 1 Assessment
Unit 2: Database Architecture and Date Languages
2.1: Databases and the Three-Schema Architecture
2.2: Tables, Views, and Indexes
Unit 2 Assessment
Unit 3: The History of Databases
3.1: Before Computers
3.2: The Four Revelations
Unit 3 Assessment
Unit 4: The Entity-Relationship Model
4.1: Why Use an E-R Model?
4.2: E-R Elements and Symbols
4.3: The Enhanced E-R Model
Unit 4 Assessment
Unit 5: The Relational Database Model
5.1: The Relational Model at a Glance
5.2: Mapping an E-R Diagram to a Relation
Unit 5 Assessment
Unit 6: Relational Algebra
6.1: Basic Operations
6.2: Derived Operations
6.3: Set Operations
6.4: Aggregate Functions
Unit 6 Assessment
Unit 7: Introduction to Data Normalization
7.1: Defining Normalization
7.2: Anomalies
7.3: Functional Dependencies
7.4: From 1NF to BCNF
Unit 7 Assessment
Unit 8: Introduction to SQL
8.1: What is SQL?
8.2: Data Definition Language (DDL)
8.3: Column- and Table-Level Constraints
8.4: Data Manipulation Language (DML)
Unit 8 Assessment
Unit 9: Basic Select Statements
9.1: Basic Select Statements
9.2: Special Operators
Unit 9 Assessment
Unit 10: The Join Statement
10.1: Introduction
10.2: Inner Joins
10.3: Outer Joins
10.4: The Group By Clause
10.5: Assessment
Unit 10 Assessment
Study Guide
Course Feedback Survey
Certificate Final Exam
Archived Materials
Next
Side panel
Course Catalog
All categories
Arts and Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
Business and Communication
College Success
Computer and Information Technology
General Knowledge for Teachers
Writing and Soft Skills
Science and Mathematics
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
Psychology
Sociology
Home
Calendar
Specialization Programs
Specialization Programs
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 and Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
Business and Communication
College Success
Computer and Information Technology
General Knowledge for Teachers
Writing and Soft Skills
Science and Mathematics
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
Psychology
Sociology
Home
Calendar
Specialization Programs
Collapse
Expand
Specialization Programs
Help
Collapse
Expand
Getting Started
Help Center & FAQ
Expand all
Collapse all
Open course index
CS403: Introduction to Modern Database Systems
Topic
Name
Description
Course Syllabus