SQL-palvelimen tietokannan infrastruktuurin ylläpito (6 cr)
Code: TT00DD02-3004
General information
Enrollment
23.08.2017
Timing
01.01.2020 - 31.12.2020
Number of ECTS credits allocated
6 op
Virtual portion
6 op
Mode of delivery
Distance learning
Unit
ICT ja tuotantotalous
Campus
Karaportti 2
Teaching languages
- English
Seats
0 - 99
Degree programmes
- Tieto- ja viestintätekniikan tutkinto-ohjelma
Teachers
- Virve Prami
Groups
-
ATX20TVAvoin amk - NonStop vuosi 2020
Objective
After taking Administering a SQL Database Infrastructure course, which prepares for 70-764 certification, student knows how-to configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, manage high availability and disaster recovery.
Content
- Data Access and Auditing
- Manage Backup and Restore Database;
- Manage and Monitor SQL Server instances
- Manage High Availability
Materials
N/A
Teaching methods
Online (Self-Study) course in Moodle environment
Employer connections
N/A
Exam schedules
Up to Student
International connections
N/A
Completion alternatives
N/A
Student workload
Up to Student
Content scheduling
Up to Student
Evaluation scale
Hyväksytty/Hylätty
Assessment criteria, satisfactory (1)
Student knows how-to configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, manage high availability and disaster recovery.with help from senior colleague.
Assessment criteria, good (3)
Student knows how-to configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, manage high availability and disaster recovery with good level and work independently.
Assessment criteria, excellent (5)
Student knows how-to configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, manage high availability and disaster recovery with excellent level and work independently. He/She also has ability to participate 70-764 certification exam.
Assessment criteria, approved/failed
Pass/Fail
Further information
Grading: Pass/Fail