+7 (727) 292-54-80    |    г.Алматы, ул.Байтурсынулы, 126/1 корпус А-325

KZ / RU / EN

Курс "Microsoft SQL Server Database Administration"

1.1.

Microsoft SQL Server Database Administration

 

Dates of the event - by agreement

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

Оцените, пожалуйста, курс!

Преподаватели курса


Фотографии с занятий


Есть вопросы о курсе? Задайте их в этой форме!









ЗАЯВКА НА КУРС

Пожалуйста, оставьте свои данные, мы вам обязательно перезвоним!


Количество слушателей