Video Course
BEST SELLER

DP-300: Administering Microsoft Azure SQL Solutions Certification Video Training Course

Looking for studying for DP-300: Administering Microsoft Azure SQL Solutions certification training course. Our DP-300 certification video training course training course is your number one assistant. Pass with our DP-300: Administering Microsoft Azure SQL Solutions certification training course on the first try and become a certified professional in no time.

  • 118 Students Enrolled
  • 130 Lectures
  • 14 Hours
  • 5.0 Rating
$38.49
$34.99

Curriculum For This 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

  • Optimize Query Performance

    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

  • Evaluate performance improvements

    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

  • Plan and Implement Data Platform Resources

    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

  • Configure Azure SQL Database resource for scale and performance

    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

  • Evaluate a strategy for migrating to Azure

    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

  • Configure database AuthN and AuthZ by using platform and database tools

    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

  • Implement security for data at rest and in transit

    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

  • Implement compliance controls for sensitive data

    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

  • Monitor activity and performance

    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

  • Implement performance-related maintenance tasks

    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

  • Identify performance-related issues

    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

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

    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

  • Recommend an HADR strategy for a data platform solution

    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

  • Perform Administration by Using T-SQL

    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

  • Introduction to Virtual Machines and Managed Instances (MI)

    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

  • Upgrade strategy, configure database authentication, and filegroups

    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

  • Evaluate and implement an alert and notification strategy

    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

  • Create scheduled tasks

    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

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

    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

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

    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

  1. 51%
  2. 49%
  3. 0%
  4. 0%
  5. 0%

Excellent Overall Rating

5.0

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login