T–SQL on Microsoft Azure – efficient management of database servers and effective use of Microsoft Azure cloud capabilities

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Hands-on Azure SQL setup - You will learn how to create an Azure database, configure an IP firewall, connect to the service, and run queries safely in a real cloud-based SQL environment.

Better database design - You will improve how you design tables and relationships, so you can build data structures with proper keys, constraints, and a stronger foundation for performance.

Confident T-SQL querying - You will master SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY, which will help you write cleaner queries that return exactly the data you need.

Smarter joins and filtering - You will learn how to use joins, set-based operations, TOP, and subqueries to combine data from multiple tables and narrow results without unnecessary mistakes.

Control over script logic - You will work with variables, IF conditions, and loops, giving you the ability to build T-SQL scripts that automate repetitive tasks and organize processing logic.

Choosing data types wisely - You will understand when to use numeric, text, date and time, XML, and other types, helping you reduce errors, store data properly, and simplify later analysis.

Building procedures and functions - You will learn the difference between procedures and functions and create both stored procedures and scalar functions to organize business logic inside the database.

Safer work with data - You will practice transactions, the ACID principle, error handling, and triggers, so you can protect data integrity more effectively and reduce the impact of failed operations.

Training programme

1. A few words of introduction about the MS Azure platform

2. Advantages and possibilities of using the Azure cloud

3. Basics of relational databases

relationships, data integrity, data normalization,
table, row, column,
tuple,
primary and foreign key and relationships between tables.

4. Creating efficient and stable databases in the Azure service

creating a database,
creating an IP firewall at the server level,
connecting to the database,
executing queries against the database,
cleaning up resources.

5. Managing SQL database servers and single databases by using the Transact-SQL language

6. Fundamentals of T-SQL query syntax – basic principles of writing queries in T-SQL

selection statements using the keyword SELECT,
specification of sources and the relationships between them – FROM,
use of the WHERE clause to select the required rows,
grouping records using GROUP BY,
filtering groups using the HAVING statement,
sorting the result – ORDER BY,
selecting the first n rows (TOP),
combining data using the apparatus of set theory.

7. Working with subqueries – how to create and optimize subqueries

nested subqueries,
correlated subqueries,
EXISTS operator.

8. Variables – creating variables, assigning values, and their use in loops and conditions

creating and modifying scalar functions,
table-valued (DECLARE).

9. Available data types

numeric (tinyint, smallint, int, bigint),
text (char, varchar, nchar, ntext, nvarchar),
date and time (datetime, smalldatetime),
XML (Extensible Markup Language),
other (e.g. hierarchyid, cursor).

10. Control instructions enabling control of program flow

conditional instruction IF,
loops (LOOP, WHILE, FOR).

11. Relational databases

the process of creating a database,
normalization – advantages and disadvantages,
denormalization – advantages and disadvantages.

12. Characteristics of tables – different types of tables, their properties and structure

temporary,
global.

13. Table construction – how to properly create tables that will meet the performance and structural requirements of the application

creating (CREATE) and deleting (DROP) tables,
auto-numbering of rows,
types of data types,
joining tables (INNER JOIN, OUTER JOIN),
constraints (integrity constraints).

14. Working with data in databases

inserting data – INSERT,
updating data – UPDATE,
deleting data – DELETE.

15. Differences between procedures and functions

16. Stored procedures

application,
general structure of a stored procedure,
creating a procedure.

17. Transactions – transaction management in SQL

theoretical basis (ACID principle),
implementation examples,
error management.

18. Triggers – how to define triggers, manage them, and use them to ensure data integrity

DML (INSERT, UPDATE, DELETE),
DDL (CREATE, ALTER, DROP).

What are the prerequisites for participating in the training?

Computer literacy - You should be comfortable using a computer, launching applications, copying data, and navigating basic system tools that will be used during the training.

Basic data concepts - You should understand what records, columns, and tables are and be able to read simple data sets, so the examples presented in class will be easier to follow.

Logical thinking - You should be able to analyze relationships and conditions, because the training includes data filtering, table relations, and the logic behind queries and scripts.

Basic technical English - You should recognize basic technical English terms such as SELECT, INSERT, and UPDATE, because T-SQL syntax and command names are based on English keywords.