Enroll Now With Us
Please fill the below details, and our consultant will help you in the enrollment process.
Please fill the below details, and our consultant will help you in the enrollment process.
Your submission is received and we will contact you soon
SQL
$2495
Per Participant
This Administering a SQL Database is a five-day training course that will help you understand how to maintain and administer Azure SQL Database, SQL Server, and cloud-based SQL. This 55316-course is for those IT professionals familiar with database environments. Database plays an essential role in this field. Individuals can learn to do those tasks with our hands-on lab and certified instructor demonstrations.
Required
Microsoft Certified PartnerMicrotek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization.
Lessons
Lab 1: SQL Server Security
After completing this module, students will be able to:
This module explains how to use roles at the server and database level to manage user permissions.
Lessons
Lab 1: Assigning Server and Database Roles
After completing this module, students will be able to:
This module explains how to authorize users to access server and database roles. It also describes how to manage permissions at different levels in a SQL Server instance.
Lessons
Lab 1: Authorizing Users to Access Resources
After completing this module, students will be able to:
This module describes the available options for auditing and how to manage audit features. It also describes how to configure and implement data encryption.
Lessons
Lab 1: Using Auditing and Encryption
After completing this module, students will be able to:
In this module, you will learn how to use the available backup features for databases and transaction logs to create backup strategies.
Lessons
Lab 1: Understanding SQL Server Recovery Models
After completing this module, students will be able to:
In this module, you will learn how to apply various backup strategies.
Lessons
Lab 1: Backing Up Databases
After completing this module, students will be able to:
In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.
Lessons
Lab 1: Restoring SQL Server Databases
After completing this module, students will be able to:
This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multi-server jobs.
Lessons
Lab 1: Automating SQL Server Management
After completing this module, students will be able to:
This module explains how to configure SQL Server Agent to use a minimal privilege security environment and how to use credentials and proxy accounts to run jobs securely.
Lessons
Lab 1: Configuring SQL Server Agent
After completing this module, students will be able to:
This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database.
Lessons
Lab 1: Monitoring SQL Server with Alerts and Notifications
After completing this module, students will be able to:
This module explains how to use Windows PowerShell with Microsoft SQL Server and Azure SQL Database. It also describes how to improve efficiency and reliability by scripting tasks and jobs.
Lessons
Lab 1: Using PowerShell to Manage SQL Server
After completing this module, students will be able to:
This module explains how to monitor performance metrics for SQL Server and Azure SQL Database. It also describes troubleshooting strategies and usage scenarios for working with Extended Events.
Lessons
Lab 1: Using SQL Server Extended Events
After completing this module, students will be able to:
This module explains how to monitor databases with the goal of proactively dealing with potential issues. It also describes how to use the built-in tools provided to analyze instance and server activity.
Lessons
Lab 1: Monitoring SQL Server
After completing this module, students will be able to:
This module explains how to resolve common issues that may arise when working with SQL Server systems. It also describes a methodology for resolving general database server issues.
Lessons
Lab 1: Troubleshooting SQL Server
After completing this module, students will be able to:
This module explains how to use SQL Server native tools to import and export data to and from SQL Server and Azure SQL Databases.
Lessons
Lab 1: Importing and Exporting data
After completing this module, students will be able to:
* For more details call: +1-800-961-0337 or Email: info@microteklearning.com
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA