Knowledge of modern database technologies, incl. SQL and NoSQL; 4 ECTS, official ITMO certificate
Application deadline
May 5, 2025
Fees
45,000 RUB
Program description
This course provides a practical, hands-on introduction to modern database technologies, focusing on both SQL and NoSQL systems. You’ll gain real-world experience by working directly with databases, applying key concepts to solve practical tasks, and working on your own project.
Participants will have access to five online video lectures and materials with various self-check quizzes and assignments. Additionally, there will be daily webinars on specific topics that will cover the theory and include extra materials for practice. We will provide continuous teacher support via messenger apps and email. You will be able to access course materials over the entire duration of the school.
Assessment options include:
personal assignments (90%);
50% personal assignments + final project (creating your own database).
Module 1: Structured Databases (SQL) You will learn to design and manage structured databases using Oracle and PostgreSQL. Namely, you will:
create data structures;
write queries using SQL;
use indexes, views, stored functions, and procedures;
use analytical (window) functions.
Module 2: NoSQL Technologies You will explore the core concepts of NoSQL databases with hands-on practice in Redis, Cassandra, Neo4J, and MongoDB. You will:
understand when and why to use NoSQL;
work with different NoSQL data models;
learn how these systems handle large-scale data storage and retrieval.
Limitless practice You will have remote access to the demo databases created by the course authors to complete practical assignments.
What you get
Official ITMO certificate, 4 ECTS
Assistance from experienced teachers during practical classes
Training in designing structured databases and creating ER diagrams
Practice in writing SQL queries and working with stored procedures, functions, indexes, and transactions
Understanding of NoSQL principles and hands-on practice of writing queries using Redis, Cassandra, Neo4J, and MongoDB
The course is meant for current university students or graduates
Applicants should be proficient in the English language (B1 and higher)
Students with basic school-level math
Program
Day 1
Information systems: outlines and architecture;
DBMS main functions and architecture;
Introduction to relational databases.
Day 2
Entity-relationship model diagrams: entity and relationship;
Converting ER diagrams into relational databases.
Day 3
Creating tables;
Integrity constraints.
Day 4
SELECT statement;
Selection conditions and sorting.
Day 5
Descriptive statistics and aggregate functions
Day 6
Subqueries;
Set-theoretic operations;
Joined tables.
Day 7
Database objects;
Stored functions.
Day 8
Introduction to NoSQL: key features and technology;
Examples of NoSQL systems: key-value storages (Redis basics) and document storage (MongoDB basics).
Day 9
Examples of NoSQL systems: graph databases (Neo4j basics) and column storages (Cassandra basics)
Day 10
Project presentation (defense of top ten projects/projects review)
School fees include:
Registration
Tuition
Tour of St. Petersburg
All taxes
Study materials
Application documents
A scanned copy of your passport (ID)
Scanned copies of your higher education documents (student ID + transcript of records or diploma)
CV
Motivation letter
Our staff
Elena Mikhailova Big data storage and processing
PhD in mathematics, associate professor
Director of the Higher School of Digital Culture, ITMO University
Head of the Master’s program Data Analytics, ITMO University
Teaches courses in database management systems, mathematics and statistics, and information retrieval
Author of online courses on database management systems and data processing and co-author of various courses on applied artificial intelligence
Involved in projects on data science
Authored articles indexed in Scopus and Web of Science
h-index in Scopus — 3
Natalia Grafeeva Big data storage and processing
PhD in mathematics
Associate professor at the Higher School of Digital Culture, ITMO University
Teaches advanced courses in database management systems
Author of online courses on database management systems and data processing and co-author of various courses on applied artificial intelligence
Professional experience in information systems development and database management systems in the field of restaurant business, energy, and stock exchange systems
Involved in projects on data science
Authored articles indexed in Scopus and Web of Science
Maria Tokman Big data storage and processing
PhD in physics
Lecturer at the Higher School of Digital Culture, ITMO University
Involved in research projects in atomic physics and data science
Teaches courses in Python, database management systems, and data processing
Industry expertise in the IT field
Authored articles indexed in Scopus and Web of Science
Olga Egorova Big data storage and processing
PhD in linguistics
Associate professor at ITMO University
Involved in research projects in phonetics, linguistics, and data science
Teaches courses in data processing, database management systems, and statistics in Russian and English
Authored articles indexed in Scopus and Web of Science
Why choose ITMO?
Ranked #595 by QS WUR out of 1,503 universities around the world
Named among the top 100 (#78) in the QS subject ranking Computer Science & Information Systems
Ranked #51−70 in the QS subject ranking Data Science & Artificial Intelligence
Ranked #146 in the QS subject ranking Electrical & Electronic Engineering
Winner of AI Journey Contest, Google Image Matching Challenge, Topcoder Open, and more
A scanned copy of the identity document is required for the following purposes: a. To check if the student is underage. In case the student is under 18 years old, we will require an ID of their legal representative. b. To compile a study contract that contains the full name of the student and their ID details. c. To bill the student and receive payment. d. To issue a school completion certificate and award ECTS credits.
You can submit your national ID instead.
Some summer schools at ITMO are offered for free. Unfortunately, there are no discounts or waivers for fee-based schools.
All ITMO schools are held on campus by default. Some may also be conducted online. Visit a school’s page for additional information.
Unfortunately, ITMO Dormitories are not available for the summer and winter breaks, therefore, summer and winter school students are offered to stay in our partner accommodations:
Absolutely! Once we confirm your participation and receive payment for the school, you will be assigned an ITMO Buddy who will help you with your arrival, airport pick-up, check-in, as well as orientation in St. Petersburg and ITMO.
We did our best to collect all the needed information in this article. Follow the link and learn more about typical prices on groceries, SIM card, transportation, and delivery services.
Yes, once the school fees are paid, you will receive your visa invitation letter if your studies are held on campus. The visa invitation letter is granted for the period of 3 days before and 3 days after the school’s official dates.
We organize a cultural event every weekend during summer and winter schools. You will enjoy a guided tour around the best St. Petersburg sites and participate in an entertaining quest in the historical center of the city.