Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

Business Data Processing - AB501026

Title:	Business Data Processing
Form of teaching:	lecture+practicals
Guaranteed by:	Department of Economics and Management (837)
Faculty:	Central University Departments of UCT Prague
Actual:	from 2025
Duration in semesters:	1
Semester:	summer
Points:	summer s.:6
E-Credits:	summer s.:6
Examination process:	summer s.:
Hours per week, examination:	summer s.:2/2, C+Ex [HT]
Capacity:	unknown / unknown (unknown)
Maximum number of enrolled students:	unlimited
Min. number of students:	unlimited
State of the course:	taught
Language:	English
Teaching methods:	full-time
Level:
Repeated enrollment:	- / - / - / 9
Note:	course can be enrolled in outside the study plan enabled for web enrollment

Guarantor:	Kaiser Jiří Ing. Ph.D.
Classification:	Economics > Economy

Examination dates Schedule

This subject contains the following additional online materials

E-learning course

Annotation

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.

Last update: Scholleová Hana (10.12.2021)

Course completion requirements -

seminar works, written and oral exam

Last update: Kaiser Jiří (12.09.2023)

Literature

Obligatory:

Silva, R.. MySQL crash course : a hands-on introduction to database development.. San Francisco, CA: No Starch Press, Inc., 2023, s. ISBN 978-1718503007.

MySQL 8.0 Reference Manual [online]. Dostupné z: https://dev.mysql.com/doc/refman/8.0/en/sql-statements.html

Yüksek, A. G., & Kaynar, O.. Information Technologies in Managerial Decision-Making Foundations and Application. Lyon, Francie: Livre de Lyon, 2025, s. ISBN 978-2-38236-979-1.

Recommended:

Joel Murach. Murach's MySQL. Fresno, Kalifornie, USA: Mike Murach & Associates, 2023, s. ISBN 978-1943873104.

Last update: Kaiser Jiří (10.09.2026)

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)

Teaching methods
	Activity	Credits	Hours
	Účast na přednáškách	1	28
	Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi	1	28
	Práce na individuálním projektu	2	56
	Příprava na zkoušku a její absolvování	1	28
	Účast na seminářích	1	28
		6 / 6	168 / 168