DESCRIPTION
This course provides a solid foundation in SQL and its use for managing relational databases, from core concepts to advanced analytical techniques. Participants will learn how to create and manage database structures, write and execute SQL queries, and work effectively with data.
The program covers essential SQL topics such as tables, data types, filtering, sorting, joins, aggregate functions, and data manipulation (INSERT, UPDATE, DELETE), as well as principles of database normalization, table relationships, and access control.
A strong focus is placed on advanced SQL for data analysis, including window functions such as ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD(), and FIRST_VALUE(), using OVER(), PARTITION BY, and ORDER BY. Participants will learn to compare data across rows, calculate running totals, perform cumulative and moving aggregates, and analyze performance trends.
Throughout the course, students will work on practical SQL challenges inspired by real interview questions from leading global tech companies, strengthening their analytical and problem-solving skills.

KNOWLEDGE TO BE GAINED
Training key topics include:
Data Analysis & SQL
SELECT — Choosing Columns
Filtering Rows
Sorting & String Functions
Date & Time Functions
Aggregate Functions & Grouping
Combining Data from Multiple Table
Subqueries; Modifying Data & Tables
Window Functions
Ranking and Row Numbering
Offset and Value Comparison
Aggregations and Running Totals
Frames and Advanced Options
Practice and Data Analytics

Upon completion of the course, the participants will be able to confidently retrieve, organize, and analyze data using SQL, gaining full control over how data is stored and used to support informed, data-driven decision-making.

TRAINING DETAILS
Training duration: 3 months / 48 hours / 2 times per week
Training fee: 69.000 AMD (1.5 months)
Training total fee: 138.000 AMD