Introduction
  • What we will learn?
  • SQL & DBMS
  • Postgresql
Case Study
  • Puzzle
Creating Tables & Inserting Data
  • Prepare the DBMS
  • Create & Drop Database
  • Create & Drop Table
  • Insert Records into Table
  • Import Bulk Data
  • Summary
  • Puzzle Solution - Part 1
Data Querying
  • Select Statement
  • Using Distinct
  • Using Aliases
  • Summary
  • Puzzle Solution - Part 2
Data Filtering
  • Where
  • AND
  • OR
  • IN
  • Between
  • Like
  • NOT
  • NULL Values
  • Summary
  • Puzzle Solution - Part 3
Data Aggregation & Grouping
  • Count
  • Summation
  • Average
  • Minimum
  • Maximum
  • Group By
  • Having
  • Summary
  • Puzzle Solution - Part 4
Data Sorting
  • Order By
  • Limit
  • Summary
  • Puzzle Solution - Part 5
Case Study Output
  • Puzzle Solution - Output
  • Data Export from the DBMS
What is Next?
  • What is NEXT?