beeon.academy
backendIntermediate

PostgreSQL

An intermediate PostgreSQL path: install and psql, tables and types, SQL queries (JOIN, CTE, window), JSONB/array/UUID, indexes and transactions, roles/GRANT, pg_dump, and a schema lab capstone. Practice snippets in the player; run real Postgres with psql on your machine.

PostgreSQLSQLpsqlJSONB
Duration
8 weeks
Starts
Students
0+
Rating
0 / 5
Starting from
49 000 ֏
Enrolling now
  • 8 weeks (33h total)
  • Starts
  • online format
  • HY · EN · RU
  • Certificate on completion
Register nowStart learning

No payment required to register · We’ll contact you within 24h

What this course is about

Overview

An intermediate PostgreSQL path: install and psql, tables and types, SQL queries (JOIN, CTE, window), JSONB/array/UUID, indexes and transactions, roles/GRANT, pg_dump, and a schema lab capstone. Practice snippets in the player; run real Postgres with psql on your machine.

Across 8 weeks (33 hours of live + project work) you’ll move from fundamentals to shipping a real, production-grade project — guided by Tigran Hakobyan and the beeon.academy mentor team.

Learning outcomes

What you will learn

Install Postgres and work in psql
Write DDL/DML plus JOIN/CTE queries
Use JSONB, indexes, and transaction habits
Dump/restore and finish a mini schema capstone
Interactive course

Lessons

55 lessons · all open, start with any
  1. 1What is PostgreSQL?30 min
  2. 2Postgres vs MySQL / SQL Server30 min
  3. 3Install PostgreSQL40 min
  4. 4createdb and dropdb30 min
  5. 5psql basics40 min
  6. 6Connection pieces30 min
  7. 7Practice habit25 min
  8. 8CREATE TABLE40 min
  9. 9Core types40 min
  10. 10IDENTITY / SERIAL35 min
  11. 11NULL and DEFAULT30 min
  12. 12Constraints40 min
  13. 13Foreign keys40 min
  14. 14ALTER TABLE35 min
  15. 15DROP and TRUNCATE30 min
  16. 16Schemas35 min
  17. 17INSERT35 min
  18. 18SELECT basics35 min
  19. 19WHERE40 min
  20. 20ORDER BY / LIMIT / OFFSET30 min
  21. 21UPDATE and DELETE40 min
  22. 22JOIN45 min
  23. 23LEFT JOIN40 min
  24. 24Aggregates40 min
  25. 25GROUP BY and HAVING45 min
  26. 26Subqueries40 min
  27. 27CTE (WITH)40 min
  28. 28Window functions lite45 min
  29. 29Text operators35 min
  30. 30Dates and intervals35 min
  31. 31Arrays lite40 min
  32. 32JSONB45 min
  33. 33Query JSONB40 min
  34. 34UUID30 min
  35. 35ENUM types30 min
  36. 36Indexes40 min
  37. 37EXPLAIN lite35 min
  38. 38Transactions40 min
  39. 39Isolation lite35 min
  40. 40Locks peek30 min
  41. 41SQL injection habit40 min
  42. 42Views30 min
  43. 43Functions peek30 min
  44. 44Roles and LOGIN40 min
  45. 45GRANT and REVOKE40 min
  46. 46pg_hba.conf peek30 min
  47. 47pg_dump35 min
  48. 48Restore habit35 min
  49. 49Extensions peek30 min
  50. 50Postgres in Docker peek30 min
  51. 51Mini schema design40 min
  52. 52Mini query lab45 min
  53. 53When to pick Postgres30 min
  54. 54Next steps25 min
  55. 55Capstone checklist40 min
Course modules

Syllabus

  1. 1
    • What is PostgreSQL?
    • Install PostgreSQL
    • psql basics
    • Connection pieces
  2. 2
  3. 3
  4. 4
What you need to start

Requirements

  • A laptop and willingness to install PostgreSQL
  • Basic SQL ideas help (or the Databases path)
  • No prior DBA experience required
Learn from a working engineer

Your instructor

TH

Tigran Hakobyan

Backend Mentor · beeon.academy

Instructor at beeon.academy. PostgreSQL path: 55 lessons through the capstone.

What graduates say

Student reviews

Common questions

FAQ

No. It checks SQL text. You run the same statements in psql locally.
Starting from
49 000 ֏
Register