Is the training Qualiopi certified?

Yes, Learni is a Qualiopi-certified training organization. This certification guarantees the quality of our courses and enables funding through OPCO and other mechanisms.

How can I fund my training?

Our courses are eligible for OPCO funding. Learni supports you through the funding process. A personalized quote is available upon request.

What are the prerequisites for this training?

The prerequisites for the Training Azure SQL Database - Administer and Optimize Performance training are: Solid knowledge of SQL Server T-SQL, basics of Azure (portal, resources, IAM). A preliminary interview validates your eligibility.

Is the training available in person?

Yes, the Training Azure SQL Database - Administer and Optimize Performance training is available in in-person. The format can be adapted to your needs (inter, intra, custom).

Training Azure SQL Database - Administer and Opt... | Learni

The story of Learni

Founded by passionate advocates of learning and innovation, Learni set out to make professional training accessible to everyone, everywhere in the world. Our team works in the largest cities such as Paris, Lyon, Marseille, and internationally, to support talents and organizations in their skills development.

Configure your training

Response within 24hNo commitment100% free

7 spots remaining for the next session

FormatParticipantsDateDetails

Which format do you prefer?

Methods, approaches, and teaching resources

The Training Azure SQL Database - Administer and Optimize Performance training is delivered in-person or remotely (blended-learning, e-learning, virtual classroom, remote in-person). At Learni, a Qualiopi-certified training organization, each program is designed to maximize skills acquisition, regardless of the training mode chosen.

The trainer alternates between demonstrative, interrogative, and active methods (through practical exercises and/or real-world scenarios). This pedagogical approach ensures concrete and directly applicable learning in the workplace.

Teaching resources provided

To ensure the quality of the Training Azure SQL Database - Administer and Optimize Performance training, Learni provides the following teaching resources:

Mac or PC computers, high-speed fiber internet, whiteboard or flipchart, video projector or interactive touchscreen (for remote sessions)
Training environments installed on workstations or accessible online
Course materials, practical exercises, and supplementary resources
Post-training access to materials and teaching resources

For in-house training at a location external to Learni, the client ensures and commits to having all necessary teaching materials (IT equipment, internet connection...) for the proper conduct of the training action in accordance with the prerequisites indicated in the communicated training program.

* contact us for remote feasibility** ratio varies depending on the training followed

Assessment methods

The assessment of skills acquired during the Training Azure SQL Database - Administer and Optimize Performance training is carried out through:

During training: case studies, practical exercises, and professional scenarios
At the end of training: self-assessment questionnaire and skills evaluation by the trainer
After training: training completion certificate detailing acquired skills

Training accessibility

Learni is committed to the accessibility of its professional training programs. All our training programs are accessible to people with disabilities. Our teams are available to adapt teaching methods to your specific needs. Do not hesitate to contact us for any accommodation request.

Training objectives

Master the administration of Azure SQL Database for scalable professional environments

Configure security and access to protect enterprise data

Optimize query and index performance in real-world contexts

Implement high availability and scalability with Azure SQL Database

Proactively monitor and troubleshoot performance incidents

Develop certifiable skills for production deployments

Deploy performant and secure Azure SQL solutions in teams

Training program

Module 1Azure SQL Database Fundamentals: Deployment and Initial Configuration (Azure Portal, PowerShell, CLI, ARM Templates)

Dive into creating Azure SQL Database instances via the Azure portal and PowerShell, configure DTU/vCore service levels to meet enterprise needs, migrate existing SQL Server databases using tools like Data Migration Service, perform practical exercises on an ongoing project, test connectivity and generate configuration reports, while learning best practices for rapid and reliable production deployment.

Module 2Azure SQL Database Security: IAM Management, Encryption and Auditing (Azure AD, TDE, Advanced Threat Protection)

Secure your Azure SQL Database instances by implementing Azure AD authentication and RBAC roles, enable TDE and Always Encrypted to protect sensitive data, configure auditing and alerts with Advanced Threat Protection, practice on simulated intrusion scenarios, generate GDPR-compliant logs, and document a comprehensive security plan for your professional applications, thereby strengthening the resilience of your cloud infrastructure.

Module 3Azure SQL Database Performance: Query and Index Optimization (Query Store, Intelligent Insights, Execution Plans)

Analyze and optimize performance using Query Store and execution plans in Azure SQL Database, create columnstore and filtered indexes suited to OLTP/OLAP workloads, tune slow queries through exercises on large datasets, use Automatic Tuning for immediate gains, measure impacts with precise metrics, and produce an optimization report directly applicable to your enterprise projects, thereby boosting the speed and efficiency of your databases.

Module 4High Availability and Monitoring for Azure SQL Database: Scaling, Backup, Alerts (Geo-replication, Failover Groups, Azure Monitor)

Implement high availability with Geo-replication and Failover Groups in Azure SQL Database, configure auto-scaling and automated backups for zero downtime, set up advanced monitoring via Azure Monitor and Log Analytics, simulate failures to test resilience, analyze real-time metrics and configure proactive alerts, finalize your ongoing project with a production-ready deployment, ensuring solid skills for critical enterprise operations.

Evaluation method

Multiple-choice quiz to validate acquired skills at the end of the certifying training
Continuous assessment through practical exercises and real cases
Presentation of the ongoing Azure SQL Database project to the expert trainer