Course Introduction
  • Introduction
  • Course Curriculum overview
  • Overview of Databases
  • What is source code
  • Add ChatGPT AI skills for your Course Learning
  • Learn What is Generative AI / Gen AI
SQL Environment Setup
  • PostgreSQL Installation on Windows
  • Connecting to PostgreSQL using psql
  • Connecting to PostgreSQL using PgAdmin
SQL Statement Basics
  • Overview of Challenges
  • SQL Statement Basic
  • SELECT Statement
  • SELECT DISTINCT
  • Column AS Statement
  • SELECT COUNT(*)
  • SELECT WHERE Clause – One
  • SELECT WHERE Clause – Two
Filtering Data Rows
  • ORDER BY
  • LIMIT
  • BETWEEN
  • IN Operator
  • LIKE and ILIKE
GROUP BY Statements
  • Overview of GROUP BY
  • Aggregation Function
  • GROUP BY - One
  • GROUP BY - Two
  • HAVING
Assessment Test 1
  • Overview Assessment Test 1
  • Assessment Exercise
  • Solution for Assessment Exercise
JOINS
  • Overview of JOINS
  • Introduction to JOINS
  • AS Statement
  • INNER Joins
  • Full Outer Joins
  • Left Outer Join
  • Right Outer Join
  • Union
Advanced SQL Commands
  • Basic of Advanced SQL Commands
  • Timestamps
  • Extract from Timestamp
  • Mathematical Functions
  • String Functions
  • SubQuery
Assessment Test 2
  • Setting up New Database for new Exercise
  • Assessment Exercise
  • Solution for Exercise
Creating Database and Tables
  • Basic of Database and Tables
  • Data Types
Primary Key and Foreign Keys
  • Primary Keys and Foreign Keys
  • Create Table in SQL Script
SQL INSERT/UPDATE/READ/DELETE Query writing
  • Insert Statement in SQL
  • Update Statement in SQL
  • Delete Statement in SQL
Query On How to Modify and Constraints
  • Alter Table
  • Drop Table
  • Check Constraint
  • NOT NULL Constraint
  • UNIQUE Constraint
Databases and Tables
  • Overview of Databases and Tables
  • Creating a Database backup
  • Restoring a Database from backup