Training Microsoft

Training goals

code: DP-300T00 | version: A

This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings.

 

Audience Profile:
The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers.

 

Skills earned upon completion:
Skills earned upon completion were not available in the Microsoft source.

Conspect Show list

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

Additional information

Prerequisites

Familiarity with on-premises virtualization technologies, network configuration (TCP/IP, DNS, VPNs, firewalls), ability to create an on-premises SQL Server database, ability to write T-SQL code at a basic level, and experience creating resources using the Azure portal.
Difficulty level
Duration 4 days
Certificate

The participants will obtain certificates signed by Microsoft (course completion). This course will help prepare you for the Microsoft Certified: Azure Database Administrator Associate certification exam (Exam DP-300), which is available through the Pearson VUE test centers.
Trainer

Microsoft Certified Trainer (MCT)

Other training Microsoft | Data & AI

Microsoft show more courses
Training thematically related

Cloud and DevOps

Architecting | AWS

DevOps | AWS

Cloud Operations | AWS

AI and Machine Learning | AWS

AWS Jam and AWS Jam Bundle | AWS

Containers | AWS

Migration and Transfer | AWS

Network and Content Delivery | AWS

Storage | AWS

Cloud Essentials | AWS

Exams | AWS

AWS Skill Builder | AWS

AWS Blended Learning Bundle | AWS

AWS Discovery Days | AWS

Citrix Virtual Apps and Desktops | Citrix

Cloud-Native (Kubernetes) | Component Soft

OpenStack | Component Soft

Cloud+ | CompTIA

CloudNetX | CompTIA

Server+ | CompTIA

A+ | CompTIA

Cloud Essentials | CompTIA

Foundations | Google Cloud

Cloud Infrastructure | Google Cloud

Application Modernization | Google Cloud

Generative AI | Google Cloud

Data Engineering | Google Cloud

Kubernetes | Google Cloud

Machine Learning and Artificial Intelligence | Google Cloud

Networking and Security | Google Cloud

FinOps | Google Cloud

Apigee and API Management | Google Cloud

Storage | Huawei

Infrastructure | Microsoft

Data & AI | Microsoft

Digital and App Innovation | Microsoft

Azure | Microsoft

Kubernetes | SUSE

SUSE Edge Platform | SUSE

Kubernetes | The Linux Foundation

E-learning | The Linux Foundation

Exam | The Linux Foundation

Bundle (e-learning + exam) | The Linux Foundation

Data Analytics and Databases

AI and Machine Learning | AWS

Data Analytics | AWS

Exams | AWS

AWS Discovery Days | AWS

Cloudera Administrator | Cloudera

Cloudera Data Analyst | Cloudera

Cloudera Data Developer | Cloudera

Data+ | CompTIA

DataSys+ | CompTIA

DataAI (formerly DataX) | CompTIA

Foundations | Google Cloud

Data Analytics | Google Cloud

Data Engineering | Google Cloud

Data & AI | Microsoft

Microsoft SQL Server | Microsoft

SharePoint | Microsoft

Contact form

Please fill form below to obtain more info about this training.






* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

PRICE 1900 EUR

FORM OF TRAINING ?

 

TRAINING MATERIALS ?

 

EXAM ?

 

SELECT TRAINING DATE

    • General information
    • Guaranteed dates
    • Last minute (-10%)
    • Language of the training
    • English
    • General information
    • Guaranteed dates
    • Last minute (-10%)
    • Language of the training
    • English
    • General information
    • Guaranteed dates
    • Last minute (-10%)
    • Language of the training
    • English
Book a training appointment
close

Traditional training

Sessions organised at Compendium CE are usually held in our locations in Kraków and Warsaw, but also in venues designated by the client. The group participating in training meets at a specific place and specific time with a coach and actively participates in laboratory sessions.

Dlearning training

You may participate from at any place in the world. It is sufficient to have a computer (or, actually a tablet, or smartphone) connected to the Internet. Compendium CE provides each Distance Learning training participant with adequate software enabling connection to the Data Center. For more information, please visit dlearning.eu site

close

Paper materials

Traditional materials: The price includes standard materials issued in the form of paper books, printed or other, depending on the arrangements with the manufacturer.

Electronic materials

Electronic materials: These are electronic training materials that are available to you based on your specific application: Skillpipe, eVantage, etc., or as PDF documents.

Ctab materials

Ctab materials: the price includes ctab tablet and electronic training materials or traditional training materials and supplies provided electronically according to manufacturer's specifications (in PDF or EPUB form). The materials provided are adapted for display on ctab tablets. For more information, check out the ctab website.

Upcoming Microsoft training

Training schedule Microsoft