DP-300: Administering Microsoft Azure SQL Solutions Exam – Complete Certification Training Course & Exam Dumps

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.

132 Students Enrolled 130 Lectures 14:06:00 Hours

Curriculum For This Course

Review prerequisites

5Lectures

Time 00:38:00

Optimize Query Performance

7Lectures

Time 00:50:00

Evaluate performance improvements

5Lectures

Time 00:42:00

Plan and Implement Data Platform Resources

5Lectures

Time 00:33:00

Configure Azure SQL Database resource for scale and performance

9Lectures

Time 01:11:00

Evaluate a strategy for migrating to Azure

5Lectures

Time 00:29:00

Configure database AuthN and AuthZ by using platform and database tools

8Lectures

Time 00:46:00

Implement security for data at rest and in transit

6Lectures

Time 00:41:00

Implement compliance controls for sensitive data

5Lectures

Time 00:37:00

Monitor activity and performance

7Lectures

Time 00:39:00

Implement performance-related maintenance tasks

5Lectures

Time 00:26:00

Identify performance-related issues

6Lectures

Time 00:42:00

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

5Lectures

Time 00:32:00

Recommend an HADR strategy for a data platform solution

4Lectures

Time 00:32:00

Perform Administration by Using T-SQL

5Lectures

Time 00:25:00

Introduction to Virtual Machines and Managed Instances (MI)

8Lectures

Time 00:49:00

Upgrade strategy, configure database authentication, and filegroups

7Lectures

Time 00:44:00

Evaluate and implement an alert and notification strategy

5Lectures

Time 00:24:00

Identify performance-related issues

4Lectures

Time 00:26:00

Create scheduled tasks

4Lectures

Time 00:21:00

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

5Lectures

Time 00:33:00

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

10Lectures

Time 01:06:00

Review prerequisites
	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

Optimize Query Performance
	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

Evaluate performance improvements
	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

Plan and Implement Data Platform Resources
	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

Configure Azure SQL Database resource for scale and performance
	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

Evaluate a strategy for migrating to Azure
	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

Configure database AuthN and AuthZ by using platform and database tools
	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

Implement security for data at rest and in transit
	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

Implement compliance controls for sensitive data
	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

Monitor activity and performance
	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

Implement performance-related maintenance tasks
	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

Identify performance-related issues
	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

Automate tasks and Perform backup and restore a database by using database tools
	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

Recommend an HADR strategy for a data platform solution
	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

Perform Administration by Using T-SQL
	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

Introduction to Virtual Machines and Managed Instances (MI)
	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

Upgrade strategy, configure database authentication, and filegroups
	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

Evaluate and implement an alert and notification strategy
	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

Identify performance-related issues
	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

Create scheduled tasks
	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

Perform backup and restore a database by using database tools - VMs
	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

Recommend and test HA/DR strategies, and configure HA/DR
	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