SQL Crash Course 2024 From Zero – Learn SQL with PostgreSQL

Course Curriculum

Chapter 1: Course Overview and 10 Minutes of SQL

Lecture 1: Course Overview

Lecture 2: 10 Minutes of SQL

Lecture 3: Quick Tip: Show Line Numbers in DBeaver

Lecture 4: Udemy Tipps

Chapter 2: Database Introduction – Basic Terminology and Course Setup

Lecture 1: Databases Overview

Lecture 2: Types of Databases

Lecture 3: SQL Standard and Common Groups

Lecture 4: Installation of PostgreSQL and DBeaver on Windows, Mac, Linux

Lecture 5: Import the course files

Lecture 6: Explore the course projects

Chapter 3: Tables and Inserting Data – with CREATE & INSERT

Lecture 1: CREATE a Database

Lecture 2: CREATE a Table

Lecture 3: INSERT Statement

Lecture 4: More on the INSERT Statement

Chapter 4: Query Data – with SELECT, WHERE, ORDER, LIMIT

Lecture 1: Query Overview – SELECT Everything

Lecture 2: SELECT with Columns and Labels

Lecture 3: WHERE Condition

Lecture 4: DISTINCT Values

Lecture 5: NULL Values

Lecture 6: ORDER BY Clause

Lecture 7: LIMIT and OFFSET

Chapter 5: Data Types – Numeric, String, Date, Boolean

Lecture 1: Data Types Overview

Lecture 2: Numeric Data Types

Lecture 3: Character Data Types

Lecture 4: Date and Time Data Types

Lecture 5: Boolean Data Type

Chapter 6: Remove Data & Objects – DROP, TRUNCATE

Lecture 1: DELETE Statement

Lecture 2: TRUNCATE Statement

Lecture 3: DROP Table

Lecture 4: DROP Database

Chapter 7: Modify Data & Objects – ALTER, UPDATE

Lecture 1: Overview ALTER and UPDATE

Lecture 2: ALTER Statement

Lecture 3: UPDATE Statement

Chapter 8: Constraints – for good data & structure

Lecture 1: Constraints Overview

Lecture 2: DEFAULT Constraint

Lecture 3: CHECK Constraint

Lecture 4: NOT NULL Constraint

Lecture 5: UNIQUE Constraint

Lecture 6: PRIMARY KEY Constraint

Lecture 7: FOREIGN KEY Constraint

Chapter 9: Normalization – How to structure a database

Lecture 1: Normalization Overview

Lecture 2: Un-Normalized Form (UNF) and Primary Key (PK)

Lecture 3: From Un-Normalized Form (UNF) to First Normal Form (1NF)

Lecture 4: Second Normal Form (2NF)

Lecture 5: From Second Normal Form (2NF) to Third Normal Form (3NF)

Lecture 6: Create Database Diagrams in DBeaver

Chapter 10: Operators – for Arithmetic, Comparison, Logic

Lecture 1: Operators Overview

Lecture 2: Arithmetic Operators

Lecture 3: Comparison Operators

Lecture 4: Logical Operators

Chapter 11: Functions – Built-in Code for Strings, Numbers, Conversion, Dates and more

Lecture 1: Functions Overview

Lecture 2: String Functions

Lecture 3: Formatting and Conversion Functions

Lecture 4: Aggregate Functions

Lecture 5: Date and Time Functions

Lecture 6: Mathematical Functions

Lecture 7: Conditional Functions

Chapter 12: Joins – Bringing 2+ tables together

Lecture 1: Joins Overview

Lecture 2: Cross Join

Lecture 3: Inner Join

Lecture 4: Left Join

Lecture 5: Right Join

Lecture 6: Full Join

Lecture 7: Self Join

Chapter 13: Subqueries – How to nest queries

Lecture 1: Subquery Introduction

Lecture 2: Subquery with EXISTS

Lecture 3: Subquery with IN

Chapter 14: Security – The basics

Lecture 1: Create roles and users

Lecture 2: Grant and Revoke

Chapter 15: Views – A way of storing queries

Lecture 1: Create and Use Views

Chapter 16: Summary – Course Wrap up

Lecture 1: Congratulations and Surprise

Chapter 17: Extra Material

Lecture 1: What to Avoid

Lecture 2: Official Documentation and Book Recommendation

Lecture 3: Bonus Lecture