Introduction
  • Course Overview
Installation and getting started
  • Course Resources
  • This is a milestone!
  • Installing and setting up PostgreSQL
  • If pgAdmin is not opening...
Case Study : Demo
  • Case Study Part 1
  • Case Study Part 2
Fundamental SQL statements
  • CREATE
  • Exercise 1: Create DB and Table
  • Solutions to all Exercises
  • INSERT
  • Import data from File
  • Exercise 2: Inserting and Importing
  • SELECT statement
  • SELECT DISTINCT
  • WHERE
  • Logical Operators
  • Exercise 3: SELECT & WHERE
  • UPDATE
  • DELETE
  • ALTER
  • Exercise 4: Updating Table
  • Fundamental SQL statements
Restore and Back-up
  • Restore and Back-up
  • If your restore fails, then...
  • Exercise 5: Restore and Back-up
Selection commands: Filtering
  • IN
  • BETWEEN
  • LIKE
  • Exercise 6: In, Like & Between
Selection commands: Ordering
  • Side Lecture: Commenting in SQL
  • ORDER BY
  • LIMIT
  • Exercise 7: Sorting
Alias
  • AS
Aggregate Commands
  • COUNT
  • SUM
  • AVERAGE
  • MIN & MAX
  • Exercise 8: Aggregate functions
  • Quiz
Group By Commands
  • GROUP BY
  • HAVING
  • Exercise 9: Group By
  • Quiz
Conditional Statement
  • CASE WHEN
JOINS
  • Introduction to Joins
  • Inner Join
  • Left Join
  • Right Join
  • Full Outer Join
  • Cross Join
  • Except
  • Union
  • Exercise 10: Joins
  • Quiz
Subqueries
  • Subqueries
  • Exercise 11: Subqueries
Views and Indexes
  • VIEWS
  • INDEX
  • Exercise 12: Views
String Functions
  • LENGTH
  • UPPER LOWER
  • REPLACE
  • TRIM, LTRIM, RTRIM
  • CONCATENATION
  • SUBSTRING
  • LIST AGGREGATION
  • Exercise 13: String Functions
Mathematical Functions
  • CEIL & FLOOR
  • RANDOM
  • SETSEED
  • ROUND
  • POWER
  • Exercise 14: Mathematical Functions
Date-Time Functions
  • CURRENT DATE & TIME
  • AGE
  • EXTRACT
  • Exercise 15: Date-time functions
PATTERN (STRING) MATCHING
  • PATTERN MATCHING BASICS
  • ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
  • Exercise 16: Pattern Matching