Advanced training program "​Language for managing relational databases (based on the MS SQL SERVER platform)"

Program content:

Section I. Basic components and principles of operation of the MS SQL Server DBMS.
Topic 1.1. MS SQL Server as a relational DBMS.
Topic 1.2. Preparing and setting up a working environment for MS SQL Server.
Topic 1.3. Creating databases in MS SQL Server and setting access rights.

Section II. Sample requests.
Topic 2.1. Selecting data from one table.
Topic 2.2. Retrieving data from multiple tables.
Topic 2.3. Subqueries in a SELECT statement. Union, intersection and difference of sets.

Section III. Using views.
Topic 3.1. Retrieving data using views.
Topic 3.2. Modifying data using views.

Section IV. Using triggers.
Topic 4.1. Data aggregation using triggers.
Topic 4.2. Control of data operations using triggers.

Section V. Using Stored Functions and Procedures.
Topic 5.1. Using Stored Functions.
Topic 5.2. Using stored procedures.

Section VI. Using transactions.
Topic 6.1. Transaction management.
Topic 6.2. Competing transactions.

Preliminary schedule of classes (webinars):

________________  (Mon) 12.00 – 15.00 (4 school hours);
________________ (Tue) 12.00 – 15.00 (4 school hours);
________________  (Wed) 12.00 – 15.00 (4 school hours);
________________  (Thursday) 12.00 – 15.00 (4 school hours);
________________ (Fri) 12.00 – 15.00 (4 school hours);
________________  (Mon) 12.00 – 15.00 (4 school hours);
________________ (Tue) 12.00 – 15.00 (4 school hours);
________________  (Wed) 12.00 – 15.00 (4 school hours);
________________  (Thu) 12.00 – 15.00 (4 academic hours), test (Kozlova St., 28).