Siirry suoraan sisältöön

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

  • ATX20TV
    Avoin 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