Performance and Tunning of Database Server (3 ECTS)
Code: TX00FT52-3001
General information
- Enrollment
- 22.04.2024 - 09.05.2024
- Registration for the implementation has ended.
- Timing
- 13.05.2024 - 17.05.2024
- Implementation has ended.
- Number of ECTS credits allocated
- 3 ECTS
- Mode of delivery
- On-campus
- Campus
- Leiritie 1
- Teaching languages
- English
- Seats
- 0 - 30
- Teachers
- Jacek Nazdrowicz
- Course
- TX00FT52
Implementation has 5 reservations. Total duration of reservations is 20 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Mon 13.05.2024 time 09:00 - 13:00 (4 h 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Tue 14.05.2024 time 09:00 - 13:00 (4 h 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Wed 15.05.2024 time 09:00 - 13:00 (4 h 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Thu 16.05.2024 time 09:00 - 13:00 (4 h 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Fri 17.05.2024 time 09:00 - 13:00 (4 h 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
Learning outcomes
These workshops touch on one of the most important areas of IT - databases, in particular optimizing and increasing the efficiency of processing huge amounts of data in them. Although optimization and performance will be discussed using the example of Microsoft SQL Server, these issues mostly occur in other database environments. Knowledge of these issues is important not only from the point of view of database engine administration, but also from the point of view of programmers using database queries.
Content
During the workshops, students, in addition to basic knowledge of databases, SQL, and the SQL server management environment, will learn about the following issues:
- database engine architecture
- tables and index structures
- analysis of SQL query execution plans
- concept and levels of locks when executing SQL queries
- role of the Transaction Log
- statistics
- stored procedures
- performance aspects of the database environment
Prerequisites
Primary knowledge about databases, however this topic will be clarified too.
Evaluation scale
0-5
Assessment criteria, satisfactory (1)
Assessment (in fair, good, and excellent level) - all labs will have some assessement levels (difficulty degree). In case of fair degree, student must complete primary (step-by-step lab guide), in case of good and excellent, there will be different level cases with some questions to answer.
Assessment criteria, good (3)
Assessment (in fair, good, and excellent level) - all labs will have some assessement levels (difficulty degree). In case of fair degree, student must complete primary (step-by-step lab guide), in case of good and excellent, there will be different level cases with some questions to answer.
Assessment criteria, excellent (5)
Assessment (in fair, good, and excellent level) - all labs will have some assessement levels (difficulty degree). In case of fair degree, student must complete primary (step-by-step lab guide), in case of good and excellent, there will be different level cases with some questions to answer.
Assessment criteria, approved/failed
Assessment (in fair, good, and excellent level) - all labs will have some assessement levels (difficulty degree). In case of fair degree, student must complete primary (step-by-step lab guide), in case of good and excellent, there will be different level cases with some questions to answer.