Master
2024/2025
SQL Basics for Finance Professionals
Type:
Elective course (Investments in Financial Markets)
Area of studies:
Finance and Credit
Delivered by:
Master's Programmes Curriculum Support
Where:
Faculty of Economic Sciences
When:
2 year, 3 module
Mode of studies:
offline
Open to:
students of one campus
Instructors:
Nikolay I. Berzon
Master’s programme:
Investments in Financial Markets
Language:
English
ECTS credits:
3
Course Syllabus
Abstract
This SQL course is designed differently than most other courses. We will not try to learn all possible sets of SQL functions; instead, we will focus our attention on the principles of how queries are built and on the basis of which operators these queries are implemented.To achieve this goal, the course is equipped with a large number of exercises that should help build those very necessary connections in our brain,so that in the future you don’t have to think too much when composing queries to databases.While taking the course, we strongly encourage you to cultivate a “growth mindset”: if you encounter any challenges,When trying to understand a new topic or doing exercises, try to transform the frustrating experience that arises into a productive one.And the most important thing about this course is to have fun!
Learning Objectives
- SQL - how queries are built and on the basis of which operators these queries are implemented.
Bibliography
Recommended Core Bibliography
- Linoff, G. (2016). Data Analysis Using SQL and Excel: Vol. Second edition. Wiley.
- MySQL по максимуму : проверенные стратегии, Ботрос, С., 2023
- Seamark, P. (2018). Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence. [United States]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1743806
- SQL : быстрое погружение, Шилдс, У., 2023
- SQL. Полное руководство, Грофф, Дж., 2018
Recommended Additional Bibliography
- Beighley, L. (2007). Head First SQL : Your Brain on SQL —— A Learner’s Guide. Reilly - O’Reilly Media.
- SQL Server : наладка и оптимизация для профессионалов, Короткевич, Д., 2023