PostgreSQL Tutorial for Data Analysis and Administration

Learn Basics of PostgreSQL for Database Administration and Data Anlaysis .

Syllabus of the Course

What you’ll learn

• Using PostgreSQL for Management and Administration of Databases.
• Creating Databases for Organizations or Applications.
• Data Analysis using PostgreSQL Queries.
• Create, Read, Update and Delete Records in a Database.

Course Content

• Introduction –> 13 lectures • 3hr 39min.
• Multiple Schools Management System Database Example –> 5 lectures • 1hr 18min.
• Deleting or Dropping Database and Columns –> 2 lectures • 4min.
• Stored Procedures or Functions –> 4 lectures • 1hr 2min.
• Misc –> 2 lectures • 27min.

Requirements

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