DP-300: Administering Microsoft Azure SQL Solutions
Your Microsoft DP-300 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the DP-300 certification test. Ace your Microsoft DP-300 at the first attempt and obtain the Administering Microsoft Azure SQL Solutions credential with ease.
Curriculum for DP-300 Video Course
Review prerequisites
| Video Name | Time | |
|---|---|---|
| 1. Getting a free trial of Microsoft Azure | 6:00 | |
| 2. Creating Azure SQL Database with sample data | 11:00 | |
| 3. Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS | 11:00 | |
| 4. Review 6 principal clauses of the SELECT statement | 6:00 | |
| 5. Review JOINs | 4:00 |
| Video Name | Time | |
|---|---|---|
| 1. 69. validate data types defined for columns | 9:00 | |
| 2. 66. identify data quality issues with duplication of data | 6:00 | |
| 3. 67. identify normal form of database tables - Normal Forms 1 to 3 | 9:00 | |
| 4. 67. identify normal form of database tables - Normal Forms 4 to 5 | 7:00 | |
| 5. 58. determine the appropriate type of execution plan | 6:00 | |
| 6. Different types of loops used in execution plans, and Scan and Seek | 6:00 | |
| 7. 59. identify problem areas in execution plans | 7:00 |
| Video Name | Time | |
|---|---|---|
| 1. 63, 68. identify and implement index changes for queries | 11:00 | |
| 2. 61. DMVs which gather query performance information | 6:00 | |
| 3. 61, 62. determine the appropriate DMVs to gather performance information | 8:00 | |
| 4. 64. recommend query construct modifications based on resource usage | 9:00 | |
| 5. 65. assess the use of hints for query performance | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 1. deploy database offerings on selected platforms | 4:00 | |
| 2. 2, 80. configure customized deployment templates | 8:00 | |
| 3. 4, 5. evaluate requirements and functional benefits/impact for the deployment | 8:00 | |
| 4. 6, 8. evaluate scalability and security aspects | 5:00 | |
| 5. 7. HA/DR of the possible database offerings | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 9. configure Azure SQL Database for scale and performance | 5:00 | |
| 2. 9, 53, 56. vCore-based purchasing model | 9:00 | |
| 3. 9, 53, 56. DTU-based purchasing model, Server vs Serverless | 7:00 | |
| 4. 9, 53, 56. Serverless/provisioned and elastic pools | 6:00 | |
| 5. 9, 53, 56. Other Azure SQL Database configuration settings | 4:00 | |
| 6. 12. calculate resource requirements, including Elastic pool requirements | 4:00 | |
| 7. 13, 71. evaluate database partitioning techniques, such as database sharding | 11:00 | |
| 8. 72. evaluate the use of compression for tables and indexes | 13:00 | |
| 9. 14. set up SQL Data Sync | 12:00 |
| Video Name | Time | |
|---|---|---|
| 1. 15, 16. evaluate requirements and strategies for the migration | 7:00 | |
| 2. 19, 20. Azure Migrate | 3:00 | |
| 3. 19, 20. SQL Server Migration Assistant (SSMA) | 5:00 | |
| 4. 19, 20. Data Migration Assistant (DMA) | 7:00 | |
| 5. 19, 20. Azure Database Migration Service (DMS) | 7:00 |
| Video Name | Time | |
|---|---|---|
| 1. 23. configure Azure AD authentication | 8:00 | |
| 2. 24. create users from Azure AD identities | 8:00 | |
| 3. 25, 113. configure security principals - roles | 9:00 | |
| 4. 25, 113. configure security principals - GRANT/REVOKE/DENY | 4:00 | |
| 5. 25, 113. configure security principals - individual permissions | 5:00 | |
| 6. 25, 113. configure security principals - the ALL permission | 4:00 | |
| 7. 114. configure permissions by using custom roles | 5:00 | |
| 8. 27. apply principle of least privilege for all securables | 3:00 |
| Video Name | Time | |
|---|---|---|
| 1. 28. implement Transparent Data Encryption (TDE) | 4:00 | |
| 2. 29, 33. implement object-level encryption and Always Encrypted | 10:00 | |
| 3. 29, 33. More about Always Encrypted | 9:00 | |
| 4. Always Encrypted versus Transparent Data Encryption | 2:00 | |
| 5. 30. implement Dynamic Data Masking | 8:00 | |
| 6. 32. configure server and database-level firewall rules | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 34. apply a data classification strategy | 6:00 | |
| 2. 35. configure server and database audits | 9:00 | |
| 3. 36. implement data change tracking - Change Tracking | 10:00 | |
| 4. 36. implement data change tracking - Change Data Capture | 7:00 | |
| 5. 37. perform a vulnerability assessment | 5:00 |
| Video Name | Time | |
|---|---|---|
| 1. 38. prepare an operational performance baseline - Metrics Explorer | 5:00 | |
| 2. 38. prepare an operational performance baseline - Other ways | 5:00 | |
| 3. 77. create event notifications for Azure resources | 9:00 | |
| 4. 39. determine sources for performance metrics | 5:00 | |
| 5. 40. interpret performance metrics | 6:00 | |
| 6. 41. assess database performance by using Intelligent Insights | 4:00 | |
| 7. 42. configure and monitor activity and performance | 5:00 |
| Video Name | Time | |
|---|---|---|
| 1. 43, 50. implement index maintenance tasks | 8:00 | |
| 2. 44. implement statistics maintenance tasks | 3:00 | |
| 3. 45, 82. configure database auto-tuning and automate performance tuning | 5:00 | |
| 4. 47. manage storage capacity | 5:00 | |
| 5. 50, 105. assess growth/fragmentation and report on database free space | 5:00 |
| Video Name | Time | |
|---|---|---|
| 1. 48, 60. Query Store - an introduction | 6:00 | |
| 2. 48, 60. configure Query Store to collect performance data, extract query plans | 9:00 | |
| 3. 49. identify sessions that cause blocking | 5:00 | |
| 4. Isolation Levels | 6:00 | |
| 5. 51. assess performance-related database configuration parameters | 6:00 | |
| 6. 57. configure Intelligent Query Processing (IQP) | 10:00 | |
| 7. 39. determine sources for performance metrics | 6:00 | |
| 8. 43. implement index maintenance tasks (Database Engine Tuning Advisor) | 4:00 | |
| 9. 42. Monitor activity using SQL Profile, Extended Events, Performance Dashboard | 8:00 | |
| 10. 54. configure Resource Governor for performance (VM/MI) | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 46. What is Elastic Job Agent? | 6:00 | |
| 2. 46. automate database maintenance tasks | 11:00 | |
| 3. Full, differential and transaction log backups | 5:00 | |
| 4. 89, 92. perform a database restore to a point in time - test DR | 6:00 | |
| 5. 93. configure long-term backup retention | 4:00 |
| Video Name | Time | |
|---|---|---|
| 1. 84. recommend HADR strategy based on RPO/RTO requirements | 7:00 | |
| 2. 86, 87. evaluate Azure-specific HADR solutions | 6:00 | |
| 3. 94. configure replication - Active Geo-replication | 11:00 | |
| 4. 88, 89, 96. configure auto-failover groups and test HA by using failover | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 101. evaluate database health using DMVs - overall resource usage | 5:00 | |
| 2. 101. evaluate database health using DMVs - other topics | 5:00 | |
| 3. 102. evaluate server health using DMVs | 3:00 | |
| 4. 103. perform database consistency checks by using DBCC | 8:00 | |
| 5. 106. review database configuration options | 4:00 |
| Video Name | Time | |
|---|---|---|
| 1. 4-8. Evaluating MIs and VMs based on specific requirements | 6:00 | |
| 2. 10, 53, 56. configure Azure SQL Managed Instance for scale and performance | 5:00 | |
| 3. More about Azure SQL Managed Instance | 5:00 | |
| 4. Accessing Azure SQL Managed Instance in SSMS | 6:00 | |
| 5. 11, 53, 56. configure SQL Server in Azure VMs for scale and performance - Part 1 | 7:00 | |
| 6. 11, 53, 56. configure SQL Server in Azure VMs for scale and performance - Part 2 | 5:00 | |
| 7. Logging into SQL Server on Azure Virtual Machines | 7:00 | |
| 8. 52. Adding additional disks to the Azure Virtual Machine | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 17, 18. evaluate requirements and strategies for the upgrade | 5:00 | |
| 2. 21, 22. implement an online and offline upgrade strategy | 7:00 | |
| 3. 24, 112. create users from Azure AD identities (MIs and VMs) | 7:00 | |
| 4. 111. manage certificates using T-SQL | 4:00 | |
| 5. 26, 113. configure database and object-level permissions using graphical tools | 3:00 | |
| 6. 25, 112, 114. configure security principals (MIs and VMs) | 7:00 | |
| 7. 70, 104. recommend table and index storage including filegroups (MI and VMs) | 11:00 |
| Video Name | Time | |
|---|---|---|
| 1. 76, 79. create event notifications based on metrics | 4:00 | |
| 2. 75. configure notifications for task success/failure/non-completion | 5:00 | |
| 3. 46, 73. manage schedules and automate maintenance jobs | 8:00 | |
| 4. 78. create alerts for server configuration changes | 4:00 | |
| 5. 77. split and filter event notifications for Azure resources | 3:00 |
| Video Name | Time | |
|---|---|---|
| 1. 3, 82. apply patches and updates for hybrid and IaaS deployment | 5:00 | |
| 2. 31. implement Azure Key Vault and disk encryption for Azure VMs | 4:00 | |
| 3. 74. configure multi-server automation | 4:00 | |
| 4. 83. implement policies by using automated evaluation modes | 8:00 |
| Video Name | Time | |
|---|---|---|
| 1. 81. automate backups | 4:00 | |
| 2. 90. perform a database backup with options | 7:00 | |
| 3. 108, 110. database (and transaction log) backups with options in T-SQL code | 7:00 | |
| 4. 91, 92. perform a database restore with options | 12:00 | |
| 5. 109. perform restore of user databases in T-SQL | 3:00 |
| Video Name | Time | |
|---|---|---|
| 1. 94. configure replication - Transactional replication | 9:00 | |
| 2. 85, 86, 87. evaluate HADR for hybrid and Azure-specific deployments | 8:00 | |
| 3. Creating Virtual Machines for Failover Cluster and Always On Availability Group | 5:00 | |
| 4. Connecting Virtual Machines to a Domain | 13:00 | |
| 5. 100. Configure failover cluster instances on Azure VMs | 5:00 | |
| 6. 107. Checking SQL Server Installation and preparing for AO | 6:00 | |
| 7. 98. configure quorum options for a Windows Server Failover Cluster | 8:00 | |
| 8. 95, 97. create an Availability Group | 6:00 | |
| 9. 89, 97. Failover and integrate a database into an Always On Availability Group | 4:00 | |
| 10. 99. configure an Always On Availability Group listener | 2:00 |
Student Feedback
Similar Courses
Only Registered Members can View Training Courses
Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.
Try Free Demo
Try Free Demo
