• A
  • A
  • A
  • ABC
  • ABC
  • ABC
  • А
  • А
  • А
  • А
  • А
Regular version of the site
For visually-impairedFor visually-impairedUser profile (HSE staff only)Search
Advanced search
Menu
HSE University
User profile (HSE staff only)Search
Advanced search

Course Syllabus

Bachelor 2022/2023

Data Management

Type: Compulsory course (Management and Digital Innovation)
Area of studies: Business Informatics
Delivered by: Department of Business Informatics
Where: Graduate School of Business
When: 1 year, 3 module
Mode of studies: offline
Open to: students of one campus
Instructors: Kirill Gomenyuk, Darya Meylakh, Dmitry Neklyudov
Language: English
ECTS credits: 4
Contact hours: 40

Course Syllabus

Full 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

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

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

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

Assessment Elements

  • non-blocking Team project
  • non-blocking Quiz on workshops
    Quiz on methods and tools used in workshops
  • non-blocking Exam
  • non-blocking Practice
    Students 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.
  • non-blocking Quiz on lecture
    Quiz includes 1-3 easy questions about material discussed during each lecture
  • non-blocking Homeworks
    Homeworks after each workshop include writing SQL queries and database development
Interim Assessment

Interim Assessment

  • 2022/2023 3rd module
    0.05 * Quiz on workshops + 0.1 * Practice + 0.25 * Exam + 0.3 * Homeworks + 0.1 * Quiz on lecture + 0.2 * Team project
Bibliography

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

Authors

  • MEYLAKH DARYA ROMANOVNA
  • GOMENYUK KIRILL SERGEEVICH
  • NEKLYUDOV DMITRIY YUREVICH
  • YAKOVLEVA NATALIYA VADIMOVNA