This course teaches you how to design a relational database and how to write SQL. It covers all the important SQL statements, including CREATE, INSERT, UPDATE, DELETE, SELECT, ALTER, and DROP, and provide some insight into entity-relationship model design. This course is based on my on-campus teaching at colleges and comes with a mid-term project and a final project. There is no prerequisite for this course.

Description

• SQL and Relational Database Beginner

Course content

• Course Introduction
  • 1.1 Course Introduction
  • Acknowledgement
• Relational Database Design
  • 2.1 Introduction to Relational Database
  • 2.2 Logical Design and Entity Relationship Model
  • 2.3 Physical Design and Relational Database
  • 2.4 Normalization
  • 2.5 Normal Forms
  • 2.6 Entity Relationship Diagram
• SQL Introduction: CREATE and DROP
  • 3.1 SQL Introduction
  • 3.2 PostgreSQL Introduction
  • 3.2.1 PostgreSQL Installation
  • 3.3 CREATE and DROP
  • 3.4 Naming Convention and Demo Oracle
  • 3.5 Naming Convention and Demo PostgreSQL
• Simple Data Handling
  • 4.1 Simple INSERT and SELECT
  • 4.2 Data Types
  • 4.3 NULL
• Single Table SELECT Statement
  • 5.1 Single Table SELECT Statement
  • 5.2 Row Level Functions
  • 5.3 Aggregation Functions
• Changing Data: UPDATE, DELETE, INSERT, and ALTER
  • 6.1 Changing Table Data
  • 6.2 Changing Table Structure
• WHERE Clause Deep Dive
  • 7.1 WHERE Clause
  • 7.2 WHERE Clause String
  • 7.3 WHERE Clause NULL
  • 7.4 WHERE Clause IN and Subquery
• Mid-term Project
  • 8.1 Mid-term Review
  • 8.2 Mid-term Project Part I Answers
  • 8.3 Mid-term Project Part II Answers
• Aggregation and GROUP BY
  • 9.1 GROUP BY
  • 9.2 WHERE and HAVING in GROUP BY
• Dataset Operation: UNION, INTERSECT, and MINUS
  • 10.1 Dataset Operation
• JOINing Tables
  • 11.1 Joining Tables
  • 11.2 Join with JOIN
  • 11.3 Multi Table Join
  • 11.4 SELECT Statement with JOIN and GROUP BY
  • 11.5 Advanced Join Columns
  • 11.6 CROSS JOIN and Join on key
  • 11.7 Outer Join
  • 11.8 Filtering from Another Table
  • 11.9 Non-equi Join
• View and Non Permanent Table
  • 12.1 View
  • 12.2 Non Permanent Tables
• Stored Procedure, Cursor, and Window Functions
  • 13.1 Stored Procedure
  • 13.2 Cursor
  • 13.3 Window Functions
• DBMS Operations
  • 14.1 DBMS Operations
• Final Project
  • 15.1 Final Review
  • 15.2 Final Project Answers
  • 15.3 Where to Go After This