CS403: Introduction to SQL | Saylor Academy

Home Specialization Programs Help

This resource is a nice concise summary of SQL Data Definition, Data Manipulation, and Data Creation commands.

Click on Introduction to SQL to open the resource.

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