This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

  Training schedule for "Administering a SQL Database Infrastructure - Course 20764-C Course"

September
2024
21
Sat
22
Sun
23
Mon
One to One - Online
09:00-17:00 (EST)
AT7776V242651
1,640 $
30 September 2024 - 3 Oct
One to One - Online
09:00-17:00 (EST)
AT7776V242741
1,640 $
October
2024
5
Sat
6
Sun
7
Mon
One to One - Online
09:00-17:00 (EST)
AT7776V242791
1,640 $
October
2024
14
Mon
15
Tue
16
Wed
One to One - Online
09:00-17:00 (EST)
AT7776V242881
1,640 $
1,150 $
Early bird discount
October
2024
19
Sat
20
Sun
21
Mon
One to One - Online
09:00-17:00 (EST)
AT7776V242931
1,640 $
1,150 $
Early bird discount
October
2024
28
Mon
29
Tue
30
Wed
One to One - Online
09:00-17:00 (EST)
AT7776V243021
1,640 $
1,150 $
Early bird discount
November
2024
2
Sat
3
Sun
4
Mon
One to One - Online
09:00-17:00 (EST)
AT7776V243071
1,640 $
1,150 $
Early bird discount
November
2024
11
Mon
12
Tue
13
Wed
One to One - Online
09:00-17:00 (EST)
AT7776V243161
1,640 $
1,150 $
Early bird discount
November
2024
16
Sat
17
Sun
18
Mon
One to One - Online
09:00-17:00 (EST)
AT7776V243211
1,640 $
1,150 $
Early bird discount

Who Should Attend

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Course Content

  • Module 1: SQL Server Security
  • Module 2: Assigning Server and Database Roles
  • Module 3: Authorizing Users to Access Resources
  • Module 4: Protecting Data with Encryption and Auditing
  • Module 5: Recovery Models and Backup Strategies
  • Module 6: Backing Up SQL Server Databases
  • Module 7: Restoring SQL Server 2016 Databases
  • Module 8: Automating SQL Server Management
  • Module 9: Configuring Security for SQL Server Agent
  • Module 10: Monitoring SQL Server with Alerts and Notifications
  • Module 11: Introduction to Managing SQL Server by using PowerShell
  • Module 12: Tracing Access to SQL Server with Extended events
  • Module 13: Monitoring SQL Server
  • Module 14: Troubleshooting SQL Server
  • Module 15: Importing and Exporting Data

Frequently Asked Questions

"Administering a SQL Database Infrastructure - Course 20764-C Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 1,150 $.

"Administering a SQL Database Infrastructure - Course 20764-C Course" trainings are given in two different ways.

The tuition fee as a group is 1,490 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,150 $.

Our "Administering a SQL Database Infrastructure - Course 20764-C Course" trainings are one-to-one 5 days,

Our "Administering a SQL Database Infrastructure - Course 20764-C Course" trainings are group 3 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Reviews

Recommendations by our happy graduates.

Popular locations for Administering a SQL Database Infrastructure - Course 20764-C Course in Iran, Islamic Republic of

Request more information for
"Administering a SQL Database Infrastructure - Course 20764-C Course"

Prefered Mode of Contact