• A
  • A
  • A
  • ABC
  • ABC
  • ABC
  • А
  • А
  • А
  • А
  • А
Regular version of the site
Bachelor 2021/2022

Data Management

Type: Compulsory course
Area of studies: Business Informatics
When: 2 year, 1, 2 module
Mode of studies: offline
Open to: students of one campus
Instructors: Kirill Gomenyuk, Dmitry Neklyudov, Хахан Маргарита Львовна
Language: English
ECTS credits: 5
Contact hours: 60

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

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

  • Introduction to data management. Database systems
  • Relational algebra. Retrieving data from multiple tables in DQL
  • Database design
  • Data manipulations in structured query language. Create, read, update and delete operations.
  • Advanced SQL. Analytical queries. Procedural SQL
  • Reporting and data visualization
Assessment Elements

Assessment Elements

  • non-blocking Team project
  • non-blocking Test
  • non-blocking Exam
  • non-blocking Practice
  • non-blocking Quiz on lecture
Interim Assessment

Interim Assessment

  • 2021/2022 2nd module
    0.2 * Exam + 0.25 * Practice + 0.1 * Quiz on lecture + 0.25 * Team project + 0.2 * Test
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

  • KHAKHAN MARGARITA LVOVNA
  • GOMENYUK KIRILL SERGEEVICH
  • NEKLYUDOV DMITRIY YUREVICH