Program Modules
Module I: User Authentication and Authorization
- Connection authentication with SQL Server
- How to enable logins to access databases
- Authorization on servers
- Partially contained databases
Module II: Server and Database Role Assignment
- Working with server roles
- Working with fixed database roles
- Creating user-defined database roles
Module III: How to Authorize Users to Access Resources
- Authorize user access to objects
- Authorize users to execute code
- Permission configuration at the schema level
Module IV: Data Protection with Encryption and Auditing
- Data access auditing options in SQL Server
- Implementation of SQL Server auditing
- Management of SQL Server auditing
- Data protection with encryption
Module V: SQL Server Recovery Models
- Backup strategies
- Description of SQL Server transaction log
- Planning a SQL Server backup strategy
Module VI: SQL Server Database Backup
- Database and transaction log backups
- Management of database backups
- Working with backup options
Module VII: Database Restoration in SQL Server
- Understanding the restoration process
- Restoring databases
- Working with point-in-time recovery
- Restoring system databases and individual files
Module VIII: Automation of SQL Server Administration
- Automation of SQL Server Administration
- Working with the SQL Server Agent
- Management of SQL Server Agent Jobs
- Multi-Server Management
Module IX: Configuring Security for SQL Server Agent
- Description of SQL Server Agent security
- Configuration of credentials
- Configuration of proxy accounts
Module X: SQL Server Monitoring with Alerts and Notifications
- Database mail configuration
- Monitoring SQL Server errors
- Configuration of operators, alerts, and notifications
- Alerts in the Azure database
Module XI: Introduction to SQL Server Administration using PowerShell
- Configure SQL Server using PowerShell
- Manage SQL Server using PowerShell
- Maintain the SQL Server environment using PowerShell
- Administration of Azure SQL Server databases using PowerShell
Module XII: SQL Server Supervision
- Monitoring Activity
- Performance Data Capture and Management
- Analyze the Collected Performance Data
- SQL Server Utility
Module XIII: SQL Server Troubleshooting
- SQL Server Troubleshooting Methodology
- Service-related Troubleshooting
- Connection and Connectivity Issues
- Common Troubleshooting
Module XIV: Data Import and Export
- Data transfer to/from SQL Server
- Importing and exporting table data
- Using BCP and BULK INSERT to import data
- Implementation and updating of data-level applications
Module I: Components of SQL Server 2019
- Introduction to the SQL Server platform
- Overview of SQL Server architecture
- SQL Server services and configuration options
Module II: Installation of SQL Server 2019
- Considerations for installing SQL Server
- TempDB Files
- Installation of SQL Server 2019
- Automation of the installation
Module III: Upgrading SQL Server to SQL Server 2019
- Upgrade requirements
- Upgrading SQL Server services
- Migration of SQL Server data and applications
Module IV: Working with Databases
- Introduction to SQL Server Databases
- Creating Databases
- Database Files and Filegroups
- Moving Database Files
- Extending the Buffer Pool
Module V: Database Storage Options
- SQL Server Storage Performance
- SMB Fileshare
- Stretch Databases
Module I: Basic Data Concepts
- Basic data concepts
- Roles and responsibilities in the data world
- Relational data concepts.
- Non-relational data concepts
- Data analysis concepts
Module II: Relational Data in Azure
- Relational data offerings in Azure
- Provisioning and deploying relational database offerings in Azure
- Querying relational data in Azure
Module III: Non-relational Data in Azure
- Non-relational data offerings in Azure
- Provisioning and implementing non-relational data services in Azure
- Managing non-relational data warehouses in Azure
Module IV: Modern Data Warehouse Analysis in Azure
- Components of a modern data warehouse
- Data ingestion in Azure
- Data storage and processing in Azure
- Creating with Power BI
Module I: The Role of the Azure Database Administrator
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
Module II: Planning and Implementing Data Platform Resources
- Implementation of SQL Server using IaaS
- Implementation of SQL Server using PaaS
- Implementation of open-source database solutions on Azure
Module III: Implementing a Secure Environment
- Configure database authentication
- Configure database authorization
- Implement security for data at rest
- Implement security for data in transit
- Implement compliance controls for sensitive data
Module IV: Monitoring and Optimizing Operational Resources
- Baseline and performance monitoring
- Major causes of performance issues
- Resource configuration for optimal performance
- User database configuration
- Performance-related maintenance tasks
Module V: Optimize Query Performance
- Understand SQL Server query plans
- Explore performance-based database design
- Evaluate performance improvements
Module VI: Task Automation
- Configuration of automatic deployment
- Definition of scheduled tasks
- Configuration of extended events
- Management of Azure PaaS resources through automated methods
Module VII: Planning and Implementing 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
Current process description
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
Objectives
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)
Prerequisites
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
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Administrator Sql Server 2019 + Azure Database Administrator | 72 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Microsoft It Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certifications
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.
Current process description
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
Objectives
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)
Prerequisites
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
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Administrator Sql Server 2019 + Azure Database Administrator | 72 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Microsoft It Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certificationsAll our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.