Working with databases
| Type of study | Bachelor |
|---|---|
| Language of instruction | Czech |
| Code | 342-6516/03 |
| Abbreviation | PsD |
| Course title | Working with databases |
| Credits | 3 |
| Coordinating department | Institute of Transport |
| Course coordinator | Ing. Jaromír Široký, Ph.D. |
Subject syllabus
Lectures:
1 Basic concepts of data processing
2 Procedure for designing a data collection system
3 Database architecture.
4 Data models in database systems.
5 Basic concepts of relational algebra.
6 Query languages in database systems.
7 Relational database systems
8 Data modeling and design of data structures. Normalization of relations.
9 Use of DFD
10 Normalization of structures
11 ERD modeling
12 Applications of database systems
13 Reserve - defense of the project
Exercises:
Excel
1 tables and their use
2 pivot tables
3 database formulas
4 basic properties and use
Access
5 Properties and use, object classes
6-7 Creating tables in design view
8-9 Queries in design view
10 Built-in SQL functions and views.
11 Forms and reports.
12 Creating a database application in MS Access.
13 Seminar project
1 Basic concepts of data processing
2 Procedure for designing a data collection system
3 Database architecture.
4 Data models in database systems.
5 Basic concepts of relational algebra.
6 Query languages in database systems.
7 Relational database systems
8 Data modeling and design of data structures. Normalization of relations.
9 Use of DFD
10 Normalization of structures
11 ERD modeling
12 Applications of database systems
13 Reserve - defense of the project
Exercises:
Excel
1 tables and their use
2 pivot tables
3 database formulas
4 basic properties and use
Access
5 Properties and use, object classes
6-7 Creating tables in design view
8-9 Queries in design view
10 Built-in SQL functions and views.
11 Forms and reports.
12 Creating a database application in MS Access.
13 Seminar project
E-learning
lms.vsb.cz
Literature
KLEPPMANN, Martin. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. Sebastopol: O'Reilly Media, 2017. 616 s. ISBN 978-1449373320.
Advised literature
CORONEL, Carlos a Steven MORRIS. Database Systems: Design, Implementation, and Management. 13th edition. Boston: Cengage Learning, 2018. 816 s. ISBN 978-1337627900
KLEPPMANN, Martin. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. Sebastopol: O'Reilly Media, 2017. 616 s. ISBN 978-1449373320.
WINSTON, Wayne L. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). 7th edition. Redmond: Microsoft Press, 2021. ISBN 978-0137613663
KLEPPMANN, Martin. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. Sebastopol: O'Reilly Media, 2017. 616 s. ISBN 978-1449373320.
WINSTON, Wayne L. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). 7th edition. Redmond: Microsoft Press, 2021. ISBN 978-0137613663