Performance and Tunning of Database Server (3 op)
Toteutuksen tunnus: TX00FT52-3001
Toteutuksen perustiedot
- Ilmoittautumisaika
- 22.04.2024 - 09.05.2024
- Ilmoittautuminen toteutukselle on päättynyt.
- Ajoitus
- 13.05.2024 - 17.05.2024
- Toteutus on päättynyt.
- Opintopistemäärä
- 3 op
- Toteutustapa
- Lähiopetus
- Toimipiste
- Leiritie 1
- Opetuskielet
- englanti
- Paikat
- 0 - 30
- Opettajat
- Jacek Nazdrowicz
- Opintojakso
- TX00FT52
Toteutuksella on 5 opetustapahtumaa joiden yhteenlaskettu kesto on 20 t 0 min.
| Aika | Aihe | Tila |
|---|---|---|
|
Ma 13.05.2024 klo 09:00 - 13:00 (4 t 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Ti 14.05.2024 klo 09:00 - 13:00 (4 t 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Ke 15.05.2024 klo 09:00 - 13:00 (4 t 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
To 16.05.2024 klo 09:00 - 13:00 (4 t 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
|
Pe 17.05.2024 klo 09:00 - 13:00 (4 t 0 min) |
Performance and Tunning of Database Server TX00FT52-3001 |
MMA123
Oppimistila
|
Tavoitteet
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.
Sisältö
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
Esitietovaatimukset
Primary knowledge about databases, however this topic will be clarified too.
Arviointiasteikko
0-5
Arviointikriteerit arvosanalle 1 tyydyttävä
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.
Arviointikriteerit arvosanalle 3 hyvä
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.
Arviointikriteerit arvosanalle 5 kiitettävä
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.
Arviointikriteerit arvosanalle hyväksytty
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.