Logo Microsoft

Data AI: Azure SQL Database Essentials

Trainings-ID:
MPW-SQL-Azure

Wichtige Information

Tranier: Antonio Turkovic

Dieser Kurs wird von einem internationalen Experten von Microsoft Premier Services gehalten und in Kooperation mit ETC angeboten. Für bestehende Microsoft Premier Kunden ist eine Direktbuchung über Ihr Technical Account Management möglich.

Inhalt des Trainings

This offering is designed to provide you with the knowledge and tools to understand the capabilities and usage of cloud databases. You will become familiar with Azure SQL Database concepts, including how to migrate, manage, monitor, and troubleshoot your Azure SQL Database solution.

Objectives
  • Review different purchase models, service tiers compute and hardware generation
  • Discuss the vertical and horizontal scaling options
  • Learn how to monitor, troubleshoot and resolve issues and review migration methods
  • Examine the administration, maintenance, disaster recovery options, security and encryption

Outcomes
  • Move an SQL workload to Azure SQL Database and manage the workload 

Zielgruppen

  • SQL Server Architects
  • Database Administrators
  • DevOps Engineers

Vorkenntnisse

Studetns should meet the following criteria:
  • Experience in SQL Server fundamentals like administration, high availability, performance tuning, troubleshooting
  • Some basic knowledge on Microsoft’s Windows Azure platform

Detail-Inhalte

Day 1
Introduction to Azure SQL Database
  • Azure SQL Database fundamentals and creating a database
Azure SQL Database Administration
  • Various Tools to Manage Azure SQL Database
  • Scaling Azure SQL Databases Up and Down and Azure SQL Database Read Scale-Out

Day 2
Azure SQL Database Business Continuity
  • Business Continuity Features in Azure SQL Database
  • Disaster Recovery Features in Azure SQL Database
Manage Security for Azure SQL Database
  • Implement Azure Active Directory and Advanced Security
  • Implement Firewall Rules and Virtual Networks, Transparent Data Encryption, Always Encrypted, Row Level Security, Dynamic Data Masking, Auditing for Azure SQL Database

Day 3
Monitoring and Tuning Azure SQL Database
  • Monitor Query Performance using Query Performance Insight
  • Azure SQL Database Tuning using Automatic Tuning
  • Monitor Azure SQL Database Performance using Intelligent Insights and Extended Events and configuring alerts
Azure SQL Database Migration & Sync Data
  • Fix database migration compatibility issues
  • Identify the right Azure SQL Database SKU
  • Migrate a compatible SQL Server database to Azure SQL Database
  • Sync data across multiple cloud and on-premises databases

Downloads

Jetzt online buchen

  • 09.04.-11.04.2024 09.04.2024 3 Tage 3T online Online
    Trainer - Antonio Turkovic
    Language - German
    Remote Training

Preise exkl. MwSt.

Sie haben Fragen?

Ihr ETC Support

Kontaktieren Sie uns!

+43 1 533 1777-99

Hidden
Hidden
Hidden