SubjectsSubjects(version: 965)
Course, academic year 2021/2022
  
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 to 2023
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
State of the course: taught
Language: English
Teaching methods: full-time
Level:  
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.
Classification: Economics > Economy
Examination dates   Schedule   
This subject contains the following additional online materials
Course completion requirements -

seminar works, written and oral exam

Last update: Kaiser Jiří (12.09.2023)
Literature -

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

Last update: Botek Marek (20.01.2020)
Syllabus -

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

Last update: Botek Marek (20.01.2020)
 
VŠCHT Praha