Advanced SQL: stored database components - course RUB 21,500. from HSE, training 1 month, Date: April 17, 2023.

A stored procedure is a separate database object, block of code, or set of SQL statements that is executed as a single piece of code. Stored procedures save time and allow you to automate work with databases:

• define your own query behavior, different from their standard implementations,
• manage access to database content for different categories of users
• not just execute queries, but create reusable objects

In the online course “Advanced SQL: Stored Database Components” you will learn about procedural dialects of the SQL language and stored SQL components: views, rules, triggers, stored procedures and functions and learn how to create them, taking into account the differences in the definition and use of these stored components in different DBMSs: PostgreSQL, MS SQL Server, Oracle SQL.

Advantages of studying on the course:

01
Convenient format: classes with a teacher are held remotely, constant feedback from students
02
Individual approach: mentor consultations on each course topic
03
Emphasis on practice

Learning outcomes

After defending your final project, you will be able to:

1. Use the capabilities of different database management systems
   create stored components in various DBMSs
2. use triggers
   create different types of triggers to ensure data integrity 
3. create cursors in various DBMSs
   and organize non-linear access to data and their processing
4. use views and rules in various DBMSs
   manage access to data for different categories of users

Training format

Total duration in hours
41 hours

Admission conditions
Students must have basic knowledge of the SQL language (at the level of writing simple queries: INSERT, UPDATE, DELETE, SELECT).

Training format
Online

Composition of the group
Standard group size 15 people

Language of instruction
Russian

Timetable of classes
Monday and Thursday from 18.10 to 21.00

Educational requirements
The course is open to anyone who has a secondary or higher professional education, as well as students of universities and vocational training.

Mentoring
Telegram group and constant feedback from the teacher and curator

Teacher of the course “Simulation modeling for analysis and optimization of business processes.” Associate Professor at the Faculty of Informatics, Mathematics and Computer Science at the Higher School of Economics in Nizhny Novgorod, PhD in Computer Science. Expert in the field of business informatics, academic director of the educational program "Business Informatics" at the Higher School of Economics - Nizhny Novgorod. Best teacher at the National Research University Higher School of Economics in 2018, 2019, 2020, 2021 and 2022.