Microsoft SQL Server Configuring and MaintenanceLaajuus (3 ECTS)

Objective

After the course, the student has the ability to Configure and maintain a Microsoft SQL Server.

Content

Installing and Configuring SQL Server (10 percent)
Maintaining SQL Server Instances (13 percent)
Managing SQL Server Security (15 percent)
Maintaining a SQL Server Database (16 percent)
Performing Data Management Tasks (14 percent)
Monitoring and Troubleshooting SQL Server (13 percent)
Optimizing SQL Server Performance (10 percent)
Implementing High Availability (9 percent)

Assessment criteria, satisfactory (1)

Installation and configuration of an SQL server
- the student is capable of installing an SQL server
- the student understands what an SQL server instance stands for and he/she is capable of configuring it with the instructor's help.
- the student understands what a database email stands for and he/she is capable of configuring it with the instructor's help;
- the student understands what a full text index stands for and he/she is capable of configuring it with the instructor's help;

The maintenance of SQL server instances
- the student understands what the agents in an SQL server are and he/she is capable of creating and defining tasks for them;
- the student understands what the agent alarms are;
- the student understands the meaning of agent operators and he/she is capable of creating and configuring a new operator;

The security administration of an SQL server
- the student understands the security settings of an SQL server;
- the student knows what login rules and server rules are configured with the instructor's help;
- the student understands what a database scheme stands for and the rules determined in the database;
- the student is capable of configuring the auditioning rules of the SQL server instances;
- the student knows what a transparent encryption of a database stands for and he/she is capable of taking it to use and configuring it.

The database maintenance in an SQL server
- the student is capable of making a database backup and restore in an SQL server with the instructor's help;
- the student understands what the difference between backup types is and he/she is capable of taking them into use with the instructor's help;
- the student understands what kind of benefit the compression of a database gives and he/she is capable of taking it into use.

Accomplishing database maintenance tasks in an SQL server
- the student understands what knowledge import and export from the database mean and he/she is capable of putting them into practice with the instructor's help;
- the student understands the meaning of database indexes and he/she is capable of defining and taking into use an index with the instructor's help.

The monitoring, optimization, error search and high usability of an SQL server
- the student understands what monitoring of a database means and he/she is capable of defining monitoring of a database with the instructor's help;
- the student is capable of optimizing the activity of a database with the instructor's help;
- the student understands what problems are caused by parallelity and he/she is capable of solving them;
- the student understands what kinds of problems may arise in the use of an SQL server and he/she is capable of solving them with the instructor's help;
- the student is capable of carrying out database mirroring with the instructor's help;
- the student is capable of making use of the profiler tool of the SQL server with the instructor's help.

Assessment criteria, good (3)

Installation and configuration of an SQL server
- the student is capable of installing an SQL server
- the student understands what an SQL server instance stands for and he/she is capable of configuring it;
- the student understands what a database email stands for and he/she is capable of configuring it;
- the student understands what a full text index stands for and he/she is capable of configuring it;
- the student creates applicable solutions which are based on independent analysis.

The maintenance of SQL server instances
- the student understands what the agents in an SQL server are and he/she is capable of creating and defining tasks for them;
- the student understands what the agent alarms are;
- the student understands the meaning of agent operators and he/she is capable of creating and configuring a new operator;
- the student creates applicable solutions which are based on independent analysis.

The security administration of an SQL server
- the student understands the security settings of an SQL server;
- the student knows what login rules and server rules are configured;
- the student understands what a database scheme stands for and the rules determined in the database;
- the student is capable of configuring the auditioning rules of the SQL server instances;
- the student knows what a transparent encryption of a database stands for and he/she is capable of taking it to use and configuring it.
- the student creates applicable solutions which are based on independent analysis.

The database maintenance in an SQL server
- the student is capable of making a database backup and restore in an SQL server:
- the student understands what the difference between backup types is and he/she is capable of taking them into use;
- the student understands what kind of benefit the compression of a database gives and he/she is capable of taking it into use;
- the student creates applicable solutions which are based on independent analysis.

Accomplishing database maintenance tasks in an SQL server
- the student understands what knowledge import and export from a database mean and he/she is capable of putting them into practice;
- the student understands the meaning of database indexes and he/she is capable of defining and taking into use an index;
- the student creates applicable solutions which are based on independent analysis.

The monitoring, optimization, error search and high usability of an SQL server
- the student understands what monitoring of a database means and he/she is capable of defining monitoring in a database;
- the student is capable of optimizing the activity of a database;
- the student understands what problems are caused by parallelity and he/she is capable of solving them;
- the student understands what kinds of problems may arise in the use of an SQL server and he/she is capable of solving them;
- the student is capable of carrying out database mirroring with the instructor's help;
- the student is capable of making use of the profiler tool of the SQL server;
- the student creates applicable solutions which are based on independent analysis.

Assessment criteria, excellent (5)

Installation and configuration of an SQL server
- the student is capable of installing an SQL server
- the student understands what an SQL server instance stands for and he/she is capable of configuring it;
- the student understands what a database email stands for and he/she is capable of configuring it;
- the student understands what a full text index stands for and he/she is capable of configuring it;
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.

The maintenance of SQL server instances
- the student understands what the agents in an SQL server are and he/she is capable of creating and defining tasks for them;
- the student understands what the agent alarms are;
- the student understands the meaning of agent operators and he/she is capable of creating and configuring a new operator;
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.

The security administration of an SQL server
- the student understands the security settings of an SQL server;
- the student knows what login rules and server rules are configured;
- the student understands what a database scheme stands for and the rules determined in the database;
- the student is capable of configuring the auditioning rules of the SQL server instances;
- the student knows what a transparent encryption of a database stands for and he/she is capable of taking it to use and configuring it.
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.

The database maintenance in an SQL server
- the student is capable of making a database backup and restore in a SQL server:
- the student understands what the difference between backup types is and he/she is capable of taking them into use;
- the student understands what kind of benefit the compression of a database gives and he/she is capable of taking it into use;
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.

Accomplishing database maintenance tasks in an SQL server
- the student understands what knowledge import and export from the database mean and he/she is capable of putting them into practice;
- the student understands the meaning of database indexes and he/she is capable of defining and taking into use an index;
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.

The monitoring, optimization, error search and high usability of an SQL server
- the student understands what monitoring of a database means and he/she is capable of defining monitoring in a database;
- the student is capable of optimizing the activity of a database;
- the student understands what the problems are caused by parallelity and he/she is capable of solving them;
- the student understands what kinds of problems may arise in the use of an SQL server and he/she is capable of solving them;
- the student is capable of carrying out database mirroring with the instructor's help;
- the student is capable of making use of the profiler tool of the SQL server;
- the student shows applicable solutions which are based on independent analysis and he/she is capable of evaluating critically the solutions and propose possible alternative ways to carry out the solutions.