Quizzes

© Saylor Academy 2010-2026 except as otherwise noted. Excluding course final exams, content authored by Saylor Academy is available under a Creative Commons Attribution 3.0 Unported license. Third-party materials are the copyright of their respective owners and shared under various licenses. See detailed licensing information. Saylor Academy®, Saylor.org®, and Harnessing Technology to Make Education Free® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Syllabus

CS403: Introduction to Modern Database Systems

Course Introduction

Course Syllabus

Unit 1: Introduction to Modern Database Systems

1.1: Characteristics of Databases

1.2: Database Environments

1.3: Alternate Database Management Systems

Unit 1 Assessment

Unit 2: Database Architecture

2.1: Databases and the ANSI/SPARC Three-Schema Architecture

2.2: Tables, Views, and Indexes

Unit 2 Assessment

Unit 3: The Entity-Relationship Model

3.1: E-R Elements and Symbols

3.2: The Enhanced E-R Model

Unit 3 Assessment

Unit 4: The Relational Database Model

4.1: The Relational Model at a Glance

4.2: Mapping an E-R Diagram to a Relation

Unit 4 Assessment

Unit 5: Relational Algebra

5.1: Basic Operations

5.2: Derived Operations

5.3: Set Operations

5.4: Aggregate Functions

Unit 5 Assessment

Unit 6: Introduction to Data Normalization

6.1: Defining Normalization

6.2: Anomalies

6.3: Functional Dependencies

6.4: Conducting a Normalization

Unit 6 Assessment

Unit 7: Introduction to SQL

7.1: What Is SQL?

7.2: Data Definition Language (DDL)

7.3: Column- and Table-Level Constraints

7.4: Data Manipulation Language (DML)

Unit 7 Assessment

Unit 8: Basic Select Statements

8.1: Basic Select Statements

8.2: Special Operators

Unit 8 Assessment

Unit 9: The Join Statement

9.1: Introduction

9.2: Inner Joins

9.3: Outer Joins

9.4: The Group By Clause

9.5: Additional Exercises

Unit 9 Assessment

Study Guide

Certificate Final Exam

Course Feedback Survey

Quizzes