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
Guaranteed by:	Department of Economics and Management (837)
Faculty:	Central University Departments of UCT Prague
Actual:	from 2024
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)
Min. number of students:	unlimited
State of the course:	taught
Language:	English
Teaching methods:	full-time
Teaching methods:	full-time
Level:
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

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 -

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)

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