Program Modules
Nivel I: Fundamentos de bases de datos y sistemas
Adquiere las bases esenciales en sistemas informáticos y gestión de datos. Aprenderás desde cero los conceptos fundamentales de bases de datos, programación básica, redes y sistemas operativos, construyendo una base sólida para convertirte en administrador de bases de datos.
Módulo 1: Fundamentos de sistemas informáticos
- Terminología técnica en bases de datos
- Arquitectura de computadores
- Sistemas operativos (Windows Server, Linux)
- Virtualización básica
- Introducción a IA en gestión de datos
Módulo 2: Matemática y lógica para bases de datos
- Matemática básica y estadística
- Lógica proposicional y conjuntos
- Álgebra relacional básica
- Teoría de normalización
- Uso de IA para análisis de datos
Módulo 3: Principios de redes y conectividad
- Fundamentos de redes
- TCP/IP y protocolos
- Cliente-servidor
- Conectividad de bases de datos
- Puertos y servicios
Módulo 4: Introducción a bases de datos
- Conceptos de bases de datos
- Modelos de datos (relacional, no relacional)
- DBMS (Database Management Systems)
- Ciclo de vida de una base de datos
- IA en optimización de queries
Módulo 5: SQL Fundamentals
- SQL básico: SELECT, INSERT, UPDATE, DELETE
- WHERE, ORDER BY, GROUP BY, HAVING
- Funciones agregadas
- Joins (INNER, LEFT, RIGHT, FULL)
- Subconsultas
- Vistas básicas
- Preparación para certificación SQL Database Fundamentals
Nivel II: Administración y modelado de bases de datos
Profundiza en la administración profesional de bases de datos. Dominarás el modelado de datos, administración de motores relacionales y NoSQL, optimización de consultas, seguridad, respaldos y automatización con IA. Incluye preparación y presentación del examen internacional SQL Database Fundamentals de CertiTalents.
Módulo 6: Modelado de bases de datos relacionales
- Modelo Entidad-Relación (ER)
- Diagramas ER avanzados
- Normalización (1FN a 5FN)
- Desnormalización estratégica
- Diseño de esquemas
- Herramientas de modelado (MySQL Workbench, dbdiagram.io)
- Generación de diagramas ER con IA
Módulo 7: Administración de bases de datos relacionales (DBA)
- Instalación y configuración (MySQL/PostgreSQL/SQL Server)
- Gestión de usuarios y permisos
- Roles y privilegios
- Respaldos (backup) y restauración
- Monitoreo de rendimiento
- Logs y auditoría
- Mantenimiento preventivo
- Monitoreo inteligente con IA
Módulo 8: SQL avanzado y optimización
- Índices y optimización
- Stored procedures
- Triggers
- Funciones definidas por usuario
- Transacciones (ACID)
- Manejo de concurrencia
- Plan de ejecución de queries
- Optimización de queries con IA
Módulo 9: Bases de datos NoSQL
- Introducción a NoSQL
- Tipos: Documentales (MongoDB), Clave-Valor (Redis), Columnares, Grafos
- Casos de uso NoSQL vs SQL
- MongoDB práctico
- Redis para caché
- IA con bases de datos vectoriales
Módulo 10: Seguridad y aseguramiento de bases de datos
- Principios de seguridad de datos
- Encriptación de datos
- SQL Injection y prevención
- Auditoría y compliance
- GDPR y protección de datos personales
- Políticas de acceso
- Detección de anomalías con IA
Módulo 11: Automatización y scripting para DBAs
- Scripting con Python para DBAs
- Automatización de backups
- Scripts de mantenimiento
- ETL básico (Extract, Transform, Load)
- Tareas programadas
- Automatización inteligente de tareas DBA
Módulo 12: Habilidades empresariales
- Contabilidad básica
- Costos de infraestructura de datos
- Documentación técnica
- Emprendimiento tecnológico
Módulo 13: Preparación y certificación SQL Database Fundamentals - CertiTalents
- Repaso integrador de SQL
- Ejercicios tipo examen
- Simulacros completos
- Refuerzo de conceptos
- Examen oficial SQL Database Fundamentals
Nivel III: Profesionalización y proyecto
Consolida tus competencias como DBA profesional. Aprenderás herramientas colaborativas, alta disponibilidad, replicación, cloud databases y DevOps para datos. Desarrollarás un proyecto integrador de administración de base de datos que demuestre todas tus habilidades y te preparará para el mercado laboral.
Módulo 14: Git y documentación de bases de datos
- Control de versiones para scripts SQL
- GitHub para DBAs
- Documentación de esquemas
- Diagramas y manuales técnicos
Módulo 15: Alta disponibilidad y replicación
- Conceptos de alta disponibilidad
- Replicación master-slave
- Clustering básico
- Failover y recuperación ante desastres
- Predicción de fallos con IA
Módulo 16: Bases de datos en la nube
- Cloud computing para datos
- AWS RDS, Azure SQL, Google Cloud SQL
- Migración a la nube
- Costos y dimensionamiento
- Bases de datos IA-nativas
Módulo 17: Ética, seguridad y salud
- Ética profesional del DBA
- Ética en manejo de datos sensibles
- Responsabilidad con datos personales
- Salud ocupacional
- Ergonomía
Módulo 18: Empleabilidad y marca personal
- Portfolio de DBA
- LinkedIn para DBAs
- CV técnico
- Preparación entrevistas técnicas
- Comunidades de datos
Módulo 19: Proyecto de grado - Administración de base de datos
- Diseño de esquema completo (ER + normalización)
- Implementación en motor relacional o NoSQL
- Stored procedures, triggers, vistas
- Sistema de usuarios y permisos
- Respaldos automatizados y alta disponibilidad
- Monitoreo y logs
- Componente IA obligatorio
- Documentación técnica completa
- Presentación ante jurado
Certificaciones al finalizar:
- Técnico laboral en Sistemas informáticos y bases de datos (Orientado a administradores) (Secretaría de Educación)
- Certificación internacional SQL Database Fundamentals de CertiTalents
Current process description
Master professional database administration for relational and NoSQL systems. Learn data modeling, normalization, advanced SQL, administration of MySQL, PostgreSQL, SQL Server, MongoDB, and Redis. Implement security, backups, high availability, replication, and task automation. Apply AI for optimization and intelligent monitoring. Create stored procedures, triggers, manage users, and develop recovery plans. Graduate with dual certification:
- Technical Labor diploma endorsed by the Bogotá Secretary of Education and international SQL Database Fundamentals certification from CertiTalents
Objectives
General Objective:
- -Train technical labor professionals capable of administering relational and NoSQL database systems, with competencies in design, implementation, security, optimization, and maintenance of enterprise information
- Specific Objectives:
- -Design database schemas applying entity-relationship modeling and normalization
- -Administer relational database engines (MySQL, PostgreSQL, SQL Server) and NoSQL (MongoDB, Redis)
- -Develop advanced SQL queries with stored procedures, triggers, and views
- -Implement security strategies, backups, and high availability
- -Automate administrative tasks and apply AI tools for optimization
- -Document technical procedures and develop disaster recovery plans
- -Prepare students for the international SQL Database Fundamentals certification from CertiTalents
Prerequisites
- Photocopy of high school diploma or transcript, or, failing that, ninth grade certificate. - Photocopy of citizenship card or identity card (if the person to be enrolled is a minor, the guardian's card is required and this person must accompany the minor during enrollment). - Photocopy of EPS or SISBEN card or certification - Two 3×4 photos with a white background.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Técnico Laboral en Sistemas Informaticos y Bases de Datos. | 630 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 Certitalents
• 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
Master professional database administration for relational and NoSQL systems. Learn data modeling, normalization, advanced SQL, administration of MySQL, PostgreSQL, SQL Server, MongoDB, and Redis. Implement security, backups, high availability, replication, and task automation. Apply AI for optimization and intelligent monitoring. Create stored procedures, triggers, manage users, and develop recovery plans. Graduate with dual certification:
- Technical Labor diploma endorsed by the Bogotá Secretary of Education and international SQL Database Fundamentals certification from CertiTalents
Objectives
General Objective:
- -Train technical labor professionals capable of administering relational and NoSQL database systems, with competencies in design, implementation, security, optimization, and maintenance of enterprise information
- Specific Objectives:
- -Design database schemas applying entity-relationship modeling and normalization
- -Administer relational database engines (MySQL, PostgreSQL, SQL Server) and NoSQL (MongoDB, Redis)
- -Develop advanced SQL queries with stored procedures, triggers, and views
- -Implement security strategies, backups, and high availability
- -Automate administrative tasks and apply AI tools for optimization
- -Document technical procedures and develop disaster recovery plans
- -Prepare students for the international SQL Database Fundamentals certification from CertiTalents
Prerequisites
- Photocopy of high school diploma or transcript, or, failing that, ninth grade certificate. - Photocopy of citizenship card or identity card (if the person to be enrolled is a minor, the guardian's card is required and this person must accompany the minor during enrollment). - Photocopy of EPS or SISBEN card or certification - Two 3×4 photos with a white background.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Técnico Laboral en Sistemas Informaticos y Bases de Datos. | 630 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 Certitalents
• 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.