DP-300 Administering Microsoft Azure SQL Solutions

Course Description

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Prerequisites

Required

  • Working with, maintaining, and developing with SQL Server
  • Experience with Azure, such as deploying and managing resources

Recommended


Curriculum for this course

21 Lessons
Module 1 : Introduction to Azure database administration
2 Lessons
  • Prepare to maintain SQL databases on Azure
    .
  • Explore performance-based design
    .
Module 2 : Plan and implement data platform resources
5 Lessons
  • Deploy IaaS solutions with Azure SQL
    .
  • Deploy PaaS solutions with Azure SQL
    .
  • Evaluate strategies for migrating to Azure SQL
    .
  • Migrate SQL Server workloads to Azure SQL Database
    .
  • Migrate SQL Server workloads to Azure SQL Managed Instance
    .
Module 3 : Implement a secure environment for a database service
3 Lessons
  • Configure database authentication and authorization
    .
  • Protect data in-transit and at rest
    .
  • Implement compliance controls for sensitive data
    .
Module 4 : Monitor and optimize operational resources in Azure SQL
3 Lessons
  • Describe performance monitoring
    .
  • Configure SQL Server resources for optimal performance
    .
  • Configure databases for optimal performance
    .
Module 5 : Optimize query performance in Azure SQL
2 Lessons
  • Explore query performance optimization
    .
  • Evaluate performance improvements
    .
Module 6 : Automate database tasks for Azure SQL
3 Lessons
  • Automate deployment of database resources
    .
  • Create and manage SQL Agent jobs
    .
  • Manage Azure PaaS tasks using automation
    .
Module 7 : Plan and implement a high availability and disaster recovery environment
3 Lessons
  • Describe high availability and disaster recovery strategies
    .
  • Explore IaaS and PaaS solutions for high availability and disaster recovery
    .
  • Back up and restore databases
    .

Drop us a message for any query

For more information about our courses, get in touch
with Alchemy contacts

Course rating

Star

90%

Star

80%

Star

65%

Star

60%

Reviews

  • Ruma Sriwastav

    Cover all my needs

    The course identify things we want to change and then figure out the things that need to be done to create the desired outcome. The course helped me in clearly define problems and generate a wider variety of quality solutions. Support more structures analysis of options.

All Courses

Skills Offered

Emerging Skills Offered by Alchemy for 2024-2025

Image
Image

Data Science & Analytics
  • Advanced Data Engineering (e.g., Snowflake, Databricks)
  • Real-Time Data Streaming (e.g., Kafka, Flink)
  • Predictive Analytics with AI/ML Models
  • Advanced Business Intelligence Tools (e.g., Power BI, Tableau)
Image

Emerging Programming Frameworks
  • Quantum Computing Basics (IBM Qiskit, Google Cirq)
  • Web3 Development: Solidity, Smart Contracts
  • Low-code/No-code Platforms (OutSystems, Mendix)
Image

Infrastructure Modernization
  • Software-Defined Networking (SDN) and NFV
  • Advanced Virtualization (Citrix, VMware updates)
  • Hybrid and Edge Computing
Image

Soft Skills and Leadership in Tech
  • Agile Transformation and Leadership
  • Design Thinking for Problem Solving
  • Leading AI-Driven Innovation
Image

AI & Machine Learning
  • Generative AI (e.g., ChatGPT, Bard, MidJourney integrations)
  • Machine Learning Operations (MLOps)
  • Advanced NLP and Speech Recognition
  • AI for Edge Computing
Image

Cloud Technologies
  • Multi-Cloud Management: Azure, AWS, GCP integrations
  • Cloud-Native Development: Kubernetes, Docker, Serverless Architectures
  • AI and ML integration in Cloud Platforms
  • FinOps: Cloud Cost Management
Image

Cybersecurity
  • Zero Trust Architecture (e.g., Illumio)
  • Incident Response and Threat Intelligence
  • Cloud Security (AWS, Azure, and GCP-focused)
  • Advanced Penetration Testing and Ethical Hacking
Image

DevOps and DevSecOps
  • Infrastructure as Code (IaC) with Terraform and Ansible
  • GitOps and Continuous Integration/Continuous Delivery (CI/CD)
  • Security in DevOps Pipelines
Image

Data Science & Analytics
  • Advanced Data Engineering (e.g., Snowflake, Databricks)
  • Real-Time Data Streaming (e.g., Kafka, Flink)
  • Predictive Analytics with AI/ML Models
  • Advanced Business Intelligence Tools (e.g., Power BI, Tableau)
Image

Emerging Programming Frameworks
  • Quantum Computing Basics (IBM Qiskit, Google Cirq)
  • Web3 Development: Solidity, Smart Contracts
  • Low-code/No-code Platforms (OutSystems, Mendix)
Image

Infrastructure Modernization
  • Software-Defined Networking (SDN) and NFV
  • Advanced Virtualization (Citrix, VMware updates)
  • Hybrid and Edge Computing
Image

Soft Skills and Leadership in Tech
  • Agile Transformation and Leadership
  • Design Thinking for Problem Solving
  • Leading AI-Driven Innovation
Image

AI & Machine Learning
  • Generative AI (e.g., ChatGPT, Bard, MidJourney integrations)
  • Machine Learning Operations (MLOps)
  • Advanced NLP and Speech Recognition
  • AI for Edge Computing
Image

Cloud Technologies
  • Multi-Cloud Management: Azure, AWS, GCP integrations
  • Cloud-Native Development: Kubernetes, Docker, Serverless Architectures
  • AI and ML integration in Cloud Platforms
  • FinOps: Cloud Cost Management
Image

Cybersecurity
  • Zero Trust Architecture (e.g., Illumio)
  • Incident Response and Threat Intelligence
  • Cloud Security (AWS, Azure, and GCP-focused)
  • Advanced Penetration Testing and Ethical Hacking
Image

DevOps and DevSecOps
  • Infrastructure as Code (IaC) with Terraform and Ansible
  • GitOps and Continuous Integration/Continuous Delivery (CI/CD)
  • Security in DevOps Pipelines