PostgreSQL course

Learn everything from SQL queries to database design, optimization and administration in the PostgreSQL course. Classes are held twice a week, 2 hours each; graduates receive a certificate.

UX/UI design Backend development Digital marketing

Per week:

2

/day

Duration:

3

/month

Age:

18-50

/age

Per week:

4

/hour

Course program

11 topic 55 lesson
01 Introduction to PostgreSQL 4 lessons
  1. 1
    What is PostgreSQL? History and features
  2. 2
    PostgreSQL compared with MySQL, Oracle and SQL Server
  3. 3
    Installation and configuration (Linux, Windows, macOS)
  4. 4
    psql command-line basics
02 SQL fundamentals 5 lessons
  1. 5
    Database objects (schemas, tables, views, sequences)
  2. 6
    Data types: numeric, text, boolean, date/time, JSON/JSONB
  3. 7
    DDL (CREATE, ALTER, DROP)
  4. 8
    DML (INSERT, UPDATE, DELETE, SELECT)
  5. 9
    Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL)
03 Querying data 6 lessons
  1. 10
    SELECT basics, WHERE, ORDER BY
  2. 11
    Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
  3. 12
    GROUP BY, HAVING
  4. 13
    Joins: INNER, LEFT, RIGHT, FULL
  5. 14
    Subqueries, common table expressions (CTEs)
  6. 15
    Window functions (OVER, PARTITION BY, RANK, ROW_NUMBER)
04 Advanced SQL 6 lessons
  1. 16
    Complex joins and set operations (UNION, INTERSECT, EXCEPT)
  2. 17
    Recursive CTEs
  3. 18
    CASE expressions
  4. 19
    Advanced filtering with EXISTS, IN, ANY, ALL
  5. 20
    Full-text search basics
  6. 21
    JSON/JSONB functions and operators
05 Database design and modeling 5 lessons
  1. 22
    Normalization (1NF, 2NF, 3NF, BCNF)
  2. 23
    ER diagrams
  3. 24
    Indexes: B-tree, Hash, GIN, GiST, BRIN
  4. 25
    Partitioning strategies (range, list, hash) and sharding
  5. 26
    Constraints and referential integrity
06 Performance and optimization 5 lessons
  1. 27
    Query execution plans (EXPLAIN, EXPLAIN ANALYZE)
  2. 28
    VACUUM, ANALYZE, autovacuum
  3. 29
    Indexing strategies
  4. 30
    Parallel queries
  5. 31
    Optimizing joins and subqueries
07 Administration and security 5 lessons
  1. 32
    PostgreSQL configuration files (postgresql.conf, pg_hba.conf)
  2. 33
    Role-based access control (users, groups, privileges)
  3. 34
    Authentication methods (peer, scram-sha-256, certificates, SSL/TLS)
  4. 35
    Backup and recovery (pg_dump, pg_restore, pg_basebackup)
  5. 36
    Monitoring with pg_stat_activity and pg_stat_statements
08 Advanced features 5 lessons
  1. 37
    Stored procedures and functions (PL/pgSQL)
  2. 38
    Triggers and events
  3. 39
    Views and materialized views
  4. 40
    Extensions (PostGIS, pgcrypto, uuid-ossp, hstore)
  5. 41
    Logical and physical replication
09 High availability and scaling 5 lessons
  1. 42
    Streaming replication
  2. 43
    Hot standby / warm standby
  3. 44
    Failover and switchover
  4. 45
    Connection pooling (PgBouncer, Pgpool-II)
  5. 46
    Scaling reads and writes
10 Real-world applications 5 lessons
  1. 47
    ETL with PostgreSQL (COPY, Foreign Data Wrappers)
  2. 48
    Using PostgreSQL with Python/Java (JDBC, psycopg 3, Hibernate)
  3. 49
    Data warehousing concepts
  4. 50
    Audit logging and regulatory compliance
  5. 51
    Using JSON as a document store vs. relational modeling
11 Final project 4 lessons
  1. 52
    Building a mini banking system (accounts, transactions, balances)
  2. 53
    Building an e-commerce database (products, orders, customers)
  3. 54
    Designing a real-time analytics dashboard with PostgreSQL + Power BI
  4. 55
    Final project presentation

Our instructors

Meet our experienced teachers!

  • Leyla İsayeva — instructor

    Leyla İsayeva

    PostgreSQL course
  • Ayaz Abdullayev — instructor

    Ayaz Abdullayev

    PostgreSQL course

    Don't know where to start?

    Not sure where to start?

    Get free advice

    Fill in the details and we'll get in touch with you.

    +994

    Your data is used only to contact you.

    Contact us directly (+994 10) 234 65 56
    CoursePostgreSQL course
    • Address
    • 609 Jafar Jabbarli St., Baku / Globus Center

    • Social networks