Practice Exams:

View All

DP-300: Administering Microsoft Azure SQL Solutions

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The DP-300 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft DP-300 test with flying colors.

Rating

4.37

Students

144

Duration

14:06:00 h

$16.49

$14.99

Curriculum for DP-300 Certification Video Course

Review prerequisites

5 Lectures

Time 00:38:00

Optimize Query Performance

7 Lectures

Time 00:50:00

Evaluate performance improvements

5 Lectures

Time 00:42:00

Plan and Implement Data Platform Resources

5 Lectures

Time 00:33:00

Configure Azure SQL Database resource for scale and performance

9 Lectures

Time 01:11:00

Evaluate a strategy for migrating to Azure

5 Lectures

Time 00:29:00

Configure database AuthN and AuthZ by using platform and database tools

8 Lectures

Time 00:46:00

Implement security for data at rest and in transit

6 Lectures

Time 00:41:00

Implement compliance controls for sensitive data

5 Lectures

Time 00:37:00

Monitor activity and performance

7 Lectures

Time 00:39:00

Implement performance-related maintenance tasks

5 Lectures

Time 00:26:00

Identify performance-related issues

6 Lectures

Time 00:42:00

Automate tasks and Perform backup and restore a database by using database tools

5 Lectures

Time 00:32:00

Recommend an HADR strategy for a data platform solution

4 Lectures

Time 00:32:00

Perform Administration by Using T-SQL

5 Lectures

Time 00:25:00

Introduction to Virtual Machines and Managed Instances (MI)

8 Lectures

Time 00:49:00

Upgrade strategy, configure database authentication, and filegroups

7 Lectures

Time 00:44:00

Evaluate and implement an alert and notification strategy

5 Lectures

Time 00:24:00

Identify performance-related issues

4 Lectures

Time 00:26:00

Create scheduled tasks

4 Lectures

Time 00:21:00

Perform backup and restore a database by using database tools - VMs

5 Lectures

Time 00:33:00

Recommend and test HA/DR strategies, and configure HA/DR

10 Lectures

Time 01:06:00

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	Time
1. 39. determine sources for performance metrics	6:00
2. 43. implement index maintenance tasks (Database Engine Tuning Advisor)	4:00
3. 42. Monitor activity using SQL Profile, Extended Events, Performance Dashboard	8:00
4. 54. configure Resource Governor for performance (VM/MI)	8:00

Name of Video	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

Name of Video	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

Name of Video	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

Microsoft Azure Database DP-300 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft Azure Database DP-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

$69.97

$49.99

DP-300 Premium Bundle

Premium File: 369 Questions & Answers. Last update: Apr 10, 2025
Training Course: 130 Video Lectures
Study Guide: 672 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

DP-300 Premium Bundle

Premium File: 369 Questions & Answers. Last update: Apr 10, 2025
Training Course: 130 Video Lectures
Study Guide: 672 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

$69.97

$49.99

Microsoft DP-300 Training Course

Want verified and proven knowledge for Administering Microsoft Azure SQL Solutions? Believe it's easy when you have ExamSnap's Administering Microsoft Azure SQL Solutions certification video training course by your side which along with our Microsoft DP-300 Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.

Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap Administering Microsoft Azure SQL Solutions certification video training course that goes in line with the corresponding Microsoft DP-300 exam dumps, study guide, and practice test questions & answers.

Purchase Individually