SQL - Database Management
General data
Course ID: | 2400-IiE3ZBD1 |
Erasmus code / ISCED: |
14.3
|
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
|
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 |
Navigate to timetable
MO KON
KON
KON
TU W TH FR |
Type of class: |
Seminar, 30 hours
|
|
Coordinators: | Tomasz Jeruzalski | |
Group instructors: | Tomasz Jeruzalski, Igor Rębas | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
Grading
Seminar - Grading |
Copyright by University of Warsaw.