Information Systems and Database Technician + Fabric Data Engineer Associate

This technical training program prepares you to be a professional database engineer capable of designing, implementing, and managing Azure database infrastructures in modern enterprise environments. Through comprehensive training, you will acquire skills in authentication, authorization, data secur…

702 hours
Multiple Certificates
Learning Path
Premium Support
Técnico Laboral en Sistemas Informaticos y Bases de Datos + Fabric Data Engineer Associate
Microsoft It Academy logo

Program Modules

MÓDULO I: Introducción a Ingeniería de Bases de Datos en Azure

  • Conceptos fundamentales de bases de datos y su importancia empresarial
  • Introducción a Azure y sus servicios de bases de datos
  • Diferencias entre bases de datos relacionales y no relacionales
  • Plataformas y opciones de Azure Database
  • Arquitectura básica de sistemas de información

  • Modelado conceptual, lógico y físico de bases de datos
  • Normalización de datos y optimización de estructuras
  • Diseño de tablas, índices y constraints
  • Relaciones entre entidades y integridad referencial
  • Diseño orientado a rendimiento y escalabilidad

  • Autenticación de conexiones en Azure
  • Configuración de usuarios y roles
  • Autorización y permisos a nivel servidor y base de datos
  • Roles definidos por el usuario y gestión de acceso
  • Control de acceso basado en roles (RBAC)

  • Cifrado de datos en reposo y en tránsito
  • Implementación de auditoría y logging
  • Controles de cumplimiento para datos confidenciales
  • Enmascaramiento dinámico de datos
  • Políticas de seguridad y cumplimiento normativo

  • Modelos de recuperación y estrategias de backup
  • Copia de seguridad automática y geo-redundante en Azure
  • Recuperación de punto a tiempo y restauración selectiva
  • Planes de recuperación ante desastres (RTO/RPO)
  • Validación y testing de copias de seguridad

  • Escritura de consultas SQL eficientes
  • Análisis de planes de ejecución y optimización
  • Índices y su impacto en rendimiento
  • Vistas y procedimientos almacenados
  • Query tuning avanzado

  • Implementación de bases de datos en máquinas virtuales (IaaS)
  • Implementación de Azure SQL Database (PaaS)
  • Azure SQL Managed Instance
  • Selección de la opción correcta según requisitos
  • Configuración de recursos y capacidades

  • Captura y análisis de métricas de rendimiento
  • Herramientas de diagnóstico y monitoreo en Azure
  • Identificación de cuellos de botella
  • Tuning de recursos y configuración
  • Alertas y notificaciones automáticas

  • Automatización de tareas administrativas con PowerShell
  • Trabajos programados y mantenimiento automatizado
  • Gestión de índices y estadísticas
  • Compresión y limpieza de datos
  • Scripts de mantenimiento proactivo

  • Arquitecturas de alta disponibilidad (HA)
  • Replicación y sincronización de datos
  • Grupos de disponibilidad y failover
  • Geo-replicación en Azure
  • Diseño de soluciones resilientes

  • Estrategias de migración de datos a Azure
  • Herramientas de migración (DMS, Azure Data Factory)
  • Validación de integridad durante migraciones
  • Zero-downtime migration strategies
  • Cutover planning y ejecución

  • Servicios NoSQL en Azure (Cosmos DB, MongoDB)
  • Diseño de esquemas para bases de datos no relacionales
  • Análisis de datos con Azure Synapse
  • Data Lakes y almacenamiento de datos
  • Integración de múltiples tipos de datos

  • Scaling vertical y horizontal de bases de datos
  • Particionamiento y sharding de datos
  • Optimización de costos en Azure
  • Reserved capacity y pricing models
  • Monitoreo de costos y optimización de recursos

  • Configuración de firewalls y reglas de acceso
  • Virtual networks y endpoints privados
  • Encriptación de conexiones TLS/SSL
  • VPN y acceso seguro
  • Network segmentation y microsegmentación

  • Requisitos de conformidad (GDPR, HIPAA, ISO)
  • Auditoría y logging avanzado
  • Retención de datos y archivado
  • Encriptación de claves del cliente
  • Reportes de cumplimiento normativo

  • Azure Data Factory y pipelines de datos
  • Integración de múltiples fuentes de datos
  • Transformación y preparación de datos
  • Scheduled jobs y event-driven processing
  • Monitoreo de pipelines de datos

  • Versionamiento de esquemas y migraciones
  • Infraestructure as Code (Terraform, ARM templates)
  • CI/CD pipelines para bases de datos
  • Automatización de deployments
  • Testing automático de esquemas y datos

  • Diseño de solución completa de base de datos empresarial
  • Implementación en Azure seleccionando modalidad IaaS/PaaS
  • Seguridad, backup y disaster recovery
  • Optimización de rendimiento y costos
  • Documentación técnica y presentación del proyecto

Current process description

This technical training program prepares you to be a professional database engineer capable of designing, implementing, and managing Azure database infrastructures in modern enterprise environments. Through comprehensive training, you will acquire skills in authentication, authorization, data security with encryption and auditing, implementation of backups and disaster recovery strategies, optimization of database performance through query plan monitoring and analysis, automation of administrative tasks, design of scalable cloud solutions in both IaaS and PaaS models, and development of advanced SQL queries. The methodology is based on hands-on workshops and labs that simulate real-world work scenarios, allowing you to build authentic projects and gain direct work experience. Upon completion, you will earn two globally recognized Microsoft certifications:

  • Azure Data Fundamentals (DP-900) and Azure Fabric Data Engineer Associate (DP-700), positioning you as a competitive professional for critical roles in organizations that depend on secure, available, and high-performance data

Objectives

- Train professionals to design, architect, and implement database infrastructures in Azure, ensuring availability, scalability, security, and data integrity in complex enterprise environments. - Develop advanced technical skills in authentication, authorization, and role and permission management to protect database resources according to established regulations and procedures. - Implement effective data security strategies using encryption, auditing, and compliance controls to ensure the confidentiality and protection of sensitive information. - Design and implement backup and disaster recovery plans to guarantee business continuity in critical situations. - Monitor, analyze, and optimize database performance by identifying bottlenecks and implementing improvements to maximize operational efficiency and scalability. - Automate repetitive administrative tasks using PowerShell and advanced Azure tools to increase productivity and reduce manual errors. - Provision, migrate, and implement relational and non-relational database solutions in IaaS and PaaS models on the Azure platform with a focus on scalability. - Develop and optimize complex SQL queries and manage relational databases efficiently and with superior performance. - Obtain globally recognized Microsoft certifications that validate competencies in Azure database administration. - Apply technical methodologies and standard procedures to resolve database connectivity, performance, and availability issues. - Design scalable, engineering-oriented data solutions that meet advanced business requirements. - Prepare competitive professionals for the job market, capable of performing in critical engineering roles that require expert data management in modern organizations.

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 + Fabric Data Engineer Associate 702 hours

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.

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.

Payment Options

Make your payment quickly, safely and reliably

  • For bank transfer payments, request the details by email customerservice@infinityti.org

Log In

Para continuar con tu inscripción, debes iniciar sesión o crear una cuenta.

Current process description

This technical training program prepares you to be a professional database engineer capable of designing, implementing, and managing Azure database infrastructures in modern enterprise environments. Through comprehensive training, you will acquire skills in authentication, authorization, data security with encryption and auditing, implementation of backups and disaster recovery strategies, optimization of database performance through query plan monitoring and analysis, automation of administrative tasks, design of scalable cloud solutions in both IaaS and PaaS models, and development of advanced SQL queries. The methodology is based on hands-on workshops and labs that simulate real-world work scenarios, allowing you to build authentic projects and gain direct work experience. Upon completion, you will earn two globally recognized Microsoft certifications:

  • Azure Data Fundamentals (DP-900) and Azure Fabric Data Engineer Associate (DP-700), positioning you as a competitive professional for critical roles in organizations that depend on secure, available, and high-performance data

Objectives

- Train professionals to design, architect, and implement database infrastructures in Azure, ensuring availability, scalability, security, and data integrity in complex enterprise environments. - Develop advanced technical skills in authentication, authorization, and role and permission management to protect database resources according to established regulations and procedures. - Implement effective data security strategies using encryption, auditing, and compliance controls to ensure the confidentiality and protection of sensitive information. - Design and implement backup and disaster recovery plans to guarantee business continuity in critical situations. - Monitor, analyze, and optimize database performance by identifying bottlenecks and implementing improvements to maximize operational efficiency and scalability. - Automate repetitive administrative tasks using PowerShell and advanced Azure tools to increase productivity and reduce manual errors. - Provision, migrate, and implement relational and non-relational database solutions in IaaS and PaaS models on the Azure platform with a focus on scalability. - Develop and optimize complex SQL queries and manage relational databases efficiently and with superior performance. - Obtain globally recognized Microsoft certifications that validate competencies in Azure database administration. - Apply technical methodologies and standard procedures to resolve database connectivity, performance, and availability issues. - Design scalable, engineering-oriented data solutions that meet advanced business requirements. - Prepare competitive professionals for the job market, capable of performing in critical engineering roles that require expert data management in modern organizations.

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 + Fabric Data Engineer Associate 702 hours

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.

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.

Payment Options

Make your payment quickly, safely and reliably

  • For bank transfer payments, request the details by email customerservice@infinityti.org

Log In

Para continuar con tu inscripción, debes iniciar sesión o crear una cuenta.