> Formations > Implement scalable database solutions using Azure SQL (Microsoft DP-300)
Course : Implement scalable database solutions using Azure SQL (Microsoft DP-300)DP-300T00-A official course, exam preparation
Practical course - 4d
- 28h00 - Ref. DAZ
|
Download in PDF format
Share this course by email
 | Deploying and configuring SQL databases in Azure |
| Secure databases and manage access |
| Backup, restore and ensure high availability |
| Monitor performance and optimize requests |
| Automate administration tasks |
| Manage data updates and compliance |
Intended audience
Data professionals, architects and developers wishing to learn how to manage the databases and technologies of the Azure data platform.
Prerequisites
Mastery of SQL, notions of database administration and basic knowledge of Azure. Ideally, you should have taken the training course "Azure, fundamentals" (ref. MKV).
Practical details
Teaching methods
Training in French. Official course material in digital format and in English. Good understanding of written English.
Course schedule
1 Plan and implement data platform resources
- Prepare maintenance of SQL Server databases on Azure.
- Deploy IaaS solutions with Azure SQL.
- Deploy PaaS solutions with Azure SQL.
- Migrate SQL Server workloads to Azure SQL Database.
- Migrate SQL Server workloads to Azure SQL Managed Instance.
2 Setting up a secure environment for a database service
- Configure database authentication and authorization.
- Protect data in transit and at rest.
- Implement compliance controls for sensitive data.
3 Monitor and optimize operational resources in Azure SQL Server
- Describe performance monitoring.
- Configure SQL Server resources for optimum performance.
- Configure databases for optimum performance.
4 Optimizing query performance in Azure SQL Server
- Explore query performance optimization.
- Explore performance-oriented database design.
- Evaluate performance improvements.
5 Automate SQL Server tasks on Azure
- Automate database deployment.
- Create and manage SQL Agent jobs.
- Automate Azure PaaS tasks.
Options
Certification : 200 € HT
Successful completion of the DP-300 exam leads to certification as an "Azure Database Administrator Associate".
Comment passer votre examen ?
Comment passer votre examen ?
The certification option comes in the form of a voucher and practice tests that will allow you to practise and take the exam at the end of the training course.
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
THIERRY E.
21/10/25
4 / 5
The only thing that wasn't so good: Some of the guides in go deploy weren't quite up to date.
VERONIKA P.
21/10/25
5 / 5
The trainer knows the field very well, is patient and explains things well.
NUNY ALFREDO N.
10/06/25
5 / 5
The course was well run, with the necessary timing to ensure that the lessons were properly assimilated.
PARTICIPANTS
Data professionals, architects and developers wishing to learn how to manage the databases and technologies of the Azure data platform.
PREREQUISITES
Mastery of SQL, notions of database administration and basic knowledge of Azure. Ideally, you should have taken the training course "Azure, fundamentals" (ref. MKV).
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Data professionals, architects and developers wishing to learn how to manage the databases and technologies of the Azure data platform.
PREREQUISITES
Mastery of SQL, notions of database administration and basic knowledge of Azure. Ideally, you should have taken the training course "Azure, fundamentals" (ref. MKV).
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Dates and locations
Dernières places
Date garantie en présentiel ou à distance
Session garantie