Administering Relational Databases on Microsoft Azure Video Course

DP-300: Administering Relational Databases on Microsoft Azure

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 Relational Databases on Microsoft Azure credential with ease.

# of Students
108
# of Lectures
130
Course Length
14 h
Course Rating
5.0
Price $27.49
Today $24.99

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

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
5.0
Rating: 5.0
Overall Rating: Good.

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.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • AAFM India
  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • Alibaba
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • CertNexus
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HashiCorp
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • NetSuite
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Pulse Secure
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • Slack
  • SNIA
  • Snowflake
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Tableau
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Winter Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address