ADVANCED DATABASES 2400-M2IiEZBD
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.
Type of course
Course coordinators
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 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
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
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: