Módulos

This program is designed to provide complete training in SQL Server 2019 and Azure SQL database administration, covering the implementation, safety, maintenance and optimization of databases in local and cloud environments. This program prepares participants to obtain international certifications:

• SQL Server 2019 Administrator
• Microsoft Certified Azure Data Fundamentals (DP-900) (included in offline mode with pre-recorded videos)
• Azure Database Administrator Associate (DP-300)
• Participants will learn to administer databases in SQL Server 2019 and in the Azure cloud, guaranteeing their safety, scalability and availability
• Following the practical Learning Method approach, students will develop practical laboratories, simulations and real projects, ensuring the application of knowledge acquired in a work environment

At the end of the course, participants will be able to:

• Authenticate and authorize users in SQL Server and Azure SQL
• Manage roles and database permits
• Protect data through encryption and audit in SQL Server and Azure
• Implement recovery models and backup strategies in databases
• Restore databases from SQL Server and Azure SQL
• Automize administration tasks with SQL Server Agent and Powershell
• Monitor database performance and optimize SQL queries
• Configure high availability and disaster recovery solutions in SQL Server and Azure SQL
• Obtain international SQL Server 2019 Administrator and Azure Database Administrator Associate (DP-300)

To participate in this training, attendees must meet the following requirements:

• Basic knowledge in databases or having taken the SQL Databases fundamental course in matrix classroom
• Familiarity with SQL and basic consultations
• Experience in data manipulation and database structures
• These requirements guarantee that participants can focus on the administration and optimization of databases without initial technical difficulties

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:

• a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
• b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
• c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Pre-enrollment

You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.

Infinity Payments

Make your payment quickly, safely and reliably

- For bank transfer payments, request the details by email capacita@aulamatriz.edu.co.

- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.