Database Administration

Major: Software Engineering
Code of subject: 6.121.03.E.066
Credits: 7.00
Department: Software
Lecturer: Tushnytskyy Ruslan Bogdanovych
Semester: 8 семестр
Mode of study: денна
Learning outcomes: As a result of studying the discipline, the student must be able to demonstrate the following learning outcomes: 1. install and configure MS SQL Server 2008+; 2. to exchange data; 3. organize data backup and recovery; 4. ensure data integrity; 5. automate administrative tasks; 6. manage the security of the server and databases; 7. replicate data between instances of MS SQL Server; 8. ensure high availability of the system; 9. manage transactions and locks; 10. monitor the performance and optimization of MS SQL Server.
Required prior and related subjects: Previous disciplines Databases Related and subsequent disciplines Data extraction and processing
Summary of the subject: Installation and initial settings of MS SQL Server 2008+ • Preparation for installation • Installing SQL Server 2008+ • Server settings Database management • Database planning • Creating databases • Policy-based management Data recovery • Development of a backup strategy • Backup custom databases • Recover custom databases • Online data recovery • Data recovery based on snapshots of databases • System database recovery Security management • SQL Server 2008+ Security Overview • Ensuring server-level reliability • Ensuring the reliability of the database level • Security audit Data exchange • Overview of data import / export technology and tools • SQL Server Integration Service Automation of administrative tasks • Automation of MS SQL Server 2008+ maintenance • MS SQL Server Agent Service • Development of a database maintenance plan • Create and process notifications • Centralized maintenance of a group of servers • SQL Server Agent security Database replication • Familiarity with database replication technology • Creating publications and subscriptions • Standard replication scenarios Ensuring high availability of databases • Delivery of transaction logs • Database mirroring • Database server clusters • Standard scenarios for ensuring data availability SQL Server monitoring • Using the Current Activity utility • Tracing with SQL Server Profiler • Use of DDL triggers • Using Event Notification Work optimization • Error detection • Productivity optimization • Using the Resource Governor • Using the Data Collector
Assessment methods and criteria: Methods of diagnostics of knowledge: oral examination, homework, examination work. Criteria for evaluating student learning outcomes: The maximum score is 100 Current control: 44 laboratory work 44 Examination control: 56 written component (full-time form) 44 oral component (ocular form) 12 written component (remote form) 56 oral component (remote form) 0
Recommended books: 1. Administration of databases: a synopsis of lectures for students of the basic direction "Software Engineering". - Lviv: Lviv Polytechnic National University Publishing House, 2016. - 90 p. 2. Carpenter Tom. Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463). - Sybex. - 2013. - 936 p. 3. Victor Isakov, Paul Marquardt. MCSA SQL 2016 Database Administration Exam Ref 2-pack: Exam Refs 70-764 and 70-765. - Microsoft Press. - 2017. - 720 p. 4. William Assaf, Randolph West. SQL Server 2017 Administration Inside Out / Microsoft Press. - 2018. - 704 p.