CS403: Resources | Saylor Academy

Topic	Name	Description
	Course Syllabus

© Saylor Academy 2010-2024 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

Announcements

CS403: Introduction to Modern Database Systems

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