Learn Database Concepts with PostGREs

The curriculum covers fundamental concepts, advanced features, and practical applications, ensuring that participants gain a thorough understanding of PostgreSQL and its capabilities.

Introduction to PostgreSQL

  • What is PostgreSQL?
  • History and evolution of PostgreSQL
  • Key features and advantages
  • Installation and setup
  • Overview of the PostgreSQL ecosystem
introduction

Database Fundamentals

fundaments

SQL Basics

sql-basics-new
advance-sql
Advanced SQL Queries

  • Joins (INNER, LEFT, RIGHT, FULL)

  • Subqueries and nested queries

  • Common Table Expressions (CTEs)

  • Window functions

  • Set operations (UNION, INTERSECT, EXCEPT)