764 – Administering a SQL Database Infrastructure
Microsoft Official Courses (MOC)
Course 20764C: Administering a SQL Database Infrastructure
About this Course:
-
- 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.
Course Goals/Skills:
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Backup SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for the SQL Server agent
- Manage alerts and notifications
- Managing SQL Server using PowerShell
- Trace access to SQL Server
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
- Import and export data
Audience:
-
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Course Format:
Присъствен (Classroom) Курс в Учебната ни зала или В Офис на Клиент | Онлайн (Online/Virtual) Курс във виртуална зала с инструктор |
Course Language Option
Български (Bulgarian) | Английски (English) |
You can choose the language in which the training will be conducted – Bulgarian or English. All our instructors are fluent in English.
Student Guides:
The training materials are available in electronic format. They can be used online / offline on any device. Lifetime access.
Lab Environment:
Each student has their own lab environment where the exercises are conducted, part of the course. You do not need to install software on a computer or special hardware requirements.
Participants in a face-to-face format in our Training Center have an individual computer during the training.
At Course Completion:
Lifetime Access - Video Archive 24/7 | Certificate of Course Completion |
Lifetime access to a video archive with recording of each individual lecture.
Official internationally recognized certificate for completed training course.
Course Duration:
- 5 working days (09:00 – 17:00)
or - 40 hours training (theory and practice) in non-working hours lasting 4 weeks
Saturday and Sunday 10:00 – 14:00, 14:00 – 18:00, 18:00 – 22:00
Monday and Wednesday 19:00 – 23:00
Tuesday and Thursday 19:00 – 23:00
Payments:
An application for an invoice is accepted at the time of enrollment in the respective course.
An invoice is issued within 7 days of confirming the payment.
Next Class:
For more information, use the contact format. We will contact you to confirm the data.
Prerequisites:
-
-
-
-
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- 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.
-
-
-
This Class will teach you how to pass the following exams:
-
Exam 70-764: Administering a SQL Database Infrastructure
- Може да се сертифицирате в нашия тест център с ваучер с отстъпка от цената на изпит.