Management of Enterprise Information - SQL

  • Credits: 3
  • Ending: Examination
  • Range: 2C
  • Semester: summer
  • Year: 2
  • Faculty of Business Management

Teachers

Included in study programs

General Management

Teaching results

Knowledge:
• Comprehensive knowledge and skills in the field of information management and information governance, relational database management and data analysis through SQL, which are a prerequisite for preparing the basis for managerial decision-making and qualified answers to questions based on the business problem.
Competence:
• be oriented in the issues of information management and information governance,
• to know the environment of database platforms, to understand the structure and objects of databases, to understand data and its data types and properties,
• competently decide on the use of basic and advanced SQL queries to retrieve information from enterprise databases for the purpose of managerial decision making.
Skill:
• install and implement the selected database platform (server and client part),
• to know how to work with basic objects of the selected database platform (e.g. MS SQL Server), which will create prerequisites for working in the environment of other database platforms (e.g. MySQL),
• design and create an enterprise database, import and export data to/from the database,
• formulate specific decision problems and use SQL analytical queries to obtain data and information to solve them,
• understand basic security measures for the database.

Indicative content

Thematic definition of exercises:
1. Enterprise Information Management.
2. Relational database management.
3. Relational database system.
4. Database design.
5. Querying.
6. Aggregation and logical functions.
7. Case study.
8. Analysis of data from CRM database using SQL.
9. Embedded querying. Subqueries, embedded queries.
10. OLAP analysis. Transforming an OLTP database into an OLAP database.
11. Comprehensive case study from enterprise practice. Formulation of business problem and research questions. Analysis of data from the specified enterprise database.
12. Inquiry. Use of SQL statements. Creating reports and outputs.
13. Interpretation of analysis results.

Support literature

Basic literature:
1. DOUCEK, Petr - MARYŠKA Miloš - NEDOMOVÁ Lea a kol. Informační manažment v informační společnosti. Praha : Professional Publishing, 2013. 264 s. ISBN 978-80-7431-097-3.
2. MATIAŠKO, Karol - KVET, Michal - KVET, Marek. Databázové systémy - 1. diel. Žilina : EDIS, 2018. 440 s. ISBN 9788055414881.
3. LAURENČÍK, Marek. SQL. Podrobný průvodce užívatele. Praha : Grada Publishing, 2018. 216 s. ISBN 9788027107742.
4. POUR Jan - MARYŠKA Miloš - STANOVSKÁ Iva - ŠEDIVÁ Zuzana. Self Service Business Intelligence. Praha : Grada Publishing, 2018. 352 s. ISBN 978-80-271-0616-5.
5. GEMIGNANI, Zach - GALENTINO, Richard - SCHUERMANN, Patrick - GEMIGNANI Chris. Efektivní analýza a využití dat. Praha : Computer Press, 2015. 240 s. ISBN 978802514571.
Supplementary literature:
1. VALENTA, Michal. Databázové systémy. 2. přepracované vydání. Praha : ČVUT, 2020, 294 s. ISBN 9788001066966.
2. FORTA, Ben. SQL in 10 Minutes a Day. Indianapolis : Sams, 2020. 306 s. ISBN 9780135182796.
3. VIESCAS, John. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL. Boston : Addison-Wesley, 2018. 960 s. ISBN 0134858333.
4. NIELD, Thomas. Getting Started with SQL: A Hands-on Approach for Beginners. Newton : O'Reilly Media, Inc., 2016. 134 s. ISBN 978-1491938614.
5. SHIELDS, Walter. SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL. ClydeBank Media LLC. 2019. 251 s. ISBN 978-1945051753.
6. TAYLOR, Allen G. SQL All-In-One. For Dummies, 3rd Edition. Hoboken : John Wiley and Sons, 2019. 768 s. ISBN 978-1119569619.
7. DEBARROS, Anthony. Practical SQL: A Beginner's Guide to Storytelling with Data. Cheltenham : William Pollock, 2018. 392 s. ISBN 978-1593278274.

Syllabus

Thematic definition of exercises: 1. Enterprise Information Management. Enterprise data and information Governance. Status and role of data and information in information management. Development, objectives and means of information management. Information management models. Benefits of information management for enterprises. 2. Relational database management. Concept of RDBMS. Standard tool for user access to databases - SQL language. Possibilities and reasons for using SQL language - usability, ease of use, security. SQL concepts. 3. Relational database system. MS SQL Server Installation, user environment and tools MS SQL Server Express (server part). Installation, user environment and tools SQL Server Management Studio (client part). Database objects. Database diagrams. Database and data security. 4. Database design. A case study with a focus on solving a specific business problem. Defining the problem. Comprehensive database design, data import and subsequent database modification options. 5. Querying. Selection and action queries - creating queries, applying a wide range of arguments and operators to specify query criteria. Demonstration of the use of queries in solving a business problem. 6. Aggregation and logical functions. Applying aggregation and logical functions to the creation of queries and new arrays. Demonstration of the use of aggregation and logical functions in solving an enterprise problem. 7. Case study. Import of enterprise database. Creating and calculating new fields. Applying aggregation, text and logical functions. Formatting values. Creating queries. Creating output overwies and reports. 8. Analysis of data from CRM database using SQL. Applying aggregation and analysis tools, interpreting results. 9. Embedded querying. Subqueries, embedded queries. Types of subqueries - subqueries located in the list of columns, subqueries located in place of the table name, subqueries as part of criteria. 10. OLAP analysis. Transforming an OLTP database into an OLAP database. Use of transformation script in SQL language. Creation of data cubes. Analysis of data from data cubes. Export. Creation of graphical outputs. 11. The comprehensive case study from business practice. Formulation of a business problem and research questions. Analysis of data from a specified enterprise database. Inquiry. Use of SQL statements. Creation of reports and outputs. Interpretation of analysis results.

Requirements to complete the course

30 % written work, 70 % written exam

Student workload

78 h (attendance at exercises 26 h, preparation for exercises 26 h, preparation for continuous written work 10 h, preparation for the exam 18 h)

Language whose command is required to complete the course

Slovak

Date of approval: 09.02.2023

Date of the latest change: 14.05.2022