Administering Microsoft Azure SQL Solutions – Training
Categories: All Courses, Cloud & DevOps Certifications
About Course
“Administering Microsoft Azure SQL Solutions” training equips IT professionals with essential skills to manage and optimize Azure SQL databases. Participants learn to configure, monitor, and troubleshoot SQL databases in Azure, ensuring high availability, security, and performance. Topics include database deployment, data migration, disaster recovery strategies, and implementing security measures. Practical hands-on exercises and case studies enhance understanding of Azure SQL administration best practices. This training is ideal for database administrators and Azure professionals looking to expand their expertise in cloud-based SQL solutions, enabling them to effectively manage data platforms and support business-critical applications in Azure environments.
What Will You Learn?
- 1. In-Demand Skills
- 2. Career Advancement
- 3. Efficient CRM Management
- 4. Data Security
- 5. Workflow Automation
- 6. Reporting Insights
- 7. Job OpportunitiesHours On Demanded Videos
Course Content
Module 1: Introduction
-
Introduction
-
Welcome to Udemy
-
How to get the best out of your Udemy course
-
Do you want auto-translated subtitles in more languages?
-
Curriculum
-
Resources
Module 2: Review prerequisites
-
Getting a free trial of Microsoft Azure
-
Creating Azure SQL Database with sample data
-
Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS
-
Review 6 principal clauses of the SELECT statement
-
Review JOINs
Module 3: Optimize Query Performance
-
determine the appropriate type of execution plan
-
Different types of loops used in execution plans, and Scan and Seek
-
identify problem areas in execution plans
-
Optimize Query Performance
Module 4: Evaluate performance improvements
-
identify and implement index changes for queries
-
DMVs which gather query performance information
-
determine the appropriate DMVs to gather performance information
-
recommend query construct modifications based on resource usage
-
assess the use of hints for query performance
-
Evaluate performance improvements
Module 5: Plan and Implement Data Platform Resources
-
deploy database offerings on selected platforms
-
configure customized deployment templates
-
evaluate requirements and functional benefits/impact for the deployment
-
evaluate scalability and security aspects
-
HA/DR of the possible database offerings
-
Automate deployment by using Azure Resource Manager (ARM) templates
-
Automate deployment by using Bicep – Install Visual Studio Code
-
Automate deployment by using Bicep – Creating/deploying Bicep code
-
Automate deployment by using PowerShell
-
Automate deployment by using Azure CLI
-
Plan and Implement Data Platform Resources
Module 6: Configure Azure SQL Database resources for scale and performance
-
configure Azure SQL Database for scale and performance
-
vCore-based purchasing model
-
DTU-based purchasing model, Server vs Serverless
-
Serverless/provisioned and elastic pools
-
Other Azure SQL Database configuration settings
-
calculate resource requirements, including Elastic pool requirements
-
database sharding and table partitioning
-
evaluate the use of compression for tables and indexes
-
set up SQL Data Sync
-
Configure Azure SQL Database resources for scale and performance
Module 7: Evaluate a strategy for migrating to Azure
-
evaluate requirements and strategies for the migration
-
Azure Migrate
-
SQL Server Migration Assistant (SSMA)
-
Data Migration Assistant (DMA)
-
Azure Database Migration Service (DMS)
-
Implement a migration between Azure SQL services – export data
-
Implement a migration between Azure SQL services – Other methods
-
Perform post migration validations
-
Evaluate a strategy for migrating to Azure
Module 8: Configure database AuthN and AuthZ by using platform and database tools
-
What is Microsoft Entra ID?
-
configure Microsoft Entra ID authentication
-
create users from Microsoft Entra ID identities
-
configure security principals – roles
-
configure security principals – GRANT/REVOKE/DENY
-
configure security principals – individual permissions
-
configure security principals – the ALL permission
-
configure permissions by using custom roles
-
apply principle of least privilege for all securables
-
Configure database AuthN and AuthZ by using platform and database tools
Module 9: Implement security for data at rest and in transit
-
implement Transparent Data Encryption (TDE)
-
implement object-level encryption and Always Encrypted
-
More about Always Encrypted
-
Always Encrypted versus Transparent Data Encryption
-
Implement Always Encrypted with VBS enclaves
-
implement Dynamic Data Masking
-
configure server and database-level firewall rules
-
Configure Transport Layer Security (TLS)
-
Implement security for data at rest and in transit
Module 10: Implement compliance controls for sensitive data – Part 1
-
apply a data classification strategy
-
configure server and database audits
-
implement data change tracking – Change Tracking
-
implement data change tracking – Change Data Capture
-
perform a vulnerability assessment
-
Implement compliance controls for sensitive data
Module 11: Implement compliance controls for sensitive data – Part 2
-
Adding a secret in Azure Key Vault
-
Manage database resources by using Azure Purview – theory + credentials
-
Manage data resources by using Azure Purview – sources and scans
-
Implement Azure SQL Database ledger – Theory
-
Implement Azure SQL Database ledger – Creating Updateable ledger table
-
Implement Azure SQL Database ledger – Append-only table and verifying
-
Implement row-level security
-
Configure Advanced Threat Protection / Microsoft Defender for SQL
Module 12: Monitor activity and performance
-
prepare an operational performance baseline – Metrics Explorer
-
prepare an operational performance baseline – Other ways
-
create event notifications for Azure resources
-
determine sources for performance metrics
-
interpret performance metrics
-
Monitor by using Intelligent Insights
-
configure and monitor activity and performance
-
Monitor by using SQL insights – Theory and deploying components
-
. Monitor by using SQL insights – Implementation
-
Monitor activity and performance
Module 13: Implement performance-related maintenance tasks
-
implement index maintenance tasks
-
implement statistics maintenance tasks
-
configure database auto-tuning and automate performance tuning
-
manage storage capacity
-
assess growth/fragmentation and report on database free space
-
Implement performance-related maintenance tasks
Module 14: Identify performance-related issues
-
Query Store – an introduction
-
configure Query Store, extract query plans
-
identify sessions that cause blocking
-
Isolation Levels
-
assess performance-related database configuration parameters
-
configure Intelligent Query Processing (IQP)
-
Identify performance-related issues
Module 15: Automate tasks and Perform backup and restore a database by using database tools
-
What is Elastic Job Agent?
-
automate database maintenance tasks
-
Full, differential and transaction log backups
-
perform a database restore to a point in time – test DR
-
configure long-term backup retention
-
Automate tasks and Perform backup and restore a database by using database tools
Module 16: Recommend an HADR strategy for a data platform solution
-
recommend HADR strategy based on RPO/RTO requirements
-
evaluate Azure-specific HADR solutions
-
configure replication – Active Geo-replication
-
configure auto-failover groups and test HA by using failover
-
Recommend an HADR strategy for a data platform solution
Module 17: Perform Administration by Using T-SQL
-
evaluate database health using DMVs – overall resource usage
-
evaluate database health using DMVs – other topics
-
evaluate server health using DMVs
-
perform database consistency checks by using DBCC
-
review database configuration options
-
Perform Administration by Using T-SQL
Module 18: Introduction to Virtual Machines and Managed Instances (MI)
-
Evaluating MIs and VMs based on specific requirements
-
configure Azure SQL Managed Instance for scale and performance
-
More about Azure SQL Managed Instance
-
Accessing Azure SQL Managed Instance in SSMS
-
Implement Azure SQL Managed Instance database copy and move
-
configure SQL Server in Azure VMs – Part 1
-
configure SQL Server in Azure VMs – Part 2
-
Logging into SQL Server on Azure Virtual Machines
-
Adding additional disks to the Azure Virtual Machine
Module 19: Configure database authentication, and filegroups
-
create users from Azure AD identities (MIs and VMs)
-
manage certificates using T-SQL
-
configure database and object-level permissions using GUI
-
configure security principals (MIs and VMs)
-
recommend table, index storage inc. filegroups (MI and VMs)
-
Upgrade strategy, configure database authentication, and filegroups
Module 20: Evaluate and implement an alert and notification strategy
-
create event notifications based on metrics
-
configure notifications for task success/failure/non-completion
-
manage schedules and automate maintenance jobs
-
create alerts for server configuration changes
-
split and filter event notifications for Azure resources
-
Evaluate and implement an alert and notification strategy
Module 21: Identify performance-related issues
-
determine sources for performance metrics
-
implement index maintenance tasks (Database Engine Tuning Advisor)
-
Monitor activity: SQL Profile, Extended Events, Performance Dashboard
-
configure Resource Governor for performance (VM/MI)
-
Identify performance-related issues
Module 22: Create scheduled tasks
-
apply patches and updates for hybrid and IaaS deployment
-
implement Azure Key Vault and disk encryption for Azure VMs
-
configure multi-server automation
-
implement policies by using automated evaluation modes
-
Create scheduled tasks
Module 23: Perform backup and restore a database by using database tools – VMs
-
automate backups
-
perform a database backup with options
-
database (and transaction log) backups with options
-
perform a database restore with options
-
perform restore of user databases in T-SQL
-
backup and restore to and from cloud storage
Module 24: Recommend and test HA/DR strategies, and configure HA/DR
-
configure replication – Transactional replication
-
evaluate HADR for hybrid and Azure-specific deployments
-
Creating Virtual Machines for Failover Cluster and Always On Availability Group
-
Connecting Virtual Machines to a Domain
-
Configure failover cluster instances on Azure VMs
-
Checking SQL Server Installation and preparing for AO
-
configure quorum options for a Windows Server Failover Cluster
-
create an Availability Group
-
Failover, integrate database into Always On Availability Group
-
configure an Always On Availability Group listener
-
Log shipping theory and creating folders
-
Configure log shipping
-
Testing log shipping and troubleshooting
-
Recommend and test HA/DR strategies, and configure HA/DR
Module 25: Conclusion
-
What’s Next?
-
Practice Test
-
Practice Test – DMVs and roles
-
Well done
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
