Azure SQL Training, Azure Certification, azure training, DP-300 exam, microsoft azure certification, azure certification path, azure fundamentals, azure devops certification, azure cloud certification, microsoft azure fundamentals

SKU: MS-DP300T00 Category: Microsoft Data & AI

Administering Microsoft Azure SQL Solutions

Name: Administering Microsoft Azure SQL Solutions - Data4Every1
SKU: MS-DP300T00
Price: 10500.00 ZAR
Availability: InStock

This course teaches students how to design, implement and manage SQL Server databases for cloud, on-premises and hybrid environments. It is ideal for professionals working with Microsoft PaaS relational database solutions and developers building applications that deliver content from SQL-based relational databases.

R10,500.00 Excl. VAT

Book Training

Clear

Product Details

Administering Microsoft Azure SQL Solutions equips students with the knowledge and skills to design and implement SQL Server database infrastructures for cloud, on-premises and hybrid relational databases. It is ideal for professionals working with Microsoft PaaS relational database solutions and for developers building applications that deliver content from SQL-based relational databases.

Discover more

Download Outline ➤ ME-EXL365Pt2 – Microsoft Excel 365 Part 3

Watch an informative video ➤ Why read Azure SQL Revealed 2nd edition?

Associated Certification & Exam

This course will prepare delegates to write the Microsoft Certified: Azure Database Administrator Associate Exam.

COURSE CONTENT

Module 1: Plan and implement data platform resources

Deploy data platform resources in Azure SQL. Explore options for deployment and migration. Calculate resource requirements and create templates.

Module 1.1: Prepare to maintain SQL Server-based databases on Azure

Explore the role of a database administrator on Azure. Describe SQL Server-based offerings on Azure.

Module 1.2: Deploy IaaS solutions with Azure SQL

Configure virtual machine sizing, storage and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options.

Module 1.3: Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL Managed Instance. Select the appropriate options when performing a migration to the SQL PaaS platform.

Module 1.4: Migrate SQL Server workloads to Azure SQL Database

Explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Module 1.5: Migrate SQL Server workloads to Azure SQL Managed Instance

Explore different migration tools and migrate SQL Server databases to Azure SQL Managed Instance.

Module 2: Implement a secure environment for a database service

Implement SQL Server-based options for authentication and authorisation as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.

Module 2.1: Configure database authentication and authorisation

Contrast authentication using Microsoft Entra ID and SQL Server authentication. Implement various security principals and configure permissions.

Module 2.2: Protect data in-transit and at rest

Explore encryption options available within Azure SQL including firewall rules, Always Encrypted and Transport Layer Security. Understand how SQL Injection works.

Module 2.3: Implement compliance controls for sensitive data

Explore data classification capabilities and degrees of confidentiality. Implement security options to keep private data safe including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Ledger.

Module 3: Monitor and optimise operational resources in Azure SQL

Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.

Module 3.1: Describe performance monitoring

Compare Azure and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis. Configure extended event sessions for tracing activities.

Module 3.2: Configure SQL Server resources for optimal performance

Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.

Module 3.3: Configure databases for optimal performance

Implement tasks for both IaaS and PaaS to maintain indexes and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.

Module 4: Optimise query performance in Azure SQL

Analyse individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.

Module 4.1: Explore query performance optimisation

Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated. Understand the purpose and benefits of the Query Store.

Module 4.2: Explore performance-based database design

Explore normalisation for relational databases. Investigate the impact of proper data type usage. Compare types of indexes.

Module 4.3: Evaluate performance improvements

Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints.

Module 5: Automate database tasks for Azure SQL

Script repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automate error and resource alerts. Configure notifications for failures.

Module 5.1: Automate database deployment

Explore multiple deployment models available on Azure. Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources. Understand how to use PowerShell and Azure CLI for automation purposes.

Module 5.2: Create and manage SQL Agent jobs

Explore SQL automation for scheduled tasks and automatic alerts for SQL Server and Azure SQL Managed Instance.

Module 5.3: Manage Azure PaaS tasks using automation

Explore automation for the Azure SQL platform. Configure elastic jobs, explore Azure Automation and evaluate different strategies for monitoring automation tasks.

Module 6: Plan and implement a high availability and disaster recovery environment

Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.

Module 6.1: Describe high availability and disaster recovery strategies

Plan an appropriate high availability and disaster recovery strategy based on recovery time objective and recovery point objective. Choose the best solution for IaaS or PaaS deployments or hybrid workloads.

Module 6.2: Explore IaaS and PaaS solutions for high availability and disaster recovery

Deploy Windows Server Failover Cluster and availability groups in Azure and hybrid environments. Configure temporal tables, geo-replication and auto-failover groups.

Module 6.3: Back-up and restore databases

Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.

Disclaimer

Training4Every1 Course details and content may change without notice to stay aligned with current software updates and best practices.

By booking this training, you agree to our Training Terms and Conditions.

Click here to view Training T & C’s.

Got questions or feeling a bit lost in Excel, Word or Teams?

Don’t worry – we’ve got you! Reach out and we’ll help you find the perfect Microsoft training for you and your team.

Follow us and stay up to date with the latest training journeys, business solutions and powerful automation tools.