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.
Course Price : $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.
Courses
Years of Experience
Global Learners
Microtek 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).
Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.
For dates, times, and location customization of this course, get in touch with us.
You can also speak with a learning consultant by calling 800-961-0337.
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:
©2023 Microtek Learning – All Rights Reserved