Course Modules
Módulo I: Autenticación y autorización de usuarios
-
Autenticación de conexiones con SQL Server
-
Como habilitar los inicios de sesión para acceder a las bases de datos
-
Autorización en servidores
-
Bases de datos parcialmente contenidas
Módulo II: Asignación de funciones de servidor y de base de datos
-
Trabajo con roles de servidor
-
Trabajo con funciones de base de datos fija
-
Creacion de roles de base de datos definidos por el usuario
Módulo III: Como autorizar a los usuarios a acceder a los recursos
-
Autorizar el acceso de los usuarios a los objetos
-
Autorizar a los usuarios a ejecutar código
-
Configuración de permisos en el nivel de esquema
Módulo IV: Protección de datos con cifrado y auditoría
-
Opciones de auditoría de acceso a datos en SQL Server
-
Implementación de auditoría de SQL Server
-
Administración de la auditoría de SQL Server
-
Protección de datos con encriptacion
Módulo V: Modelos de recuperación de SQL Server
-
Estrategias de copia de seguridad
-
Descripción del inicio de sesión de transacciones de SQL Server
-
Planificación de una estrategia de copia de seguridad de SQL Server
Módulo VI: Copia de seguridad de bases de datos de SQL Server
-
Copia de seguridad de bases de datos y registros de transacciones
-
Administración de copias de seguridad de bases de datos
-
Trabajar con opciones de copia de seguridad
Módulo VII: Restauración de bases de datos de SQL Server
-
Comprensión del proceso de restauración
-
Restauración de bases de datos
-
Trabajar con recuperación de punto a tiempo
-
Restauración de bases de datos del sistema y archivos individuales
Módulo VIII: Automatización de la administración de SQL Server
-
Automatización de la administración de SQL Server
-
Trabajar con el agente de SQL Server
-
Administración de trabajos de agente de SQL Server
-
Gestion multi-servidor
Módulo IX: Configuración de la seguridad para SQL Server Agent
-
Descripción de la seguridad del agente de SQL Server
-
Configuración de credenciales
-
Configuración de cuentas proxy
Módulo X: Supervisión de SQL Server con alertas y notificaciones
-
Configuración del correo de la base de datos
-
Supervisión de errores de SQL Server
-
Configuración de operadores, alertas y notificaciones
-
Alertas en la base de datos de Azure
Módulo XI: Introducción a la administración de SQL Server mediante PowerShell
-
Configurar SQL Server mediante PowerShell
-
Administrar SQL Server mediante PowerShell
-
Mantener el entorno de SQL Server mediante PowerShell
-
Administracion de bases de datos de Azure SQL Server mediante PowerShell
Módulo XII: Supervisión de SQL Server
-
Actividad de seguimiento
-
Captura y gestión de datos de rendimiento
-
Analizar los datos de rendimiento recopilados
-
Utilidad de SQL Server
Módulo XIII: Solución de problemas de SQL Server
-
Metodología de solución de problemas de SQL Server
-
Resolución de problemas relacionados con el servicio
-
Resolución de problemas de conexión y conectividad
-
Solución de problemas comunes
Módulo XIV: Importación y exportación de datos
-
Transferencia de datos desde / hacia SQL Server
-
Importación y exportación de datos de tabla
-
Uso de BCP y BULK INSERT para importar datos
-
Implementacion y actualizacion de aplicaciones de nivel de datos
Current process description
This course is designed to provide in-depth training in SQL Server 2019 database infrastructure administration. Participants will learn to configure, manage, secure, and optimize databases, covering everything from authentication and authorization to task automation with SQL Server Agent and PowerShell, backup strategies, restoration, and troubleshooting.
Objectives
At the end of the course, participants will be able to:
- Authenticate, authorize users, and assign roles in SQL Server.
- Protect data through encryption and auditing.
- Implement recovery models and perform backups and restores.
- Automate administration using SQL Server Agent and PowerShell.
- Monitor performance, configure alerts, and troubleshoot infrastructure issues.
Prerequisites
Basic knowledge of databases or having taken a SQL databases fundamentals course. Familiarity with SQL, basic queries, and database structures.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| International Certification Administrator Sql Server 2019 | 40 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?
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 course is designed to provide in-depth training in SQL Server 2019 database infrastructure administration. Participants will learn to configure, manage, secure, and optimize databases, covering everything from authentication and authorization to task automation with SQL Server Agent and PowerShell, backup strategies, restoration, and troubleshooting.
Objectives
At the end of the course, participants will be able to:
- Authenticate, authorize users, and assign roles in SQL Server.
- Protect data through encryption and auditing.
- Implement recovery models and perform backups and restores.
- Automate administration using SQL Server Agent and PowerShell.
- Monitor performance, configure alerts, and troubleshoot infrastructure issues.
Prerequisites
Basic knowledge of databases or having taken a SQL databases fundamentals course. Familiarity with SQL, basic queries, and database structures.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| International Certification Administrator Sql Server 2019 | 40 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.