Бакалавриат
2022/2023
Управление данными
Статус:
Курс обязательный (Цифровые инновации в управлении предприятием)
Направление:
38.03.05. Бизнес-информатика
Кто читает:
Департамент бизнес-информатики
Где читается:
Высшая школа бизнеса
Когда читается:
1-й курс, 3 модуль
Формат изучения:
без онлайн-курса
Охват аудитории:
для своего кампуса
Язык:
английский
Кредиты:
4
Контактные часы:
40
Course Syllabus
Abstract
As the amount of data being produced everyday increases, the skill of working with data sources (databases) becomes an essential one for anyone involved in IT or management. After completing the 1st year Data Management course students will know how to connect to relational data sources, understand their structure, and write complex SQL queries to read and modify the data and prepare foundation for business intelligence reports.
The course mostly focuses on data manipulations with use of programming language. The course introduces students to the popular and widely used database server - PostgreSQL. Curriculum includes brief overview of relational databases and data formats, detailed study of SQL syntax, and a lot of programming tasks.
Learning Objectives
- Understand relational data model and relational database structure
- Learn to use special software to manage a database
- Retrieve and shape data from relational database
- Know key facilities available in database-related procedural programming
Expected Learning Outcomes
- Create database objects with SQL - procedures, functions and views
- Describe a relational database schema
- Develop complex queries with use of window functions
- Explore dependencies of attributes and solve data redundancy problems
- Find a plan for retrieving data from a relational DB in terms of relational operations
- Identify data model types
- Identify entities and relationships based on business rules analysis and create conceptual and logical models
- Organize data in table form
- Prepare reports and dashboards to provide access for users to business-critical information
- Retrieve data from connected tables
- Track and process changes in table data with triggers
- Use calculations in SQL queries
- Use client software to manage and fill a relational database
- Use IDEF1X method to create a database
- Use query editor to write and execute queries
- Use spreadsheet tools to store and process data
- Write analytical queries with aggregation
Course Contents
- Relational algebra. Retrieving data from multiple tables in DQL
- Advanced SQL. Analytical queries. Procedural SQL
- Reporting and data visualization
- Introduction to databases
Assessment Elements
- Team project
- Quiz on workshopsQuiz on methods and tools used in workshops
- Exam
- PracticeStudents will be asked to submit the result of their participation in the workshops in form of docx or pdf file. Each lesson comprises 5-7 exercises. If a student or a group of students successfully completes some exercise at teacher's computer or whiteboard, then they will automatically receive max grade for the lesson and report submission becomes unnecessary for them.
- Quiz on lectureQuiz includes 1-3 easy questions about material discussed during each lecture
- HomeworksHomeworks after each workshop include writing SQL queries and database development
Interim Assessment
- 2022/2023 3rd module0.05 * Quiz on workshops + 0.1 * Practice + 0.25 * Exam + 0.3 * Homeworks + 0.1 * Quiz on lecture + 0.2 * Team project
Bibliography
Recommended Core Bibliography
- Garcia-Molina, H., Ullman, J. D., Dawson Books, & Widom, J. (2014). Database Systems: Pearson New International Edition : The Complete Book (Vol. Second edition). Harlow, Essex: Pearson. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1418178
- Hoffer, J. A., Ramesh, V., & Topi, H. (2016). Modern Database Management, Global Edition (Vol. Global edition, Twelfth edition). Boston: Pearson. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1419666
Recommended Additional Bibliography
- Clark, D. (2017). Beginning Power BI : A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop (Vol. Second edition). Camp Hill, Pennsylvania: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1478775
- Foster, E. C., & Godbole, S. (2016). Database Systems : A Pragmatic Approach (Vol. Second edition). [United States]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1174505