Databases 2600-DSMdz/w3zegBZ
1. Introduction to databases - scope and specificity of database applications
2. Types of databases and database models
3. Creating tables and defining relationships,
4. Data modeling - entity relationship model.
̶ Transformation from conceptual model to relational model.
̶ Normalization of the relational database schema
5. Basics of SQL language
̶ Introduction and syntax of the language - range of applications
̶ Selected SQL language functions (e.g. numeric, character, conditional)
̶ Queries directed to the database - SELECT statement
6. Relational database management systems on the example of MySQL
7. The use of XML as a tool for describing data structure
8. Selected aspects of database security
9. Data warehouse - definitions range of applications
̶ Basics of data warehouse design - conceptual, logical and physical model
̶ Data warehouse as an element of Business Intelligence Systems
̶ Basic OLAP analytical tools
̶ Multidimensional data model and data mining mechanisms (data minning)
10. Database systems as an element of Management Information Systems
11. Construction and use of a simple database on the example of the presentation of the capabilities of MS Access 2019 software
12. Big Data - distributed, diverse data sets
̶ definition and characteristics of Big Data
̶ history and development of Big Data technology
̶ differences between Big Data and traditional databases
̶ rationale and goals of collecting and analyzing data from various sources,
̶ Big Data technologies and tools (Hadoop and Big Data ecosystems, Cloud Computing solutions, programming languages e.g. Python, Spark)
̶ application of Big Data in different scopes,
̶ Big Data challenges (data storage and processing problems and technological and infrastructure constraints
̶ implementation barriers in organizations,
̶ development trends of Big Data concepts
Type of course
Mode
Learning outcomes
Student/Students upon completion of the course:
In terms of knowledge:
● identifies the needs of businesses related to databases (S3 _W02)
● states the application of databases in the activities of organizations in e-business and digital economy (S3_W05)
In terms of skills :
● diagnoses IT and analytical problems related to the use of databases in e-business and their integration into the organization's strategy (S3_U01)
● interprets the impact of the use of databases on the functioning of management in e-business and the digital economy (S3_U02)
● analyzes issues of unusual database problems in teams, presenting them with the help of appropriate information and communication tools (S3_U05)
● develops tasks of increasing complexity, using guidelines and sources discussed in class to improve his/her skills (S3_U08)
In terms of social competence :
● evaluates complex phenomena related to the use of databases in e-business and the digital economy (S3_K01)
● develops entrepreneurial solutions for effective use of databases on presented case studies (S3_K04)
● promotes the maintenance of ethical standards in the use of databases (S3_K05)
Assessment criteria
Learning outcomes will be verified in the form of a test conducted during the last class in the lecture hall.
The test will be conducted stationary using the e-learning platform. In justified cases, a traditional paper version of the test will also be possible.
A total of 20 points will be available during the test, the number of which will determine the final grade:
0 - 10 points - grade 2
11 - 12 points - grade 3
13 - 14 points - grade 3.5
15 - 16 points - grade 4
17 - 18 points - grade 4.5
19 - 20 points - grade 5
Bibliography
Basic literature :
1. Chodkowska-Gyurics A., Hurtownie danych. Teoria i praktyka, Helion 2022
2. Hernandez J., Projektowanie baz danych dla każdego. Przewodnik krok po kroku, Helion 2022
3. Elmasri R., Navathe S., Wprowadzenie do systemów baz danych, Helion, 2019
4. Rockoff L., Język SQL. Przyjazny podręcznik. Wydanie III (ebook), Helion, 2022
5. Ullman J.D., Windom J., Podstawowy kurs systemów baz danych, Helion, Warszawa wa, 2011
Additional literature :
1. Alexander M., Kusleika R., Access 2019 PL. Biblia. Helion, 2023
2. Banaszak Z., Kłos S., Mleczko J., Zintegrowane systemy zarządzania, PWE, 2016
3. Kisielnicki J., MIS systemy informatyczne zarządzania, Placet, Warszawa 2008
4. Surma J., Business Inteligence, PWN, 2021
5. Stephenson D., Big data, nauka o danych i AI bez tajemnic, Helion, 2019.
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: