Skip to content
Home Tutorials Roadmaps Courses
Log in Join free

PostgreSQL Complete

Master PostgreSQL from basics to advanced - the most powerful open-source relational database.

SU Taught by Sukhwinder Singh 0 enrolled Beginner

What you will learn

  • Write complex SQL queries
  • Design efficient database schemas
  • Optimize query performance with indexing
  • Use stored procedures and triggers
  • Manage PostgreSQL in production
Master PostgreSQL - the most advanced open-source relational database used by companies like Apple, Instagram, and Spotify.

Covers database fundamentals, SQL queries, advanced joins, indexing, stored procedures, triggers, performance optimization, and real-world projects.

Who this is for:
- Developers wanting to learn enterprise-grade databases
- Data analysts working with large datasets
- Backend developers building scalable applications

Course Syllabus

0 lessons · 3 modules
1. Database Fundamentals 4 lessons
  1. Lesson content for "What is a database and why PostgreSQL".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Installing PostgreSQL and pgAdmin".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Creating your first database".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Tables, rows and columns".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
2. SQL Queries 5 lessons
  1. Lesson content for "SELECT statements and WHERE clause".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "ORDER BY, GROUP BY and HAVING".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "INSERT, UPDATE and DELETE".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "JOINs - INNER, LEFT, RIGHT, FULL".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Subqueries and CTEs".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
3. Advanced PostgreSQL 5 lessons
  1. Lesson content for "Indexes and query optimization".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Views and materialized views".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Stored procedures and functions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Triggers and events".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Transactions and concurrency".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon

Student reviews

No reviews yet - be the first after you complete the course!

Prerequisites

Basic computer knowledge. No prior database experience needed.

Related courses