Quizzes

Topic	Name	Quiz closes
Archived Materials	CS403: Certificate Final Exam (Attempts before 2019/07/22)	Monday, 22 July 2019, 8:05 PM
	CS403: Proctor-Verified Final Exam (Attempts before 2019/07/22)	Monday, 22 July 2019, 8:13 PM

Course Syllabus

Announcements

CS403: Introduction to Modern Database Systems

Quizzes

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

Quizzes