SubjectsSubjects(version: 913)
Course, academic year 2022/2023
  
Business Data Processing - AB501026
Title: Business Data Processing
Guaranteed by: Department of Economics and Management (837)
Faculty: Central University Departments of UCT Prague
Actual: from 2021
Semester: both
Points: 6
E-Credits: 6
Examination process:
Hours per week, examination: 2/2, C+Ex [HT]
Capacity: winter:unknown / unknown (unknown)
summer:unknown / unknown (unknown)
Min. number of students: unlimited
Language: English
Teaching methods: full-time
Level:  
For type: Bachelor's
Note: course can be enrolled in outside the study plan
enabled for web enrollment
you can enroll for the course in winter and in summer semester
Guarantor: Kaiser Jiří Ing. Ph.D.
This subject contains the following additional online materials
Annotation
Last update: Scholleová Hana doc. RNDr. Ing. Ph.D. (10.12.2021)
Students will learn data modeling techniques and standards, principles of database implementation in a database system, and querying databases to get the data for decision-making support. This includes data modeling using E-R diagrams, SQL basics, transaction process systems, and management information systems principles, and basic principles of data mining techniques.
Literature -
Last update: Botek Marek Ing. Mgr. Ph.D. (20.01.2020)

R: UNHELKAR, Bhuvan. Software engineering with UML. Boca Raton, [2018]. ISBN 978-1-138-29743-2.

R: Timothy Boronczyk. Jump Start MySQL (1st. ed.). Sitepoint. 2015, ISBN 978-0-9924612-8-7

A: SHERMAN, Rick. Business intelligence guidebook: from data integration to analytics. Amsterdam: Elsevier, Morgan Kaufmann is an imprint of Elsevier, [2015]. ISBN 978-012-4114-616.

A: BHATIA, Parteek. Data mining and data warehousing: principles and practical techniques. Cambridge, United Kingdom: Cambridge University Press, 2019. ISBN 978-1-108-72774-7.

A: MySQL reference manual - http://dev.mysql.com

Syllabus -
Last update: Botek Marek Ing. Mgr. Ph.D. (20.01.2020)

1. Identification of information for specification of requirements on data structure of transaction process systems

2. System states modeling

3. Data modeling using Entity Relationship (E-R) diagram – user preferences modeling

4. Database structure modeling using Entity Relationship (E-R) diagram – platform independent model

5. Database structure modeling using Entity Relationship (E-R) diagram – platform specific model

6. SQL basics for database structure creation (data definition language) a data manipulation in database (data manipulation language)

7. SQL basics for retrieving data from database (data query language) – simple queries

8. SQL basics for retrieving data from database (data query language) – aggregation functions, subselects

9. SQL basics for retrieving data from database (data query language) – joining tables

10. Requirements on management information systems, reporting principles

11. Data structures in management information systems, ETL processes

12. Data mining basics

13. Basic principles of software application development

14. Information security basics

Course completion requirements -
Last update: Kaiser Jiří Ing. Ph.D. (21.09.2020)

seminar works, written exam

 
VŠCHT Praha