Administering Relational Databases on Microsoft Azure

Course DP-300T00

  • Duration:
    • 4 days

Dates:

  • Implementation guarantee - still places available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
  • Dates with this symbol are bookable both on-site and in the Virtual Classroom.
17.06.2024 - 20.06.2024 Munich, Virtual Classroom
  • 2390 EUR / Person
 German
22.07.2024 - 25.07.2024 Virtual Classroom
  • 2390 EUR / Person
 German
19.08.2024 - 22.08.2024 Cologne, Virtual Classroom
  • 2390 EUR / Person
 German
23.09.2024 - 26.09.2024 Leipzig, Virtual Classroom
  • 2390 EUR / Person
 German
21.10.2024 - 24.10.2024 Berlin, Virtual Classroom
  • 2390 EUR / Person
 German
04.11.2024 - 07.11.2024 Virtual Classroom
  • 2390 EUR / Person
 German
16.12.2024 - 19.12.2024 Virtual Classroom
  • 2390 EUR / Person
 German
06.01.2025 - 09.01.2025 Virtual Classroom
  • 2390 EUR / Person
 German
10.02.2025 - 13.02.2025 Leipzig, Virtual Classroom
  • 2390 EUR / Person
 German
17.03.2025 - 20.03.2025 Cologne, Virtual Classroom
  • 2390 EUR / Person
 German
07.04.2025 - 10.04.2025 Virtual Classroom
  • 2390 EUR / Person
 German
12.05.2025 - 15.05.2025 Munich, Virtual Classroom
  • 2390 EUR / Person
 German
23.06.2025 - 26.06.2025 Berlin, Virtual Classroom
  • 2390 EUR / Person
 German
This course provides students with the knowledge and skills to manage a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases that work with Microsoft PaaS relational database offerings. In addition, it is useful for individuals who develop applications that deliver content from SQL Server databases.

In this course, participants will gain the following skills:
  • Plan, deploy and configure Azure SQL offerings.
  • Monitor database performance and optimise a database and queries to achieve optimal performance
  • Plan and configure a high availability solution
The Azure Database Administrator Role
  • Azure Data Platform Roles
  • Azure database platforms and options
  • SQL Server compatibility levels
  • Azure preview features
Planning and implementing data platform resources
  • Deploying SQL Server using IaaS
  • Deploy SQL Server using PaaS
  • Deploy open source database solutions in Azure
Implement a secure environment
  • Configuring Database Authentication
  • Configuring database authorisation
  • Implement security for data at rest
  • Implement security for data in transit
  • Implement compliance controls for confidential data
Monitor and optimise operational resources
  • Baselines and performance monitoring
  • Main causes of performance problems
  • Configuring resources for optimal performance
  • Configuring user databases
  • Performance related maintenance tasks
Optimising query performance
  • Basic SQL Server query plans
  • Exploring performance-based database design
  • Evaluating performance improvements
Automating tasks
  • Setting up automatic provisioning
  • Defining scheduled tasks
  • Configuring advanced events
  • Manage Azure PaaS resources using automated methods
Plan and implement a high availability and disaster recovery environment
  • High Availability and Disaster Recovery Strategies
  • IaaS platform and database tools for HADR
  • PaaS platform and database tools for HADR
  • Database backup and recovery
The target audience for this course is data professionals who manage data and databases and want to learn more about managing the data platform technologies available in Microsoft Azure. This course is also useful for data architects and application developers who need to understand what data platform technologies are available with Azure and how to work with these technologies through applications.
Successful Azure database administrators start this role with professional database administration experience and technical knowledge of cloud technologies.
Specifically:
  • Working and developing with SQL Server and maintaining SQL Server.
  • Experience with Azure, e.g. provisioning and managing resources
At a minimum, you should be familiar with the information in the following online training before attending the course:
Included in the course price:
- The original Microsoft training materials in English and digital form
- Break catering for face-to-face training: drinks, biscuits and lunch.

We are also happy to conduct this training as an in-house seminar. Please request your individual offer.

The course is offered in German and English.

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!