University of Warsaw - Central Authentication System

ADVANCED DATABASES

General data

Course ID:	2400-M2IiEZBD
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:	ADVANCED DATABASES
Name in Polish:	Zaawansowane bazy danych
Organizational unit:	Faculty of Economic Sciences
Course groups:	(in Polish) Przedmioty kierunkowe (obowiązkowe) do wyboru - studia II stopnia IE - grupa 2 (3*30h)
ECTS credit allocation (and other scores):	4.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.
Language:	Polish
Type of course:	obligatory courses
Short description:	The aim of the course is to familiarize participants with the advanced level of database modification and management using the SQL language, which is a standard used in databases such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, etc. Particular attention will be paid to SQL queries in the database like MS SQL Server.
Full description:	The aim of the course is to familiarize participants with the advanced level of database modification and management using the SQL language, which is a standard used in databases such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, etc. Students will get acquainted with the practical problems of reporting information from databases. They will learn, among others: how to use advanced T-SQL functions - Create queries that integrate data from different tables - Create summaries that requires elementary data transformations - Create complex indicators from raw / elemental data - Use complex queries to create advanced reports and analyzes - Write, optimize and improve existing queries - Describe the architecture of typical relational databases with an understanding of the logic and implications of such a schema Particular attention will be paid to SQL queries in the database like MS SQL Server.
Bibliography:	Itzik Ben-Gan, Dejan Sarka, Adam Machaniec, Kevin Farlee, Zapytania w języku T-SQL w Microsoft SQL Server 2014 i SQL Server 2012 APN Promise, Warszawa 2015 Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Ka Mentors, Microsoft SQL Server 2008 od Środka. Zapytania w Języku T-SQL, APN Promise, Warszawa 2009 Bill Karwin, Antywzorce języka SQL. Jak unikać pułapek podczas programowania baz danych. Helion, Warszawa 2011 Adam Jorgensen, Bradley Ball, Steven Wort, Ross LaForte, Brian Knight, SQL Server 2014, Podręcznik administratora, Helion, Warszawa 2015
Learning outcomes:	- After the course the student is able to: - present knowledge of database management, - describe architecture of typical relational databases and understand the logic and implication of such design - modify and manage databases using SQL language, - create proper and efficient queries with clear documentation - use advanced T-SQL functions, - create and modify the structure of queries to database, - describe, optimize and improve existing queries, - integrate queries into coherent analytical queries, - create queries integrating data from multiple tables, - assess the correctness of the queries in SQL (Structured Query Language), - interpret the databases queries, - create summaries/aggregates requiring advanced data transformations, - create complex indicators based on raw/elementary data, - use complex queries to create advance reports and analytics KW01, KW02, KW03, KU01, KU02, KU03, KK01, KK02, KK03
Assessment methods and assessment criteria:	Assessment is based on two tests: the first one - preliminary, for which one can get 20% points of the final evaluation grade, it will take place in the middle of the term, the second one - final, for which one can get 80% points of the final evaluation grade, it will take place during lasr classes. Tests will take place at the computers and will prove the knowledge of problems and issues discussed and addressed during the classes

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

Time span:	2024-02-19 - 2024-06-16	Selected timetable range: weekly course term Navigate to timetable MO TU W KON KON KON TH FR
Type of class:	Seminar, 30 hours more information
Coordinators:	Tomasz Jeruzalski
Group instructors:	Tomasz Jeruzalski, Marek Kolano, Marta Pędzik
Students list:	(inaccessible to you)
Examination:	Course - Examination Seminar - Examination

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