MS‐SQL – programming

Why take this course

Want to learn the SQL query language in the Microsoft environment and start creating your own queries, procedures, and functions? Through this training, you’ll master both ANSI SQL fundamentals and the T-SQL extensions used in SQL Server. You’ll learn not only how to retrieve data, but also how to process, aggregate, sort, filter, and present it – all in a practical, hands-on way.

What you’ll learn

• Understand the structure of MS SQL databases
• Write SQL queries using T-SQL extensions
• Use DML and DDL statements in daily work
• Join data from multiple tables and write complex queries
• Use built-in functions and create your own
• Handle exceptions and errors in T-SQL
• Create views, indexes, and aggregate functions
• Program in T-SQL using conditions, loops, and variables
• Optimize queries and automate processes

Certification & Exam

Upon completing the course, you will receive a personalized certificate confirming your skills in SQL and T-SQL in the MS SQL Server environment – including creating queries, procedures, handling errors, and processing data. There is no final exam – active participation in the sessions is enough.

Who is this course for

• Professionals involved in building, administering, and managing MS SQL databases
• Developers and data analysts starting to work with T-SQL
• Project team members processing and analyzing data
• IT specialists looking to learn SQL in the Microsoft environment
• Individuals who want to consolidate and expand their MS SQL knowledge

Topics covered

• Basics of SQL Server operation and support for MS SQL Server Management Studio
• MS ‐ SQL syntax
• Data Types
• Creating simple and complex queries (select, distinct, case, group by, order by, having, aliases, subqueries)
• DML and DDL instructions
• Indexes (types, structure, principles of creation, use)
• Joining tables (inner, outer, self, cross)
• Sorting, filtering
• Creating views, their use and restrictions
• Built-in, ranking, shifts, aggregation functions
• Array expressions
• Operations on UNION, EXCEPT, INTERSECT, APPLY files
• Programming in T ‐ SQL (loops, conditions, creating variables, functions)
• Exception and error handling
• Most common mistakes and practical remarks
• Practical exercises