Introduction
  • Introduction
  • Tools Used in this Course
Setting Up Course Tools
  • Download PostgreSQL
  • Install PostgreSQL
  • Download SQLectron
  • Install SQLectron
  • Connect to PostgreSQL - Credentials
  • Connect to PostgreSQL Using SQLectron
  • Import Course Data Using SQLectron
  • FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver
  • FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
Browsing & Filtering Data
  • Check Imported Data
  • So.. What is a Database?
  • SQL Data Types
  • Finally Some Fun! Extracting Data Based on Requirements
  • Filtering Data Using WHERE Keyword
  • Filter Data by Range Using BETWEEN
  • Filter Data by Set of Values Using IN
  • Filter Data by Strings (Names, addresses, ...)
Tidy Up Your Results: Sorting, Alias Names, Limit Records
  • Give Your Report Fields A Cool Name
  • Order Records by Column
  • Order Records by Multiple Columns
  • LIMIT Record Count Fetched by Your Query
NULL & DISTINCT
  • What Is A NULL Value Anyway?
  • Let Me Introduce You to Functions
  • SUM Function
  • AVG (Average) Function
  • COUNT Function
  • GROUP BY Clause: Use Functions with Dimensions
  • GROUP BY More Than One Dimension
Epilogue
  • Thank you, next step to proceed learning!