№

Section names

Watch

Total

Lectures

Practically.

1

Overview of SQL Server 2012 and its tools

SQL Server Overview
Using SQL Server Tools
Configuring SQL Server Services

2

2

-

2

Preparing the system for SQL Server 2012 installation

Overview of the SQL Server architecture
Planning server resource requirements
Testing before installing SQL Server

4

2

-

3

Installing and configuring SQL Server 2012

Preparing to install SQL Server
Installing SQL Server
Upgrade to a new version and install automatically

4

2

2

4

Working with databases

Overview of SQL Server databases
Working with files and file groups
Moving database files

4

2

2

5

SQL Server 2012 Recovery Models

Backup strategies
How the SQL Server Transaction Log works
Planning a backup strategy for SQL Server

4

2

2

6

Backup of SQL Server 2012 databases

Backup of databases and transaction logs
Managing database backups
Working with backup settings

4

2

2

7

Restoring SQL Server 2012 databases

Description of the recovery process
Database
Recovery Point-in-time recovery
Restore system databases and individual files

4

2

2

8

Data import and export

Migrating data from / to SQL Server
Importing and exporting table data
Inserting a large amount of data

4

2

2

9

User authentication and authorization

Authentication of SQL Server connections
Authorization of logins when accessing databases
Authorization on multiple servers

4

2

2

10

Assigning server and database roles

Working with server roles
Working with Fixed Database Roles
Creating Custom Database roles

4

2

2

11

User authorization when accessing resources

User authorization when accessing objects
Authorization of users when running the code
Configuring schema-level permissions

4

2

2

12

Audit on SQL Server

Audit of data access on the SQL Server
Implementing audit on SQL Server
Audit management on SQL Server

4

2

2

13

Automating SQL Server 2012 administration tasks

Automating SQL Server Administration
Using the SQL Server Agent service
Managing SQL Server Agent tasks

4

2

2

14

Configuring SQL Server Agent Security

SQL Server Agent Security
Configuring Credentials)
Setting up Proxy accounts (Proxy Account)

4

2

2

15

Monitoring SQL Server using notifications and alerts

Configuring the Database Mail component
SQL Server Error Monitoring
Configuring operators, notifications, and alerts

4

2

2

16

Database maintenance

Data integrity check
Index maintenance
Automation of routine tasks related to database maintenance

4

2

2

17

Topic 18: Monitoring SQL Server 2012

Activity monitoring
Recording and managing performance data
Analysis of the collected performance data

4

2

2

18

Troubleshooting issues related to SQL Server 2012 administration

Methodology for detecting malfunctions in operation
Troubleshooting service-related issues
Troubleshooting issues related to concurrent user experience
Troubleshooting issues related to logins and connections

4

2

2

 TOTAL

72

36

36