Best seller!
Best seller!
$27.49
$24.99
DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course
The complete solution to prepare for for your exam with DP-300: Administering Microsoft Azure SQL Solutions certification video training course. The DP-300: Administering Microsoft Azure SQL Solutions certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft Azure Database DP-300 exam dumps, study guide & practice test questions and answers.
127 Students Enrolled
14:06:00 Hours
DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course Exam Curriculum
1
Review prerequisites
5 Lectures
Time 00:38:00
2
Optimize Query Performance
7 Lectures
Time 00:50:00
3
Evaluate performance improvements
5 Lectures
Time 00:42:00
Review prerequisites
-
6:00
1. Getting a free trial of Microsoft Azure
-
11:00
2. Creating Azure SQL Database with sample data
-
11:00
3. Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS
-
6:00
4. Review 6 principal clauses of the SELECT statement
-
4:00
5. Review JOINs
Optimize Query Performance
-
9:00
1. 69. validate data types defined for columns
-
6:00
2. 66. identify data quality issues with duplication of data
-
9:00
3. 67. identify normal form of database tables - Normal Forms 1 to 3
-
7:00
4. 67. identify normal form of database tables - Normal Forms 4 to 5
-
6: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
-
7:00
7. 59. identify problem areas in execution plans
Evaluate performance improvements
-
11:00
1. 63, 68. identify and implement index changes for queries
-
6:00
2. 61. DMVs which gather query performance information
-
8:00
3. 61, 62. determine the appropriate DMVs to gather performance information
-
9:00
4. 64. recommend query construct modifications based on resource usage
-
8:00
5. 65. assess the use of hints for query performance
Plan and Implement Data Platform Resources
-
4:00
1. 1. deploy database offerings on selected platforms
-
8:00
2. 2, 80. configure customized deployment templates
-
8:00
3. 4, 5. evaluate requirements and functional benefits/impact for the deployment
-
5:00
4. 6, 8. evaluate scalability and security aspects
-
8:00
5. 7. HA/DR of the possible database offerings
Configure Azure SQL Database resource for scale and performance
-
5:00
1. 9. configure Azure SQL Database for scale and performance
-
9:00
2. 9, 53, 56. vCore-based purchasing model
-
7:00
3. 9, 53, 56. DTU-based purchasing model, Server vs Serverless
-
6:00
4. 9, 53, 56. Serverless/provisioned and elastic pools
-
4:00
5. 9, 53, 56. Other Azure SQL Database configuration settings
-
4:00
6. 12. calculate resource requirements, including Elastic pool requirements
-
11:00
7. 13, 71. evaluate database partitioning techniques, such as database sharding
-
13:00
8. 72. evaluate the use of compression for tables and indexes
-
12:00
9. 14. set up SQL Data Sync
Evaluate a strategy for migrating to Azure
-
7:00
1. 15, 16. evaluate requirements and strategies for the migration
-
3:00
2. 19, 20. Azure Migrate
-
5:00
3. 19, 20. SQL Server Migration Assistant (SSMA)
-
7:00
4. 19, 20. Data Migration Assistant (DMA)
-
7:00
5. 19, 20. Azure Database Migration Service (DMS)
Configure database AuthN and AuthZ by using platform and database tools
-
8:00
1. 23. configure Azure AD authentication
-
8:00
2. 24. create users from Azure AD identities
-
9:00
3. 25, 113. configure security principals - roles
-
4:00
4. 25, 113. configure security principals - GRANT/REVOKE/DENY
-
5:00
5. 25, 113. configure security principals - individual permissions
-
4:00
6. 25, 113. configure security principals - the ALL permission
-
5:00
7. 114. configure permissions by using custom roles
-
3:00
8. 27. apply principle of least privilege for all securables
Implement security for data at rest and in transit
-
4:00
1. 28. implement Transparent Data Encryption (TDE)
-
10:00
2. 29, 33. implement object-level encryption and Always Encrypted
-
9:00
3. 29, 33. More about Always Encrypted
-
2:00
4. Always Encrypted versus Transparent Data Encryption
-
8:00
5. 30. implement Dynamic Data Masking
-
8:00
6. 32. configure server and database-level firewall rules
Implement compliance controls for sensitive data
-
6:00
1. 34. apply a data classification strategy
-
9:00
2. 35. configure server and database audits
-
10:00
3. 36. implement data change tracking - Change Tracking
-
7:00
4. 36. implement data change tracking - Change Data Capture
-
5:00
5. 37. perform a vulnerability assessment
Monitor activity and performance
-
5:00
1. 38. prepare an operational performance baseline - Metrics Explorer
-
5:00
2. 38. prepare an operational performance baseline - Other ways
-
9:00
3. 77. create event notifications for Azure resources
-
5:00
4. 39. determine sources for performance metrics
-
6:00
5. 40. interpret performance metrics
-
4:00
6. 41. assess database performance by using Intelligent Insights
-
5:00
7. 42. configure and monitor activity and performance
Implement performance-related maintenance tasks
-
8:00
1. 43, 50. implement index maintenance tasks
-
3:00
2. 44. implement statistics maintenance tasks
-
5: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
Identify performance-related issues
-
6:00
1. 48, 60. Query Store - an introduction
-
9:00
2. 48, 60. configure Query Store to collect performance data, extract query plans
-
5:00
3. 49. identify sessions that cause blocking
-
6:00
4. Isolation Levels
-
6:00
5. 51. assess performance-related database configuration parameters
-
10:00
6. 57. configure Intelligent Query Processing (IQP)
Automate tasks and Perform backup and restore a database by using database tools
-
6:00
1. 46. What is Elastic Job Agent?
-
11:00
2. 46. automate database maintenance tasks
-
5:00
3. Full, differential and transaction log backups
-
6:00
4. 89, 92. perform a database restore to a point in time - test DR
-
4:00
5. 93. configure long-term backup retention
Recommend an HADR strategy for a data platform solution
-
7:00
1. 84. recommend HADR strategy based on RPO/RTO requirements
-
6:00
2. 86, 87. evaluate Azure-specific HADR solutions
-
11:00
3. 94. configure replication - Active Geo-replication
-
8:00
4. 88, 89, 96. configure auto-failover groups and test HA by using failover
Perform Administration by Using T-SQL
-
5:00
1. 101. evaluate database health using DMVs - overall resource usage
-
5:00
2. 101. evaluate database health using DMVs - other topics
-
3:00
3. 102. evaluate server health using DMVs
-
8:00
4. 103. perform database consistency checks by using DBCC
-
4:00
5. 106. review database configuration options
Introduction to Virtual Machines and Managed Instances (MI)
-
6:00
1. 4-8. Evaluating MIs and VMs based on specific requirements
-
5:00
2. 10, 53, 56. configure Azure SQL Managed Instance for scale and performance
-
5:00
3. More about Azure SQL Managed Instance
-
6:00
4. Accessing Azure SQL Managed Instance in SSMS
-
7:00
5. 11, 53, 56. configure SQL Server in Azure VMs for scale and performance - Part 1
-
5:00
6. 11, 53, 56. configure SQL Server in Azure VMs for scale and performance - Part 2
-
7:00
7. Logging into SQL Server on Azure Virtual Machines
-
8:00
8. 52. Adding additional disks to the Azure Virtual Machine
Upgrade strategy, configure database authentication, and filegroups
-
5:00
1. 17, 18. evaluate requirements and strategies for the upgrade
-
7: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)
-
4:00
4. 111. manage certificates using T-SQL
-
3:00
5. 26, 113. configure database and object-level permissions using graphical tools
-
7:00
6. 25, 112, 114. configure security principals (MIs and VMs)
-
11:00
7. 70, 104. recommend table and index storage including filegroups (MI and VMs)
Evaluate and implement an alert and notification strategy
-
4:00
1. 76, 79. create event notifications based on metrics
-
5:00
2. 75. configure notifications for task success/failure/non-completion
-
8:00
3. 46, 73. manage schedules and automate maintenance jobs
-
4:00
4. 78. create alerts for server configuration changes
-
3:00
5. 77. split and filter event notifications for Azure resources
Identify performance-related issues
-
6:00
1. 39. determine sources for performance metrics
-
4:00
2. 43. implement index maintenance tasks (Database Engine Tuning Advisor)
-
8:00
3. 42. Monitor activity using SQL Profile, Extended Events, Performance Dashboard
-
8:00
4. 54. configure Resource Governor for performance (VM/MI)
Create scheduled tasks
-
5:00
1. 3, 82. apply patches and updates for hybrid and IaaS deployment
-
4:00
2. 31. implement Azure Key Vault and disk encryption for Azure VMs
-
4:00
3. 74. configure multi-server automation
-
8:00
4. 83. implement policies by using automated evaluation modes
Perform backup and restore a database by using database tools - VMs
-
4:00
1. 81. automate backups
-
7: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
-
12:00
4. 91, 92. perform a database restore with options
-
3:00
5. 109. perform restore of user databases in T-SQL
Recommend and test HA/DR strategies, and configure HA/DR
-
9:00
1. 94. configure replication - Transactional replication
-
8:00
2. 85, 86, 87. evaluate HADR for hybrid and Azure-specific deployments
-
5:00
3. Creating Virtual Machines for Failover Cluster and Always On Availability Group
-
13:00
4. Connecting Virtual Machines to a Domain
-
5:00
5. 100. Configure failover cluster instances on Azure VMs
-
6:00
6. 107. Checking SQL Server Installation and preparing for AO
-
8:00
7. 98. configure quorum options for a Windows Server Failover Cluster
-
6:00
8. 95, 97. create an Availability Group
-
4:00
9. 89, 97. Failover and integrate a database into an Always On Availability Group
-
2:00
10. 99. configure an Always On Availability Group listener
About DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course
DP-300: Administering Microsoft Azure SQL Solutions certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's DP-300: Administering Microsoft Azure SQL Solutions video training course for passing certification exams is the only solution which you need.
Pass Microsoft Azure Database DP-300 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
$39.99
DP-300 Premium Bundle
$69.98
$109.97
- Premium File 369 Questions & Answers. Last update: May 26, 2025
- Training Course 130 Video Lectures
- Study Guide 672 Pages
$109.97
$69.98
| Free DP-300 Exam Questions & Microsoft DP-300 Dumps | ||
|---|---|---|
| Microsoft.certkey.dp-300.v2025-04-15.by.george.118q.ete |
Views: 229
Downloads: 466
|
Size: 2.89 MB
|
| Microsoft.test-king.dp-300.v2021-07-30.by.maya.105q.ete |
Views: 303
Downloads: 1639
|
Size: 3.1 MB
|
| Microsoft.test-inside.dp-300.v2021-06-08.by.axel.84q.ete |
Views: 264
Downloads: 1647
|
Size: 1.74 MB
|
| Microsoft.test4prep.dp-300.v2021-02-26.by.alfie.49q.ete |
Views: 367
Downloads: 1746
|
Size: 1.58 MB
|
| Microsoft.pass4sures.dp-300.v2020-09-09.by.scarlett.24q.ete |
Views: 696
Downloads: 2065
|
Size: 517.94 KB
|
Student Feedback
5.0
Excellent
Only Registered Members
Can View Online Video Courses
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
