| Course title | Microsoft SQL Server |
|---|---|
| Course code | KI/0204 |
| Organizational form of instruction | Seminary |
| Level of course | Bachelor |
| 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. Introduction to MS SQL Server (installation, configuration, SQL services, SSMS) 2. Data storing (file types, filegroups and partitioning, physical structure of data file, introduction to indexes) 3. Rowstore indexes (clustered vs non-clustered indexes, optimization examples) 4. Columnstore indexes (benefits of columnstore indexes and use in data warehouses, optimization examples) 5. T-SQL (SELECT, VIEW, UDF, PROCEDURE, TRIGGER, Error Handling) 6. Transactions (locks / deadlocks, isolation levels) 7. Optimization (execution plans, query optimization, sniffing parameter) 8. Administration (best practice, physical location of databases, backup, fragmentation and maintenance of indexes, maintenance of statistics) 9. Security at the server and database level (SQL logins, database users, roles, auditing, SQL Server hacking) 10. SQL Server Monitoring (profiler, extended events, custom solution, query store) 11. SQL Server Agent (creation of scheduled jobs, job types, proxies) 12. In-memory OLTP (advantages and disadvantages, practical demonstration of deployment, performance comparison) 13. BI solutions built on Microsoft products (SSIS, SSAS, SSRS / Power BI)
|
| 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. The SQL Server Integration Services, SQL Server Analysis Services and Power BI tools will also be introduced in the course.
|
| Prerequisites |
|
unspecified
|
| Assessment methods and criteria |
|
unspecified
Active participation in lessons, solving the assigned practical tasks |
| Recommended literature |
|
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
|---|---|---|---|---|
| Faculty: Faculty of Science | Study plan (Version): Information Sciences (double subject) (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |
| Faculty: Faculty of Science | Study plan (Version): - (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |
| Faculty: Faculty of Science | Study plan (Version): Information Sciences (double subject) (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |
| Faculty: Faculty of Science | Study plan (Version): Information Systems (A14) | Category: Informatics courses | - | Recommended year of study:-, Recommended semester: - |