SQL c нуля

2024/2025

Статус: Маго-лего

Кто читает: Международный институт экономики и финансов

Когда читается: 2 модуль

Охват аудитории: для своего кампуса

Преподаватели: Полянская Маргарита Игоревна

Язык: русский

Кредиты: 3

Полная версия программы учебной дисциплины

Аннотация

SQL 101 is an introduction course that doesn’t rely on any background technical knowledge. The main goal of the course is to familiarise students with SQL language syntax and the core concepts so that the students are able to use it in a work environment and deepen the related knowledge by themselves.

Цель освоения дисциплины

i. Get started with learning SQL from scratch including students without technical background
ii. Acquire a SQL knowledge level sufficient for: a. Using it to create basic queries to databases b. Delving deeper into SQL syntax and use case without additional help c. Understanding the role of SQL in data analysis related questions
iii. Practice SQL skills by solving tasks based on real life problems

Планируемые результаты обучения

Use basic SQL clauses in a query without getting technical errors: 1.SELECT 2.FROM 3.WHERE 4.ORDER BY
1. Know how to use aggregation functions such as sum, avg, max, min 2. Use GROUP BY clause to calculate metrics within certain groups
1. Understanding what a JOIN clause and when it's nessesary to use one 2. Differenciate between JOIN type: inner, left, right, full 3. Use JOIN clause with multiple keys
1. Understanding what role data types in SQL have 2. Distinguish different numerical, text, logical and date data types 3. Ability to convert data types
1. Knowledge how to use the CASE WHEN statement to create new columns and filter 2. Know how to use conditional statements inside aggregation functions 3. Ability to use an LIKE operator to filter text values by patterns
1. Ability to use subqueries in a SQL query both as a Common Table Expression and as a classical Understanding what window functions are and when there is a need to use them

Содержание учебной дисциплины

Key SQL clauses
Aggregation and grouping
Joins
Data types, conversion
Conditional statements
Subqueries and window functions

Элементы контроля

home assignment 4
home assignment 5
home assignment 6
home assignment 3
test
home assignment 1
home assignment 2

Промежуточная аттестация

2024/2025 2nd module
0.1 * home assignment 1 + 0.11 * home assignment 2 + 0.15 * home assignment 3 + 0.1 * home assignment 4 + 0.15 * home assignment 5 + 0.1 * home assignment 6 + 0.29 * test

Программа дисциплины