About this course
Set up your environment and review foundational concepts to prepare for a comprehensive PostgreSQL learning journey.
Before We Begin
1 Parts
- 0:05 Hr
Global Implementations
5 Min
Prerequisites & Readiness Check
2 Parts
- 1:00 Hr
PostgreSQL Environment Setup Guide
15 Min
Prerequisites for Mastering PostgreSQL
45 Min
Chapter 1: PostgreSQL & RDBMS Fundamentals
3 Parts
- 1:30 Hr
Introduction to PostgreSQL
30 Min
Getting Started
30 Min
Exercise: Database Exploration
30 Min
Chapter 2: Basic SQL and Database Design
3 Parts
- 2:15 Hr
Basic SQL Queries
45 Min
Database and Table Creation
45 Min
Exercise: Basic Database Setup
45 Min
Chapter 3: CRUD Operations and Basic Joins
3 Parts
- 2:00 Hr
CRUD Operations
45 Min
Joins and Aggregation
45 Min
Exercise: Generate Summary Reports
30 Min
Assignment 1
2 Parts
- 0:45 Hr
Build a Normalized Employee Database
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 4: Complex Queries and Window Functions
3 Parts
- 2:45 Hr
Advanced Joins and Subqueries
60 Min
Window Functions
45 Min
Exercise: Complex Query and Window Function Practice
60 Min
Chapter 5: Stored Procedures, Triggers, and Transactions
3 Parts
- 3:15 Hr
Stored Procedures and Functions
60 Min
Triggers and Transactions
60 Min
Exercise: Procedure, Trigger, and Transaction Practice
75 Min
Chapter 6: Table Partitioning, JSON, and Indexing
3 Parts
- 2:15 Hr
Table Partitioning
45 Min
JSON Handling and Indexing
45 Min
Exercise: Store and Query JSONB Metadata
45 Min
Assignment 2
2 Parts
- 0:45 Hr
Data Maintenance & Query Foundation
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 7: Performance Tuning and Advanced Indexing
3 Parts
- 3:00 Hr
Query Optimization
60 Min
Specialized Indexing
60 Min
Exercise: Optimize Queries with GIN Indexes
60 Min
Chapter 8: Full-Text Search and Advanced Data Types
3 Parts
- 2:45 Hr
Full-Text Search
60 Min
JSONB and HSTORE
60 Min
Exercise: Build a Keyword Search Query
45 Min
Chapter 9: Replication, Security, and Integration
3 Parts
- 2:45 Hr
Logical Replication and High Availability
60 Min
Advanced Security and Integration
60 Min
Exercise: Implement Role-Based Data Access
45 Min
Assignment 3
2 Parts
- 0:45 Hr
Advanced Querying & Reporting Engine
45 Min
Submit yout Assignment here
Submit yout Assignment here
Min Grade: 40
Capstone Project 1
2 Parts
- 50:00 Hr
Blog Platform with Full-Text Search and JSON
3000 Min
Submit Your Project
Submit Your Project
Min Grade: 40
Capstone Project 2
2 Parts
- 50:00 Hr
Scalable CRM System with Replication and Security
3000 Min
Submit Your Project
Submit Your Project
Min Grade: 40
No Reviews Yet
