Learn about us
Individual courses and packages with special discount
Technical labor programs endorsed by the Ministry of Education
Explore high-demand technology areas
Certifications from technology leaders
Descubre nuestra trayectoria como institución de educación de alta calidad
Programas alineados a certificaciones internacionales y necesidades del mercado global
Ver Oferta Académica CompletaThis 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 PowerS…
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
Trabajo con roles de servidor
Trabajo con funciones de base de datos fija
Creacion de roles de base de datos definidos por el usuario
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
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
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
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
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
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
Descripción de la seguridad del agente de SQL Server
Configuración de credenciales
Configuración de cuentas proxy
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
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
Actividad de seguimiento
Captura y gestión de datos de rendimiento
Analizar los datos de rendimiento recopilados
Utilidad 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
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
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.
At the end of the course, participants will be able to:
Basic knowledge of databases or having taken a SQL databases fundamentals course. Familiarity with SQL, basic queries, and database structures.
| 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 |
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.
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.
At the end of the course, participants will be able to:
Basic knowledge of databases or having taken a SQL databases fundamentals course. Familiarity with SQL, basic queries, and database structures.
| 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 |
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.
Solo te pedimos tu número para explicarte nuestra metodología y brindarte una atención personalizada.