| Course title | - |
|---|---|
| Course code | KI/K204 |
| Organizational form of instruction | Seminary |
| Level of course | Master |
| Year of study | not specified |
| Semester | Winter and summer |
| Number of ECTS credits | 2 |
| Language of instruction | Czech |
| Status of course | Compulsory-optional |
| Form of instruction | Face-to-face |
| Work placements | This is not an internship |
| Recommended optional programme components | None |
| Lecturer(s) |
|---|
|
| Course content |
|
1. Data storing (file types, filegroups and partitioning, physical structure of data file, introduction to indexes) 2. Rowstore indexes (clustered vs non-clustered indexes, optimization examples) 3. Columnstore indexes (benefits of columnstore indexes and use in data warehouses, optimization examples) 4. Concurrent processing (transactions, locks/deadlocks, isolation levels) 5. Optimization (execution plans, query optimization, sniffing parameter) 6. Administration (best practice, physical location of databases, backup, fragmentation and maintenance of indexes, maintenance of statistics) 7. Security at the server and database level (SQL logins, database users, roles, auditing, SQL Server hacking) 8. SQL Server Monitoring (profiler, extended events, custom solution, query store) 9. SQL Server Agent (creation of scheduled jobs, job types, proxies) 10. In-memory OLTP (advantages and disadvantages, practical demonstration of deployment, performance comparison)
|
| Learning activities and teaching methods |
| unspecified |
| Learning outcomes |
|
The course is focused on acquiring theoretical knowledge and especially practical skills in working with Microsoft SQL Server.
|
| Prerequisites |
|
unspecified
|
| Assessment methods and criteria |
|
unspecified
seminar work |
| Recommended literature |
|
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester |
|---|