Learn SQL using PostgreSQL Server – Beginner to Expert

Course Curriculum

Chapter 1: Setting Up PostgreSQL Database Server

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is PosgreSQL

Lecture 4: Some Companies using PostgreSQL

Lecture 5: PostgreSQL Installation Requirements

Lecture 6: Please Read

Lecture 7: Installing PostgreSQL Server Version10

Lecture 8: Connecting to a PostgreSQL Database

Lecture 9: Download and load Sample PostgreSQL Database

Lecture 10: Download PostgreSQL version 9.6

Lecture 11: Install PostgreSQL 9.6 on windows

Lecture 12: Verify PostgreSQL 9.6 installation

Lecture 13: Connecting to PostgreSQL 9.6 database

Lecture 14: Load sample database on PostgreSQL 9.6

Lecture 15: Installing PostgreSQL 9.6 on Mac

Lecture 16: Database Concepts

Lecture 17: What is Schema

Lecture 18: Data Types

Lecture 19: Unique Constraint

Chapter 2: SQL C R U D Operations

Lecture 1: Introduction

Lecture 2: Creating a database

Lecture 3: Create a table with Pgadmin

Lecture 4: Create a table with SQL CREATE Statement

Lecture 5: Reading Data with SELECT Statement

Lecture 6: Extracting and Reading all data from a table

Lecture 7: Extracting and Reading data from a specific Column

Lecture 8: Updating existing data in a table

Lecture 9: Deleting (dropping) data in a table

Lecture 10: Inserting new data into a table

Chapter 3: Some SQL Fundamentals

Lecture 1: Filtering Data with WHERE clause

Lecture 2: Removing duplicate data with DISTINCT

Lecture 3: Sorting Data with ORDER BY

Lecture 4: Dropping and Truncating a table

Chapter 4: Extracting Data with SQL Operators

Lecture 1: Extracting data with Comparison Operators

Lecture 2: Extracting data with BETWEEN Operator

Lecture 3: Extracting data with LIKE operator

Lecture 4: Extracting data with NOT Operator

Lecture 5: Extracting data with AND Operator

Lecture 6: Extracting data with OR Operator

Lecture 7: Combining AND & OR operators

Lecture 8: Extracting data with LIMIT Operator

Lecture 9: Extracting data with IN Operators

Lecture 10: Extracting data with UNION Operator

Lecture 11: Extracting data with UNION ALL Operator

Lecture 12: Extracting data with INTERSECT Operator

Lecture 13: Extracting data with EXCEPT Operator

Chapter 5: Getting Data from Multiple Tables

Lecture 1: What are table joins

Lecture 2: Retrieving data with INNER Join

Lecture 3: Retrieving data with LEFT Join

Lecture 4: Retrieving data with FULL OUTER Join

Lecture 5: Retrieving data with CROSS Join

Lecture 6: Retrieving data with NATURAL Join

Chapter 6: Grouping Data and Aggregate Functions

Lecture 1: Grouping data with GROUP BY clause

Lecture 2: Using HAVING clause

Lecture 3: What are aggregate functions

Lecture 4: Summarizing data with AVG aggregate function

Lecture 5: Summarizing data with COUNT aggregate function

Lecture 6: Summarizing data with MAX aggregate function

Lecture 7: Summarizing data with MIN aggregate function

Lecture 8: Summarizing data with SUM aggregate function

Chapter 7: Data Analysis with Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Let's create sample tables

Lecture 3: Using AVG as window function

Lecture 4: Analysing data with ROW NUMBER function

Lecture 5: Analysing data with RANK function

Lecture 6: Analysing data with DENSE RANK function

Lecture 7: Analysing data with FIRST VALUE function

Lecture 8: Analysing data with LAST function

Lecture 9: Analysing data with LAG function

Lecture 10: Analysing data with LEAD function

Chapter 8: Triggers | Sub-queries | Stored Procedures

Lecture 1: Introduction to Triggers

Lecture 2: Creating a trigger – part 1

Lecture 3: Creating a trigger – part 2

Lecture 4: Creating a trigger – part 3

Lecture 5: Managing triggers

Lecture 6: Creating and using sub-queries

Lecture 7: Creating and using stored procedures

Chapter 9: SQL Views ( Virtual Tables )

Lecture 1: What are views

Lecture 2: Benefits of using views

Lecture 3: How to create a view

Lecture 4: How to modify and delete a view

Lecture 5: How to update views

Lecture 6: What are materialized views

Lecture 7: How to create a materialized view

Lecture 8: Thank You