Start with T-SQL - Learn MS SQL Basics

Kickstart your journey into the world of relational databases with hands-on Microsoft SQL Server training!

This course is designed for beginners – developers, analysts, and DBAs – who want to learn how to query and manage data using Transact-SQL (T-SQL).

The training combines short expert-led lectures with real-world exercises to give you practical skills from day one. You’ll learn how databases are built, how to write effective SQL queries, and how to transform data into valuable insights.

📊 Gain job-ready skills you can use in reporting, analysis, and database management.
👉 Sign up now and start speaking the language of data!

Course Content:

• Relational databases – key concepts (tables, keys, normalization)
• SQL Server Management Studio basics
• SELECT queries and filtering (WHERE, TOP, sorting, aliases)
• Data types, conversions, text/date functions
• GROUP BY, aggregate functions
• Table joins (INNER, LEFT, etc.) and common issues
• PIVOT, UNPIVOT, APPLY
• UNION, INTERSECT, EXCEPT
• Subqueries and Common Table Expressions (CTEs)
• Data modification: INSERT, UPDATE, DELETE, MERGE
• Transactions and data locking
• Indexes and query performance basics
• Creating tables and constraints
• Views – creation and usage