Educational program"Analysis and management of data in the SQL language using the example of the MySQL DBMS"

Section 1. Basic components and principles of operation of the MySQL DBMS

• MySQL as a relational DBMS in an information system.
• Preparing and setting up a working circle for the MySQL DBMS.
• Creating a database in MySQL DBMS and setting access rights.

Section 2. Requests for data selection and modification

• Selecting data from one table.
• Retrieving data from multiple tables.
• Subqueries in a SELECT statement. Union, intersection and difference of sets.

Section 3: Using Views

• Retrieving data using views.
• Modifying data using views.
   

Section 4: Using Triggers

• Data aggregation using triggers.
• Control of data operations using triggers.

Section 5: Using Stored Functions and Procedures

• Using Stored Functions.
• Using stored procedures.

Section 6. Use of Transactions

• Transaction management.
• 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);
_____ (Thursday) 12.00 – 15.00 (4 academic hours), test (Kozlova St., 28).