Introduction to Relational Database and SQL

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: 1.1 Course Introduction

Lecture 2: Acknowledgement

Chapter 2: Relational Database Design

Lecture 1: 2.1 Introduction to Relational Database

Lecture 2: 2.2 Logical Design and Entity Relationship Model

Lecture 3: 2.3 Physical Design and Relational Database

Lecture 4: 2.4 Normalization

Lecture 5: 2.5 Normal Forms

Lecture 6: 2.6 Entity Relationship Diagram

Chapter 3: SQL Introduction: CREATE and DROP

Lecture 1: 3.1 SQL Introduction

Lecture 2: 3.2 PostgreSQL Introduction

Lecture 3: 3.2.1 PostgreSQL Installation

Lecture 4: 3.3 CREATE and DROP

Lecture 5: 3.4 Naming Convention and Demo Oracle

Lecture 6: Note on "quoted names"

Lecture 7: 3.5 Naming Convention and Demo PostgreSQL

Chapter 4: Simple Data Handling

Lecture 1: 4.1 Simple INSERT and SELECT

Lecture 2: 4.2 Data Types

Lecture 3: Default length of CHAR and VARCHAR

Lecture 4: DECIMAL vs NUMERIC

Lecture 5: 4.3 NULL

Chapter 5: Single Table SELECT Statement

Lecture 1: 5.1 Single Table SELECT Statement

Lecture 2: 5.2 Row Level Functions

Lecture 3: 5.3 Aggregation Functions

Chapter 6: Changing Data: UPDATE, DELETE, INSERT, and ALTER

Lecture 1: 6.1 Changing Table Data

Lecture 2: 6.2 Changing Table Structure

Chapter 7: WHERE Clause Deep Dive

Lecture 1: 7.1 WHERE Clause

Lecture 2: 7.2 WHERE Clause String

Lecture 3: 7.3 WHERE Clause NULL

Lecture 4: 7.4 WHERE Clause IN and Subquery

Chapter 8: Mid-term Project

Lecture 1: 8.1 Mid-term Review

Lecture 2: 8.2 Mid-term Project Part I Answers

Lecture 3: 8.3 Mid-term Project Part II Answers

Chapter 9: Aggregation and GROUP BY

Lecture 1: 9.1 GROUP BY

Lecture 2: 9.2 WHERE and HAVING in GROUP BY

Chapter 10: Dataset Operation: UNION, INTERSECT, and MINUS

Lecture 1: 10.1 Dataset Operation

Chapter 11: JOINing Tables

Lecture 1: 11.1 Joining Tables

Lecture 2: 11.2 Join with JOIN

Lecture 3: 11.3 Multi Table Join

Lecture 4: 11.4 SELECT Statement with JOIN and GROUP BY

Lecture 5: 11.5 Advanced Join Columns

Lecture 6: 11.6 CROSS JOIN and Join on key

Lecture 7: 11.7 Outer Join

Lecture 8: 11.8 Filtering from Another Table

Lecture 9: 11.9 Non-equi Join

Chapter 12: View and Non Permanent Table

Lecture 1: 12.1 View

Lecture 2: Permanent Table vs Temporary Tables

Lecture 3: 12.2 Non Permanent Tables

Chapter 13: Stored Procedure, Cursor, and Window Functions

Lecture 1: 13.1 Stored Procedure

Lecture 2: 13.2 Cursor

Lecture 3: 13.3 Window Functions

Chapter 14: DBMS Operations

Lecture 1: 14.1 DBMS Operations

Chapter 15: Final Project

Lecture 1: 15.1 Final Review

Lecture 2: 15.2 Final Project Answers

Lecture 3: 15.3 Where to Go After This