2026/2027

Основы SQL для финансистов
ID 1018298
Язык:
русский
Кредиты:
3
Контактные часы:
24
Программа дисциплины
Аннотация
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!
Цель освоения дисциплины
- SQL - how queries are built and on the basis of which operators these queries are implemented.
Список литературы
Рекомендуемая основная литература
- 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
Рекомендуемая дополнительная литература
- Beighley, L. (2007). Head First SQL : Your Brain on SQL —— A Learner’s Guide. Reilly - O’Reilly Media.
- SQL Server : наладка и оптимизация для профессионалов, Короткевич, Д., 2023