PostgreSQL Tutorial for Data Analysis and Full-Stack

About PostgreSQL Tutorial for Data Analysis and Full-Stack

Syllabus of the Course

Lecture 1: Introduction and Installation of PostgreSQL Lecture 2: Creating First Database and First Table using UI in PostgreSQL Lecture 3: PostgreSQL creating a Database using SQL query Lecture 4: Primary Key Constraint and Setting it on already created table Lecture 5: Inserting Records in PostgreSQL using Queries Lecture 6: Updating Records in PostgreSQL Lecture 7: Deleting Records in PostgreSQL AND and OR Operators Lecture 8: Importing an External Database in PostgreSQL from SQL Code Lecture 9: Comparison Operators in PostgreSQL with Where Clause Lecture 10: Comparison and Logical Operators Together in PostgreSQL With Where Clause Lecture 11: Between Operator in PostgreSQL with WHere Clause Lecture 12: IN and NOT IN with Where Clause in PostgreSQL Lecture 13: LIKE Operator for Pattern Matching in PostgreSQL

Section 2: Multiple Schools Management System Database Example

Lecture 14: Creating Multiple School Management System DB in PostgreSQL Lecture 15: Concept of Foreign Key and FK Constraint in PostgreSQL Lecture 16: Creating students table with 2 foreign keys in database using Postgresql Lecture 17: Inserting dummy values in tables and testing foreign key constraint Lecture 18: Joins in PostgreSQL - Inner, Left, Right, Full

Section 3: Deleting or Dropping Databases and Columns

Lecture 19: How to Delete or Drop Database in PostgreSQL Lecture 20: Dropping Regular Columns and those with Foreign Key Constraint

Section 4: Stored Procedures or Functions

Lecture 21: Variables in PostgreSQL Lecture 22: Functions or Stored Procedures in PostgreSQL - Part 1 Lecture 23: Functions or Stored Procedures in PostgreSQL - More Examples Lecture 24: Views in PostgreSQL

Section 5: Misc

Lecture 25: Aggregate Functions in PostgreSQL Lecture 26: GROUP BY in PostgreSQL for Data Analysis