Course Description
This course provides students with the knowledge &knowledge of how to manage an on-premises or Cloud SQL Server database infrastructure & hybrid relational databases & who utilize the relational database services offered by Microsoft PaaS. It will also be beneficial to those who create applications that deliver content from relational databases with a SQL foundation.
Prerequisites
Successful Azure Database Administrators begin in this position with a background in database administration and technical expertise in cloud computing.
Specifically:
Working with, maintaining, & developing SQL Server
Experience with Azure, such as deploying & controlling resources
Before enrolling in the course, you should at the very least be familiar with the information in the following online training:
Target Audience
The target audience for this course is data professionals who manage databases and data and are interested in learning how to manage the data platform technologies offered by Microsoft Azure. This course will also be useful for data architects and application developers who need to know What technologies are available for the Azure data platform? & how to use those technologies through applications.
Content Outline
- Recognize how the Azure Database Administrator role interacts with other roles on data platforms.
- Explain the key differences between the SQL Server-based database options in Azure.
- Explain other features for Azure SQL platforms available.
- Investigate SQL Server's fundamentals through an Infrastructure as a Service (IaaS) program.
- Learn the available options for provisioning & Deployment
- Deploy SQL Server into an Azure Virtual Machine
- Gain an understanding of SQL Server in a Platform as a Service (PaaS) offering
- Understand PaaS provisioning & deployment options
- Understand elastic pools
- Examine Azure SQL Managed Instances
- Explore Azure SQL Edge
- Configure a template for PaaS deployment
- Evaluate different Azure migration options when moving your SQL environment to the Cloud.
- Understand how SQL Server compatibility level affects database behavior.
- Understand the differences between private & public preview options.
- Explain the considerations for a SQL Server to Azure SQL Database migration.
- Explain the methods & steps to perform an offline migration to Azure SQL Database.
- Explain the methods & steps to perform an online migration to Azure SQL Database.
- Explore the post-migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, & scalability.
- Explain the considerations for a SQL Server to Azure SQL Database migration.
- Explain the methods & steps to perform an offline migration to Azure SQL Database.
- Explain the methods & steps to perform an online migration to Azure SQL Database.
- Explore the post-migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, & scalability.
- Evaluate migration scenarios to Azure SQL Database Managed Instance
- Migrate to Azure SQL Database Managed Instance
- Load & move data to Azure SQL Database Managed Instance
- Learn about authentication options for Azure SQL Database
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication & authorization failures
- Understand the data encryption options available in the various platforms
- Implement object-level encryption
- Understand the difference between database & server firewall rules for Azure SQL Database
- Explore Always Encrypted with secure enclaves
- Plan & implement data classification in Azure SQL Database
- Understand & configure row-level security & dynamic data masking
- Understand the usage of Microsoft Defender for SQL
- Explore how Azure SQL Database Ledger works
- Review potential performance issues.
- Identify critical Azure metrics.
- Learn how to collect metrics for an established baseline.
- Use extended events for performance analysis.
- Understand Azure SQL Database Intelligent Insights.
- Understand your options for the configuration of Azure storage
- Learn how to configure TempDB data files in SQL Server
- Understand how to choose the right type of VM for SQL Server workloads
- Understand the use cases & configuration of Resource Governor in SQL Server
- Understand database-scoped configuration options
- Understand maintenance tasks related to indexing & statistics
- Understand the features of Intelligent Query Processing (IQP)
- Explore the automatic tuning feature in Azure
- Generate & save execution plans
- Compare the different types of execution plans
- Understand how & why query plans are generated
- Explain the purpose & benefits of the Query Store
- Investigate the available reports & data in the Query Store
- Determine when changing or creating new indexes can have an impact on performance.
- Analyze for statistics to assist in identifying areas for performance improvement.
- Understand how query hints work, & when to use them
- Explore standard forms & how they affect database design
- Choose appropriate datatypes for your data
- Evaluate appropriate index types
- Explain the deployment models available on Azure
- Deploy database resources using PowerShell & Azure CLI
- Deploy an Azure Resource Manager template & Bicep
- Understand the difference between multiple comm&-line options
- Schedule necessary maintenance activities for your databases.
- Configure notifications & alerts on SQL Server Agent jobs, & SQL Server.
- Configure alerts based on performance monitor values.
- Understand the benefits of Azure policy
- Explore the capabilities of Azure Automation
- Configure elastic jobs
- Use Logic Apps for database workflow
- Define recovery time objective & recovery point objective
- Explore the available high availability & disaster recovery options for both IaaS & PaaS
- Devise an appropriate high availability & disaster recovery strategy
- Define recovery time objective & recovery point objective
- Explore the available high availability & disaster recovery options for both IaaS & PaaS
- Devise an appropriate high availability & disaster recovery strategy
- Explore options for deploying a WSFC in Azure
- Explore options for deploying an AG in Azure
- Implement Temporal Tables
- Plan active geo-replication & auto-failover groups
- Explore backup & restore options for IaaS
- Implement backup & fix for PaaS
FAQs
Azure Fundamentals certification allows you to demonstrate your understanding of cloud concepts, Azure services, Azure workloads, Azure security and privacy, and Azure pricing and support.
Microsoft Azure, renamed Windows Azure in 2014, is a cloud computing platform created by Microsoft to enable the successful development, Deployment, and management of applications and services across a global network of data centers.
After successfully completing the Microsoft Azure Fundamentals exam, IT pros earn the Microsoft Certified Azure qualification. While this certification is not necessary to pursue more specialized Azure training but on the other h& it does provide essential knowledge & skills to streamline learning & completion.
PaaS is a computing platform that includes an operating system, programming language execution environment, database, or web services. Developers, as well as application providers, use this type of Azure service.
To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs.
We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for participants' h&-on-practice.
Participants can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs allow you to learn from anywhere in the world & in any time zone.
The learners will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & knowledge & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.