beeon.academy
backendIntermediate

Databases

An intermediate Databases path: relational model and SQL first, then MySQL/MariaDB (and Percona peek), PostgreSQL, Microsoft SQL Server / T-SQL, engine comparison, and NoSQL with MongoDB and CouchDB. Practice snippets in the player; run real engines on your machine. ORM frameworks stay in their own courses.

SQLMySQLMariaDBPostgreSQLSQL ServerMongoDBCouchDB
Duration
10 weeks
Starts
Students
0+
Rating
0 / 5
Starting from
59 000 ֏
Enrolling now
  • 10 weeks (47h 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 Databases path: relational model and SQL first, then MySQL/MariaDB (and Percona peek), PostgreSQL, Microsoft SQL Server / T-SQL, engine comparison, and NoSQL with MongoDB and CouchDB. Practice snippets in the player; run real engines on your machine. ORM frameworks stay in their own courses.

Across 10 weeks (47 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

Design simple relational schemas with keys and constraints
Write SELECT/JOIN/aggregates and safe UPDATE/DELETE habits
Work with MySQL/MariaDB, PostgreSQL, and SQL Server dialects
Use MongoDB and CouchDB basics and know when NoSQL fits
Interactive course

Lessons

80 lessons · all open, start with any
  1. 1What is a database?30 min
  2. 2Databases vs files30 min
  3. 3Clients and servers30 min
  4. 4SQL as a language35 min
  5. 5Relational idea35 min
  6. 6Practice habit30 min
  7. 7Map of this course25 min
  8. 8Tables and rows35 min
  9. 9Columns and types40 min
  10. 10Primary keys35 min
  11. 11Foreign keys40 min
  12. 12NULL means unknown30 min
  13. 13Constraints35 min
  14. 14Normalization lite40 min
  15. 15Sketch an ERD35 min
  16. 16CREATE TABLE40 min
  17. 17INSERT35 min
  18. 18SELECT basics40 min
  19. 19WHERE filters40 min
  20. 20ORDER BY and LIMIT30 min
  21. 21UPDATE and DELETE40 min
  22. 22JOIN intro45 min
  23. 23INNER / LEFT JOIN45 min
  24. 24Aggregates40 min
  25. 25GROUP BY45 min
  26. 26HAVING35 min
  27. 27Subqueries lite40 min
  28. 28Transactions40 min
  29. 29Indexes40 min
  30. 30Views lite30 min
  31. 31SQL injection habit40 min
  32. 32MySQL overview35 min
  33. 33MariaDB overview35 min
  34. 34Install MySQL/MariaDB40 min
  35. 35mysql client35 min
  36. 36MySQL types peek35 min
  37. 37InnoDB habit30 min
  38. 38Users and grants40 min
  39. 39Dump and restore35 min
  40. 40MySQL vs MariaDB30 min
  41. 41Percona peek30 min
  42. 42MySQL practice lab40 min
  43. 43MySQL family wrap25 min
  44. 44PostgreSQL overview35 min
  45. 45Install PostgreSQL40 min
  46. 46psql basics35 min
  47. 47Postgres types peek40 min
  48. 48Schemas35 min
  49. 49JSONB lite40 min
  50. 50Roles and privileges35 min
  51. 51pg_dump habit30 min
  52. 52Postgres practice lab40 min
  53. 53Postgres wrap25 min
  54. 54SQL Server overview35 min
  55. 55Install / connect40 min
  56. 56SSMS / Azure Data Studio30 min
  57. 57T-SQL differences40 min
  58. 58SQL Server types35 min
  59. 59T-SQL practice lab40 min
  60. 60SQL Server vs others30 min
  61. 61SQL Server wrap25 min
  62. 62Compare RDBMS35 min
  63. 63DB in Docker peek35 min
  64. 64Backup mindset30 min
  65. 65Connection strings30 min
  66. 66ORM boundary30 min
  67. 67What is NoSQL?35 min
  68. 68When NoSQL fits30 min
  69. 69MongoDB overview35 min
  70. 70Install / connect Mongo35 min
  71. 71Mongo CRUD40 min
  72. 72Mongo queries40 min
  73. 73Mongo indexes lite30 min
  74. 74CouchDB overview35 min
  75. 75CouchDB documents35 min
  76. 76NoSQL vs SQL wrap35 min
  77. 77Mini schema design40 min
  78. 78Mini SQL lab45 min
  79. 79Next steps30 min
  80. 80Capstone checklist45 min
Course modules

Syllabus

  1. 1
    • What is a database?
    • SQL as a language
    • Relational idea
    • Map of this course
  2. 2
  3. 3
  4. 4
What you need to start

Requirements

  • A laptop and willingness to install at least one SQL engine locally
  • Basic comfort with a terminal or a DB GUI client
  • No prior DBA experience required
Learn from a working engineer

Your instructor

TH

Tigran Hakobyan

Backend Mentor · beeon.academy

Instructor at beeon.academy. Databases path: 80 lessons through the capstone.

What graduates say

Student reviews

Common questions

FAQ

No. It checks your SQL/NoSQL text. You run the same statements in mysql, psql, SSMS, or mongosh locally.
Starting from
59 000 ֏
Register