University of Warsaw - Central Authentication System

Databases Reporting

General data

Course ID:	2400-ZU1INF02
Erasmus code / ISCED:	14.3 The subject classification code consists of three to five digits, where the first three represent the classification of the discipline according to the Discipline code list applicable to the Socrates/Erasmus program, the fourth (usually 0) - possible further specification of discipline information, the fifth - the degree of subject determined based on the year of study for which the subject is intended. / (0311) Economics The ISCED (International Standard Classification of Education) code has been designed by UNESCO.
Course title:	Databases Reporting
Name in Polish:	Raportowanie z baz danych
Organizational unit:	Faculty of Economic Sciences
Course groups:	Information Technology - Modules. I-year extramural students
ECTS credit allocation (and other scores):	2.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
Short description:	The course aims to familiarize participants with the basic methods of reporting information from databases. Standard, in which participants will "pull" data for most databases, is used both in companies and institutions. Activities will be held based on a sample database in ACCESS
Full description:	Topic 1 Basic concepts of databases, definitions, issues related to the database. Starting the reports editor. Topic 2 Selecting the information from the database. Topic 3 Sorting and filtering data, selecting queries. Conditional selection of data. Using relational operators. Topic 4 Selecting data using ranges. Eliminating data duplicates. Topic 5 Functions of aggregation for analyzing the data group. Topic 6 Data grouping and its use. Combining information from several data tables.
Bibliography:	Required readings: - P.Beynon_Davies, "Systemy baz danych", Wydawnictwo Naukowo-Techniczne, Warszawa, 2003 - Ben Forta, Poznaj SQL w 10 minut, Intersoftland, Warszawa 2000 Suggested readings: Adam Majczak, SQL od podstaw, wyd. I, Translator s.c., Warszawa 2001 - 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
Learning outcomes:	After the course the student is able to: - present knowledge of database management, - 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, - interpret the databases queries. SU05, SU06, SK01, SK03, SU04, SU03, SU02, SU01, SW03, SW02, SW01, SW04, SW05, SK02, SK04
Assessment methods and assessment criteria:	In order to complete courses, students will send their solving results through e-learning platform. The correct solution allows to pass the course. Participants who wish to obtain a higher grade can take the assessment test, its date will be determined at the end of the course. The test will be held at the Faculty of Economic Sciences at the computers on the base of conducted activities.

Classes in period "Winter semester 2024/25" (past)

Time span:	2024-10-01 - 2025-01-26	Selected timetable range: weekly course term Go to timetable MO TU W TH FR SA KON SU KON
Type of class:	Seminar, 12 hours more information
Coordinators:	Tomasz Jeruzalski
Group instructors:	Tomasz Jeruzalski
Students list:	(inaccessible to you)
Credit:	Course - Grading Seminar - Grading

Course descriptions are protected by copyright.
Copyright by University of Warsaw.