close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course Information

Administering Relational Databases on Microsoft Azure DP300 Course Outline 

Module 1: Role of the Azure Database Administrator

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features

Lab: Using the Azure Portal and SQL Server Management Studio

  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup

Module 2: Plan and Implement Data Platform Resources

  • Deploying SQL Server Using IaaS and PaaS
  • Deploying Open Source Database Solutions on Azure

Lab: Deploying Azure SQL Database

  • Deploy a VM Using an ARM Template
  • Configure Resources Needed Prior to Creating a Database
  • Deploy an Azure SQL Database
  • Register Azure SQL Database Instance in Azure Data Studio and Validate Connectivity
  • Deploy PostgreSQL or MySQL Using Client Tool to Validate Connectivity

Module 3: Implement a Secure Environment

  • Configure
  • Database Authentication
  • Database Authorisation
  • Implement 
  • Security for Data at Rest
  • Security for Data in Transit
  • Compliance Controls for Sensitive Data

Lab: Implement a Secure Environment

  • Configure a Server-Based Firewall Rule Using Azure Portal
  • Authorise Access to Azure SQL Database with Azure Active Directory
  • Enable Advanced Data Security and Data Classification
  • Manage Access to Database Objects

Module 4: Monitor and Optimise Operational Resources

  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-Related Maintenance Tasks

Lab: Monitor and Optimise Resources

  • Isolate CPU Problems
  • Use Query Store Observe Blocking Problems
  • Detect and Correct Fragmentation Issues

Module 5: Optimise Query Performance

  • Understand SQL Server Query Plans
  • Explore Performance-Based Database Design
  • Evaluate Performance Improvements

Lab: Query Performance Troubleshooting

  • Identify Issues with Database Design Adventureworks2017
  • Isolate Problem Areas in Poorly Performing Queries in Adventureworks2017
  • Use Query Store to Detect and Handle Regression in Adventureworks2017
  • Use Query Hints to Impact Performance in Adventureworks2017

Module 6: Automation of Tasks

  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS Resources Using Automated Methods

Lab: Automating Tasks

  • Deploy an Azure Template from a Quickstart Template on GitHub
  • Configure Notifications Based on Performance Metrics
  • Deploy an Azure Automation Runbook (or Elastic Job) to Rebuild Indexes on an Azure SQL Database

Module 7: 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

Lab: Plan and Implement a High Availability and Disaster Recovery Environment

  • Create an Always-On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL

Show moredowndown

Prerequisites 

In this Administering Relational Databases on Microsoft Azure course, there are no formal requirements. Although, having a basic understanding of relational database and Microsoft Azure can be very beneficial for the delegates. 

Audience 

This Administering Relational Databases on Microsoft Azure course (DP300) is ideal for anyone who wants to learn managing Relational Database on Azure. However, this course can be more beneficial for individuals working as: 

  • Database Administrators 
  • Data Engineers
  • Database Developers 

Individuals in these professions can improve or add on to their skills for new career opportunities by getting this Administering Relational Databases on Microsoft Azure (DP 300) certification by Microsoft. 

Administering Relational Databases on Microsoft Azure DP300​ Course Overview 

A relational database is a set of information that organises data points which has some particular relation to each other. In the relational database, the data is written in indexes and tables which separates it from the physical storage and allows administrators to manage the physical data storage without upsetting the logical data structure.

A Relational Database on Azure presents its administrator with all the necessary tools to maintain and execute the functioning of hybrid data and cloud-native service platform solutions developed on Azure data services and Microsoft SQL Server. Azure Database administrator uses several methods and tools to complete routine procedures, with the practical understanding of using T-SQL for management purposes. Microsoft Azure administrators are responsible for managing, securing, monitor, provide, and optimising modern relational database solutions. Learning these skills will help individuals to pursue their career as Database Administrator in multinational firms.

This 4-day Administering Relational Databases on Microsoft Azure training provides delegates with practical working knowledge of managing Relational Database on Microsoft Azure services. They will learn things like planning and implementing data platform resources, devising a secure environment, monitoring and optimising operational resources, etc. Delegates will also learn about High Availability and Disaster Recovery Strategies (HARD) for deploying both Infrastructure as a Service (IaaS) and Platform as a Service (PaaS). Our highly-skilled, experienced, and technically sound trainers will teach this course.    

What will you learn:

  • Understand the role of Azure database administrator 
  • Deploying resources using manual methods 
  • Configuring data-at-rest and data-in-transition encryption
  • Configuring a user database for optimal performance
  • Deploying resources using automated deployment scripts 

At the end of this training course, delegates will be able to plan, deploy and configure Azure SQL offering for a relational database. They will also be able to monitor and optimise database performance. Delegates will be able to configure database resources and deploying resources using scripts and become a skilled Azure Relational Database Administrator.  

Show moredowndown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

best_trainers

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

value_for_money

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

tailored_learning_experience

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

monitor_progress

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Frequently asked questions

FAQ's

A relational database is a set of information organised data points which has a particular relation to each other.
In this Administering Relational Databases on Microsoft Azure course, there are no formal requirements. Although, having a basic understanding of relational database and Microsoft Azure can be very beneficial for the delegates.
This Administering Relational Databases on Microsoft Azure course (DP300) is ideal for anyone who wants to learn managing Relational Database on Azure.
Microsoft Azure is an expanding set of the cloud services provider that helps organisations to overcome their business challenges.
T-SQL and stands for Transact-SQL and is an extension of SQL (Structured Query Language), and it is a set of programme extensions from Microsoft and Sybase as well as adds several new functions and features to SQL.
This course is 4 days.
Azure offers of fully manageable NoSQL, relational, and in-memory databases, spanning exclusive and open-source engines, to fit the requirements of the developers.
HARD stands for High Availability and Disaster Recovery are the set of fail-safe solutions in the case the on-premises application has any failure. It is a combination of two terms High Availability (HA) and Disaster Recovery (DR).
IaaS stands for Infrastructure as a Service and is the form of cloud computing service in which virtual computing resources are made available over the internet for business and personal uses.
The price for Administering Relational Databases on Microsoft Azure DP300 certification in the United Kingdom starts from £2295
The Knowledge Academy is the Leading global training provider in the world for Administering Relational Databases on Microsoft Azure DP300.

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Azure Training

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Microsoft Azure Training?

backBack to course information

Microsoft Azure Database Administrator Associate

Save upto 40%
2 courses
Included courses:

Administering Relational Databases on Microsoft Azure DP300£3595

Microsoft Azure Data Fundamentals DP900£1995

Total without package:  £5590

Package price:  £3395 (Save £2195)

Purchase now