Siirry suoraan sisältöön

SQL-palvelimen tietokannan infrastruktuurin ylläpito (6 cr)

Code: TT00DD02-3006

General information


Timing

15.03.2021 - 31.12.2023

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 - 500

Degree programmes

  • Tieto- ja viestintätekniikan tutkinto-ohjelma

Teachers

  • Virve Prami

Teacher in charge

Janne Salonen

Groups

  • CareerBoost_TXK_21
    Career Boost 21 (Tivi)
  • CareerBoost_TXK_22
    Career Boost 22 (TiVi)

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

Location and time

Up to Student her-/himself.

Materials

Online

Teaching methods

100% online (Self-Study) course.

Employer connections

N/A

Exam schedules

Up to Student her-/himself.

International connections

N/A

Completion alternatives

N/A

Student workload

Up to Student her-/himself.

Content scheduling

Up to Student her-/himself.

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