SQL queries and the basics of their optimization based on PostgreSQL (ONLINE) from March 3
For more information contact:
Leading specialistOrdynskaya Marina Yurievna, room 607-7., tel. +375 17 397-82-95, +375 29 639-65-63,
e-mail:ordinskaya@bsuir.by
leading specialistKrischenovich Veronika Anatolyevna,room 607-7., tel. +375 17 397-82-95, +375 29 390-88-95,
e-mail:krish@bsuir.by
Deputy DeanGarbuz Vitaly Borisovich, room 402-8., tel. +375 29 686-61-14,
e-mail:garbuz@bsuir.by
Registration is carried out via an electronic form. Training begins as groups are formed.
Price
550 BYN
Duration
36 hours
About the program
Advanced training program "SQL queries and the basics of their optimization based on PostgreSQL"
Program content:
SECTION I. General concepts and principles of relational databases (2 hours)
Topic 1.1. Basic concepts of database management systems
SECTION II. SQL Basics (22 hours)
- Topic 2.1. Basic SQL statements and data types
- Topic 2.2. Single-table SQL queries
- Topic 2.3. Grouping and Aggregation in SQL Queries
- Topic 2.4. Subqueries Returning Scalar and Set
- Topic 2.5. Multi-table queries
- Topic 2.6. Normalizing tables
SECTION III. Query evaluation and optimization (12 hours)
- Topic 3.1. Query Execution Plan
- Topic 3.2. Indexes
- Topic 3.3. General table expressions
- Topic 3.4. Searching for text using SQL
- Topic 3.5. Full text search capabilities
Preliminary class schedule:
March 3, 2026 (Tue) 18:00 - 21:00 (4 school hours);
March 5, 2026 (Thu) 18:00 - 21:00 (4 school hours);
March 10, 2026 (Tue) 18:00 - 21:00 (4 school hours);
March 12, 2026 (Thu) 18:00 - 21:00 (4 school hours);
March 17, 2026 (Tue) 18:00 - 21:00 (4 school hours);
March 19, 2026 (Thu) 18:00 - 21:00 (4 school hours);
March 24, 2026 (Tue) 18:00 - 21:00 (4 school hours);
March 26, 2026 (Thu) 18:00 - 21:00 (4 school hours).
March 31, 2026 (Tue) 18:00 - 21:00 (4 academic hours), TEST (in person, Kozlov St., 28).
Apply for the program
SQL queries and the basics of their optimization based on PostgreSQL (ONLINE) from March 3