Administering a SQL Database Infrastructure (20764)
Details
Outline
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.
At Course Completion:
After completing this course, students will be able to:
-
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
Speaker/s
Special Offer
- Courseware (please indicate if you would prefer a hard copy or e-book)
- Online labs for up to 180 days
- Full technical support for 3 months following delivery, for this course.
We are here to promote the core values of our vendors. We promote learning courses and courseware which has been approved by vendors to be accurate and the best material on the market to ensure that you learn the content with a view to certifying in the same area of study.
Our team of delivery specialists, training staff and proctoring team are guided by the principles, codes and requirements of our vendors. We can assure you that the training you will get will be correct and is as was intended by the vendor.
Our trainers are all experienced in their respective fields. Vendor requirements have been met.
In the case of Microsoft training, both public and private courses are provided using:
- active, current Microsoft Certified Trainers experienced in the area who have passed the relevant certification exam.
- official courseware and virtual lab materials only.
- Course management provided in association with a Certified Partner for Learning Solutions (CPLS) centre training provider (where it has not been possible for MBIT to manage the course directly ourselves). ...