University of Warsaw - Central Authentication System
Strona główna

SQL - Database Management

General data

Course ID: 2400-IiE3ZBD1
Erasmus code / ISCED: 14.3 Kod klasyfikacyjny przedmiotu składa się z trzech do pięciu cyfr, przy czym trzy pierwsze oznaczają klasyfikację dziedziny wg. Listy kodów dziedzin obowiązującej w programie Socrates/Erasmus, czwarta (dotąd na ogół 0) – ewentualne uszczegółowienie informacji o dyscyplinie, piąta – stopień zaawansowania przedmiotu ustalony na podstawie roku studiów, dla którego przedmiot jest przeznaczony. / (0311) Economics The ISCED (International Standard Classification of Education) code has been designed by UNESCO.
Course title: SQL - Database Management
Name in Polish: Zarządzanie bazami danych
Organizational unit: Faculty of Economic Sciences
Course groups: (in Polish) Przedmioty obowiązkowe dla III r. studiów licencjackich (IiE, MSEM) - Zarządzanie bazami danych
(in Polish) Przedmioty obowiązkowe dla IIIr. licencjackich Międzykierunkowych Studiów Ekonomiczno-Matematycznych
ECTS credit allocation (and other scores): 3.00 Basic information on ECTS credits allocation principles:
  • the annual hourly workload of the student’s work required to achieve the expected learning outcomes for a given stage is 1500-1800h, corresponding to 60 ECTS;
  • the student’s weekly hourly workload is 45 h;
  • 1 ECTS point corresponds to 25-30 hours of student work needed to achieve the assumed learning outcomes;
  • weekly student workload necessary to achieve the assumed learning outcomes allows to obtain 1.5 ECTS;
  • work required to pass the course, which has been assigned 3 ECTS, constitutes 10% of the semester student load.

view allocation of credits
Language: Polish
Type of course:

obligatory courses

Prerequisites (description):

Elementary knowledge of computer science and databases is expected.

Short description:

The course aims to familiarize students with the creation, modification and management of databases, using SQL language, which is the standard used in databases such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, etc. Participants will become acquainted with the theoretical issues of databases, and with practical issues of database creation, maintenance and management.

Full description:

- 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.

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

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 methods and 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.

Classes in period "Summer semester 2023/24" (in progress)

Time span: 2024-02-19 - 2024-06-16
Selected timetable range:
Navigate to timetable
Type of class:
Seminar, 30 hours more information
Coordinators: Tomasz Jeruzalski
Group instructors: Tomasz Jeruzalski, Igor Rębas
Students list: (inaccessible to you)
Examination: Course - Grading
Seminar - Grading
Course descriptions are protected by copyright.
Copyright by University of Warsaw.
Krakowskie Przedmieście 26/28
00-927 Warszawa
tel: +48 22 55 20 000 https://uw.edu.pl/
contact accessibility statement USOSweb 7.0.3.0 (2024-03-22)