beeon.academy
backendIntermediate

MS SQL

An intermediate Microsoft SQL Server path: install/connect, SSMS, tables and types, T-SQL queries (TOP, JOIN, CTE), dialect quirks, indexes/transactions, logins/roles, backup, and a schema lab capstone. Practice in the player; run real batches in SSMS.

SQL ServerT-SQLSSMS
Duration
8 weeks
Starts
Students
0+
Rating
0 / 5
Starting from
49 000 ֏
Enrolling now
  • 8 weeks (31h 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 Microsoft SQL Server path: install/connect, SSMS, tables and types, T-SQL queries (TOP, JOIN, CTE), dialect quirks, indexes/transactions, logins/roles, backup, and a schema lab capstone. Practice in the player; run real batches in SSMS.

Across 8 weeks (31 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

Connect to SQL Server and work in SSMS
Write DDL/DML and JOIN/CTE in T-SQL style
Use TOP, NVARCHAR, and transaction habits
Practice backup and finish a mini schema capstone
Interactive course

Lessons

53 lessons · all open, start with any
  1. 1What is SQL Server?30 min
  2. 2SQL Server vs Postgres / MySQL30 min
  3. 3Editions peek25 min
  4. 4Install / connect40 min
  5. 5SSMS basics35 min
  6. 6Azure Data Studio peek30 min
  7. 7Practice habit25 min
  8. 8CREATE DATABASE30 min
  9. 9Schemas (dbo)30 min
  10. 10CREATE TABLE40 min
  11. 11Core types40 min
  12. 12IDENTITY35 min
  13. 13Constraints40 min
  14. 14Foreign keys40 min
  15. 15ALTER TABLE35 min
  16. 16DROP and TRUNCATE30 min
  17. 17INSERT35 min
  18. 18SELECT basics35 min
  19. 19WHERE40 min
  20. 20ORDER BY and TOP35 min
  21. 21OFFSET / FETCH30 min
  22. 22UPDATE and DELETE40 min
  23. 23INNER JOIN45 min
  24. 24LEFT JOIN40 min
  25. 25Aggregates40 min
  26. 26GROUP BY and HAVING45 min
  27. 27Subqueries40 min
  28. 28CTE (WITH)40 min
  29. 29Batches and GO30 min
  30. 30Variables35 min
  31. 31NVARCHAR and N'...'30 min
  32. 32DATETIME2 / dates30 min
  33. 33ISNULL and COALESCE30 min
  34. 34CASE expressions35 min
  35. 35Window functions lite40 min
  36. 36Indexes40 min
  37. 37Execution plan peek35 min
  38. 38Transactions40 min
  39. 39NOLOCK myth30 min
  40. 40SQL injection habit40 min
  41. 41Views30 min
  42. 42Stored procedures peek30 min
  43. 43Logins and users40 min
  44. 44Roles and grants40 min
  45. 45BACKUP DATABASE35 min
  46. 46RESTORE peek35 min
  47. 47SQL Server in Docker peek30 min
  48. 48Connection strings30 min
  49. 49Mini schema design40 min
  50. 50Mini T-SQL lab45 min
  51. 51When to pick SQL Server30 min
  52. 52Next steps25 min
  53. 53Capstone checklist40 min
Course modules

Syllabus

  1. 1
    • What is SQL Server?
    • Install / connect
    • SSMS basics
    • CREATE DATABASE
  2. 2
  3. 3
  4. 4
What you need to start

Requirements

  • A laptop and willingness to run SQL Server Dev/Express or a container
  • Basic SQL ideas help
  • No prior DBA experience required
Learn from a working engineer

Your instructor

TH

Tigran Hakobyan

Backend Mentor · beeon.academy

Instructor at beeon.academy. MS SQL / T-SQL path: 53 lessons through the capstone.

What graduates say

Student reviews

Common questions

FAQ

No. It checks T-SQL text. You run the same batches in SSMS locally.
Starting from
49 000 ֏
Register