This 5-days Microsoft 20764B Administering a SQL Database Infrastructure Certification is a five-day course, part 1 of the series of two courses of MCSA 2016: SQL Database Administration, that equips students and professionals to cater to a dynamic SQL Server database infrastructure.
The professionals acquire the requisite skills to administer and maintain, protect data with encryption and auditing, and automate database management. Not only this, but this exhaustive training will teach you to configure, manage, and troubleshoot a SQL server infrastructure.
Module 1: Authenticating and Authorizing Users
This module introduces SQL Server security models, logins, and users.
Module 2: Assigning Server and Database Roles
This module introduces fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.
Module 3: Authorizing Users to Access Resources
This module describes permissions and the assignment of permissions.
Module 4: Protecting Data with Encryption and Auditing
This module describes SQL Server Audit.
Module 5: SQL Server Recovery Models
This module introduces the concept of the transaction log and SQL Server recovery models. It also describes the different backup strategies available with SQL Server.
Module 6: Backup of SQL Server Databases
This module explains SQL Server Backup and the backup types
Module 7: Restoring SQL Server Databases
This module describes the restoration of databases.
Module 8: Automating SQL Server Management
This module explains the use of SQL Server Agent for automation. It also describes the benefits of using master and target servers to centralize the administration of automation.
Module 9: Configuring Security for SQL Server Agent
This module explains the considerations for SQL Server Agent security, including proxy accounts and credentials.
Module 10: Monitoring SQL Server with Alerts and Notifications
This module explains the configuration of database mail, alerts and notifications.
Module 11: Introduction to Managing SQL Server by using PowerShell
This module describes PowerShell for SQL Server.
Module 12: Tracing Access to SQL Server
This module explains how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking.
Module 13: Monitoring SQL Server
This module explains the use of Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.
Module 14: Troubleshooting SQL Server
This module introduces the SQL Server troubleshooting methodology and discusses the common issues arises when working with SQL Server systems.
Module 15: Importing and Exporting Data
This module explains the use of the import/export wizards and explains how they relate to SSIS.
The primary audience for administering a SQL database infrastructure training course is professionals who cater to SQL Server databases.
The secondary audiences for this course are professionals who build applications that deliver content from SQL Server databases.
Participants who attend this training should have the following technical knowledge:
|Administering a SQL Database Infrastructure||70-764||USD 108|
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.