SQL - Database Management 2400-IiE3ZBD1
- Databases. Database management systems in an economic organization.
Database - basic concepts. Evolution of database systems.
- Operational and analytical use of databases. The architecture of a database management system (DBMS) - diagrams. Organization of equipment, and users.
- Information systems based on databases and their evolution.
Data models - definition and types, database properties.
-Issues related to database: indirection (mapping), data collection, data types, constants, variables, functions, conditions, selection, projection, combining, organizing, sharing.
- Logical database models: hierarchical, network, relational, object.
Diagrams of entity relationship models (entities, attributes, relationships), the relationships' properties.
Database development trends.
- Relational database design process. Defining relationship characteristics.
Entity relationship model. Implementation models.
Basic actions in relational algebra. Relational model.
Normalization of relational data model.
- Defining a relational database schema, relationships and prospects.
- Updating operations.
- SQL queries: simple, with nested units, with connectors.
- Physical database organization.
- Addressing, searching, indexing. Management of transactions and queries.
Data security. Database design process: modeling.
- Data warehouse - definitions, characteristics, functions, architecture.
- Multi-dimensional analysis of the data warehouse. ROLAP and MOLAP models, OLAP cubes, tables, tables of facts and tables of dimensions. Data aggregation, levels of aggregation, multi-level drill data (drill down, drill through) - "from general to specific" approach - technique of going from the most synthetic data to increasingly detailed data. ETL tools (cleaning, data integration, and load), query and analysis tools, data warehouse administration tools.
Type of course
Prerequisites (description)
Course coordinators
Learning outcomes
After the course the student is able to:
- present knowledge of database management,
- distinguish between multi-dimensional structure of the database,
- describe the analytical and operational models of databases,
- create, modify and manage databases using SQL language,
- analyze patterns of relational databases,
- create and modify the structure of queries to database,
- integrate queries into coherent analytical queries,
- assess the correctness of the queries in SQL (Structured Query Language),
- interpret the databases queries.
KW01, KW02, KW03, KU01, KU02, KW03, KK01, KK02, KK03
Assessment criteria
Assessment is based on two tests:
I preliminary, for which one can get 20% points of the final evaluation grade, it will take place in the middle of term.
II final, for which one can get 80% points of the final evaluation grade, it will take place on our last class.
Tests will take place at the computers on the base of conducted activities.
Bibliography
- P.Beynon_Davies, "Systemy baz danych", Wydawnictwo Naukowo-Techniczne, Warszawa, 2003
- Richard Stones, Neil Matthew, Bazy Danych i MySQL, Helion, Gliwice 2003
- Microsoft SQL Server 2005 od środka: Mechanizm składowania danych, APN Promise, Warszawa 2007
- Microsoft SQL Server 2005 od środka: Zapytania w języku T-SQL, APN Promise, Warszawa 2006 Ewa Łuszczyk, Mirosława Koperkowska, Ćwiczenia z Access 2003 - wersja polska, wyd. Mikom, Warszawa 2004
- Ben Forta, Poznaj SQL w 10 minut, Intersoftland, Warszawa 2000
- Adam Majczak, SQL od podstaw, wyd. I, Translator s.c., Warszawa 2001
- Stones Richard, Matthew Neil, Bazy danych i MySQL, Helion, Gliwice 2003
- Prague, Cary N., Access 2003 PL: biblia, Helion, Gliwice 2004
- Vidette Poe, Patricka Klauer, Stephen Brobst - Tworzenie hurtowni danych, WNT, Warszawa 1999 - Chris Todman – Projektowanie hurtowni danych, WNT, Warszawa 2003 - Inmon W.H. Building the Data Warehouse, Third Edition
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: