This course provides participants with the skills needed to plan, deploy, secure, monitor, and optimize SQL database infrastructure within Microsoft Azure across cloud (PaaS), on-premises, and hybrid environments. It is designed for database administrators, data architects, and application developers working with Microsoft’s data platform technologies.
The training covers key administrative tasks such as deploying SQL Server on virtual machines or PaaS offerings, implementing data security measures, monitoring system performance, optimizing SQL queries, and automating routine operations. It also includes guidance on implementing high availability and disaster recovery (HADR) strategies using Azure-native tools.
Duration
4 days
Schedule
See training dates for details
Regular fee
$2,590
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,330
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
Upcoming information
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
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
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 quoteDuration
4 days
Schedule
See training dates for details
Regular fee
$2,590
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,330
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 quote