2023/2024

SQL: basics

Type: Optional course (faculty)

Delivered by: International College of Economics and Finance

When: 2 module

Open to: students of one campus

Language: English

ECTS credits: 3

Contact hours: 20

Course Syllabus

Abstract

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.

Learning Objectives

• 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

Expected Learning Outcomes

• 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

Course Contents

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

Assessment Elements

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

Interim Assessment

• 2023/2024 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

Bibliography

Recommended Core Bibliography

• Beaulieu, A. (2009). Learning SQL : Master SQL Fundamentals: Vol. 2nd ed. O’Reilly Media.

Recommended Additional Bibliography

• Полякова, Л. Н. Основы SQL : учебное пособие / Л. Н. Полякова. — 2-е изд. — Москва : ИНТУИТ, 2016. — 273 с. — ISBN 978-5-94774-649-5. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/100348 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.