Objectives of the training
This course provides participants with the skills and knowledge needed to administer a SQL Server database infrastructure for cloud, local and hybrid relational databases and who work with Microsoft PaaS relational database offerings.Targeted audience
The training is aimed at professionals who manage data and databases and who want to learn more about administering the data platform technologies available on Microsoft Azure. This training is also of interest to data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with these technologies through applications.Prerequisite
In addition to their professional experience, participants must have technical knowledge equivalent to the following courses:• Azure Fundamentals
• Azure Data Fundamentals
Trainers
Benefits for Participants
On completion of the course, participants will be able to :
Plan, deploy and configure Azure SQL offerings
Explain how to monitor database performance and set up a database and queries for optimal performance.
Course architecture
Azure Database Administrator roles
Azure Data Platform Roles
Azure database platforms and options
SQL Server compatibility level
Azure Preview features
Planning and implementing data platform resources
Deploying SQL Server on a virtual computer
Deploying a PaaS solution
Deploy MariaDB, MySQL and PostgreSQL on Azure
Implement a secure environment for a database service
Configuring database authentication
Configure database authorization
Implement data security at rest
Implement security for data in transit
Implement compliance controls for sensitive data
Monitor and optimize operational resources
Baselines and performance monitoring
Main causes of performance problems
Configuring resources for optimum performance
User database configuration
Performance-related maintenance tasks
Optimizing query performance
Overview of SQL Server query plans
Exploring performance-based database design
Evaluating performance improvements
Automating tasks
Configuring automatic deployment
Defining scheduled tasks with the SQL Server agent
Configure extended events
Manage Azure PaaS resources using automated methods
Planning and implementing a high availability and disaster recovery environment
High availability and disaster recovery strategies
IaaS platform and database tools for HADR (High Availability and Disaster Recovery)
PaaS platform and database tools for HADR (High availability and recovery)
Database backup and recovery.
Pedagogical details
Type of training
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote