DP-300T00: Administering Microsoft Azure SQL Solutions
Duration: 4 Days (32 Hours)
DP 300 : Administering Microsoft Azure SQL Solutions Course Overview:
The DP-300 course provides students with the knowledge and skills required to administer a SQL Server database infrastructure effectively. It covers deployment scenarios including cloud, on-premises, and hybrid relational databases, with a focus on Microsoft’s Platform as a Service (PaaS) offerings.
The course primarily focuses on database management and maintenance in various environments. Participants will learn essential administrative tasks such as database installation, configuration, and security implementation. They will also gain skills in monitoring and optimizing database performance, ensuring data availability and integrity.
The DP-300 course also caters to individuals involved in application development that relies on content delivery from SQL-based relational databases. Students will learn best practices for developing applications that efficiently utilize SQL Server databases, enabling them to deliver robust and high-performing content-driven solutions.
By the end of the course, students will have a comprehensive understanding of administering SQL Server database infrastructures in different deployment scenarios. Whether in the cloud, on-premises, or in hybrid environments, they will be equipped with the skills to ensure the smooth operation and optimal performance of relational databases. This knowledge will empower them to support a wide range of applications that rely on SQL-based content delivery.
Audience Profile:
The DP-300 course is primarily targeted towards data professionals who are responsible for managing data and databases and are interested in gaining knowledge about administering data platform technologies available on Microsoft Azure. This course is designed to provide these professionals with the necessary skills to effectively administer and maintain data platform solutions on Azure.
In addition to data professionals, the course also benefits data architects who need to understand the available technologies within the Azure data platform. It helps them gain insights into the capabilities and functionalities offered by Azure for data management and administration. This knowledge enables data architects to make informed decisions about designing data platform solutions using Azure services.
Furthermore, application developers will find value in this course as it provides an understanding of the various data platform technologies available on Azure and how to work with them through applications. This knowledge allows developers to leverage Azure’s data platform services effectively, ensuring efficient and seamless integration of data functionalities into their applications.
Overall, the DP-300 course caters to a wide range of professionals, including data professionals, data architects, and application developers. It equips them with the knowledge and skills required to administer data platform technologies on Microsoft Azure and effectively work with these technologies through applications.
Job role: Database Administrator
Certification Path:
Prepare to maintain SQL databases on Azure
- Understand the role of Azure Database Administrator as it fits in with other data platform roles.
- Describe the key differences between the SQL Server-based database options in Azure.
- Describe other features for Azure SQL platforms available.
Deploy IaaS solutions with Azure SQL
- Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
- Learn the available options for provisioning and deployment
- Deploy SQL Server into an Azure Virtual Machine
Deploy PaaS solutions with Azure SQL
- Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
- Understand PaaS provisioning and deployment options
- Understand elastic pools
- Examine Azure SQL Managed Instances
- Explore Azure SQL Edge
- Configure a template for PaaS deployment
Evaluate strategies for migrating to Azure SQL
- 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 and public preview options.
Migrate SQL workloads to Azure SQL databases
- Describe the considerations for a SQL Server to Azure SQL Database migration.
- Describe the methods and steps to perform an offline migration to Azure SQL Database.
- Describe the methods and 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, and scalability.
Migrate SQL workloads to Azure Managed Instances
- Evaluate migration scenarios to Azure SQL Database Managed Instance
- Migrate to Azure SQL Database Managed Instance
- Load and move data to Azure SQL Database Managed Instance
Configure database authentication and authorization
- Learn about authentication options for Azure SQL Database
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication and authorization failures
Protect data in-transit and at rest
- Understand the data encryption options available in the various platforms
- Implement object level encryption
- Understand the difference between database and server firewall rules for Azure SQL Database
- Explore Always Encrypted with secure enclaves
Implement compliance controls for sensitive data
- Plan and implement data classification in Azure SQL Database
- Understand and configure row-level security and dynamic data masking
- Understand the usage of Microsoft Defender for SQL
- Explore how Azure SQL Database Ledger works
Describe performance monitoring
- 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.
Configure SQL Server resources for optimal performance
- Understand your options for configuration of Azure storage
- Learn how to configure TempDB data files in SQL Server
- Learn how to choose the right type of VM for SQL Server workloads
- Understand the use cases and configuration of Resource Governor in SQL Server
Configure databases for optimal performance
- Understand database scoped configuration options
- Understand maintenance tasks related to indexing and statistics
- Understand the features of Intelligent Query Processing (IQP)
- Explore the automatic tuning feature in Azure
Explore query performance optimization
- Generate and save execution plans
- Compare the different types of execution plans
- Understand how and why query plans are generated
- Explain the purpose and benefits of the Query Store
- Investigate the available reports and data in the Query Store
Evaluate performance improvements
- Determine when changing indexes or defining new ones can affect performance
- Evaluate wait statistics as an aid in finding areas for performance improvement
- Understand how query hints work, and when to use them
Explore performance-based design
- Explore normal forms and how they affect database design
- Choose appropriate datatypes for your data
- Evaluate appropriate index types
Automate deployment of database resources
- Describe the deployment models available on Azure
- Deploy database resources using PowerShell and Azure CLI
- Deploy an Azure Resource Manager template and Bicep
- Understand the difference between multiple command-line options
Create and manage SQL Agent jobs
- Schedule necessary maintenance activities for your databases.
- Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
- Configure alerts based on performance monitor values.
Manage Azure PaaS tasks using automation
- Undersand the benefits of Azure policy
- Explore the capabilities of Azure Automation
- Configure elastic jobs
- Use Logic Apps for database workflow
Describe high availability and disaster recovery strategies
- Define recovery time objective and recovery point objective
- Explore the available high availability and disaster recovery options for both IaaS and PaaS
- Devise an appropriate high availability and disaster recovery strategy
Explore IaaS and PaaS solutions for high availability and disaster recovery
- Explore options for deploying a WSFC in Azure
- Explore options for deploying an AG in Azure
- Implement Temporal Tables
- Plan active geo-replication and auto-failover groups
Back up and restore databases
- Explore backup and restore options for IaaS
- Implement backup and restore for PaaS
DP 300 : Administering Microsoft Azure SQL Solutions Course Overview:
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.
Specifically:
- Working with, maintaining, and developing with SQL Server
- Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following online training before attending the course:
Q: What is DP-300 Training?
A: DP-300 Training is a comprehensive program designed to provide participants with the knowledge and skills required to administer and manage Microsoft SQL Server databases. It covers various topics related to database installation, configuration, security, backup and recovery, high availability, and performance tuning.
Q: Who is the DP-300 Training intended for?
A: DP-300 Training is intended for database administrators, system administrators, and IT professionals who are responsible for managing and administering SQL Server databases. It is suitable for individuals who have a basic understanding of SQL Server and want to deepen their expertise in database administration.
Q: What are the prerequisites for DP 300 Training?
A: To fully benefit from DP 300 Training, participants should have a fundamental understanding of SQL Server and experience with database administration tasks. Familiarity with concepts such as database design, SQL queries, and database management systems will be helpful.
Q: What topics are covered in DP 300 Training?
A: DP 300 Training covers a wide range of topics, including SQL Server installation and configuration, database security, backup and recovery strategies, high availability solutions such as Always On Availability Groups, database maintenance, performance tuning, and troubleshooting.
Q: How long does DP 300 Training take to complete?
A: The duration of DP 300 Training can vary depending on the training provider and the format of the course. It can range from a few days to several weeks, with part-time or full-time study options available.
Q: Can I take DP300 Training online?
A: Yes, we offer DP300 Training in an online format, allowing you to learn at your own pace and convenience.
Q: Are there any hands-on exercises in DP300 Training?
A: Yes, DP300 Training typically includes hands-on exercises that allow participants to practice database administration tasks in a simulated environment. These exercises may involve tasks such as database configuration, security implementation, backup and recovery procedures, and performance tuning.
Q: Can I get a certificate after completing DP300 Training?
A: Yes, upon completing DP300 Training, you may receive a certificate of completion or participation from the training provider. However, it’s important to note that the DP300 certification is obtained by passing the official Microsoft DP300 exam, which is separate from the training course.
Q: Does DP 300 Training cover all the topics required for the DP 300 exam?
A: DP 300 Training is designed to cover the topics and concepts relevant to the DP 300 exam. However, it is recommended to supplement the training with additional study materials, practice exams, and hands-on experience to ensure thorough preparation for the exam.
Q: Where can I find additional study materials for the DP 300 exam?
A: In addition to DP300 Training, you can find additional study materials on the official Microsoft Learning website, including exam guides, documentation, and online resources. Microsoft also offers practice exams and official study guides specifically tailored for the DP 300 exam.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Microsoft Certified Trainers (MCT).
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!