Bachelor
2021/2022
Data Management
Type:
Compulsory course
Area of studies:
Business Informatics
Delivered by:
Bachelor's Programme in Digital Product Management
Where:
Graduate School of Business
When:
2 year, 1, 2 module
Mode of studies:
offline
Open to:
students of one campus
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
- 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
- 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
Interim Assessment
- 2021/2022 2nd module0.2 * Exam + 0.25 * Practice + 0.1 * Quiz on lecture + 0.25 * Team project + 0.2 * Test
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