Program Modules
Module I: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
Module II: Data Warehouse Infrastructure Planning
- Considerations for Data Warehouse Infrastructure
- Hardware Planning for Data Warehouse
Module III: Design and Implementation of a Data Warehouse
- Logical design for a data warehouse
- Physical design for a data warehouse
Module IV: Columnstore Indexes
- Introduction to Columnstore indexes
- Creating column indexes
- Working with Columnstore indexes
Module V: Creating an ETL Solution
- Introduction to ETL with SSIS
- Exploration of Source Data
- Implementation of the Data Flow
Module VI: Implementation of Control Flow in an SSIS Package
- Introduction to Control Flow
- Creation of Dynamic Packages
- Use of Containers
Module VII: Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS package
- SSIS package event logging
- Error handling in an SSIS package
Module VIII: Implementation of an Incremental ETL Process
- Introduction to Incremental ETL
- Extraction of Modified Data
- Temporary Tables
Module IX: Application of Data Quality
- Introduction to data quality
- Using data quality services to clean data
- Using data quality services to match data
Module X: SQL Server Integration Services (SSIS) Extension
- Using custom components in SSIS
- Using SSIS Scripts
Module XI: Implementation and Configuration of SSIS Packages
- Overview of SSIS Deployment
- Implementing SSIS Projects
- Planning SSIS Package Execution
Module I: Introduction to Business Intelligence and Data Modeling
- Introduction to Business Intelligence
- The Microsoft Business Intelligence Platform
Module II: Creation of Multidimensional Databases
- Introduction to Multidimensional Analysis
- Creation of Data Sources and Data Source Views
- Creation of a Cube
- Overview of Cube Security
Module III: Working with Cubes and Dimensions
- Dimension configuration
- Defining attribute hierarchies
- Classification and categorization of attributes
Module IV: Working with Measures and Measure Groups
- Working with measures
- Working with measure groups
Module V: Introduction to MDX
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
Module VI: Customization of Cube Functionality
- Implementation of Key Performance Indicators
- Implementation of Actions
- Implementing Perspectives
- Implementation of Translations
Module VII: Implementation of a Tabular Data Model Using Analysis Services
- Introduction to tabular data models
- Creation of a tabular data model
- Utilization of a tabular model of analysis services in a business intelligence solution
Module VIII: Introduction to Data Analysis Expression (DAX)
- Fundamentals of DAX
- Using DAX to create calculated columns and measures in a tabular data model
Fundamentals of DAX - Using DAX to Create Calculated Columns and Measures in a Data Model
- Overview of Data Mining
- Using the Data Mining Add-in for Excel
- Creating a Custom Data Mining Solution
- Validating a Data Mining Model
- Connecting to and Consuming a Data Mining Model
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 implementation of 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: Introduction to Azure Machine Learning
- Introduction to Azure Machine Learning
- Azure Machine Learning Tools
Module II: No-Code Machine Learning with Designer
- Training Models with Designer
- Publishing Models with Designer
Module III: Execution of Experiments and Training Models
- Introduction to Experiments
- Training and Registering Models
Module IV: Working with Data
- Working with data warehouses
- Working with datasets
Module V: Calculate Contexts
- Working with environments
- Working with computing objectives
Module VI: Orchestration of Operations with Pipelines
- Introduction to Pipelines
- Publishing and Executing Pipelines
Module VII: Implementation and Consumption of Models
- Real-time inference
- Batch inference
Module VIII: Optimal Model Training
- Hyperparameter tuning
- Automated Machine Learning
Module IX: Interpret Models
- Introduction to Model Interpretation
- Using Model Explanations
Module X: Monitoring Models
- Monitoring models with Application Insights
- Monitoring data drift
Current process description
This program is designed to provide comprehensive training in database administration in on-premise environments and in the cloud with Microsoft Azure, focusing on the implementation, maintenance, safety and optimization of SQL Server and Azure SQL databases. This program prepares participants to obtain international certifications:
- SQL DATABASES FUNDAMENTS (SQLF-001)
- Administrator SQL Server 2019 (administering a SQL Database Infrastructure + Provisioning SQL Databases)
- Microsoft Certified Azure Data Fundamentals (DP-900) (included in pre-recorded videos)
- Azure Database Administrator Associate (DP-300)
- Participants will learn to design, manage and optimize SQL databases in business environments and in the Azure cloud, guaranteeing safety, scalability and efficiency in data management
- 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:
- Understand the basic concepts of relational databases and SQL
- Create and manage database objects in SQL Server and Azure SQL
- Execute consultations and manipulate data efficiently
- Implement security strategies to protect data on SQL Server and Azure
- Configure backup schemes, recovery and high availability in databases
- Manage SQL Server with advanced tools, including Powershell
- Supervise and optimize SQL database performance
- Automate administrative tasks and manage databases in cloud and on-premise environments
- Obtain international SQL Databases Fundamental certifications, administrator SQL Server 2019 and Azure Database Administrator Associate (DP-300)
Prerequisites
Requirements:
- Minimum of 2 years' experience working with relational databases
- Database design and normalization
- Creation of tables, relationships, and primary/foreign keys
- Proficiency in T-SQL queries (SELECT, JOIN, functions, subqueries)
- Basic understanding of programming structures: conditionals, loops, and functions
- Desirable Requirements:
- Basic SQL Server administration skills (security, backups, permissions)
- General knowledge of business indicators (KPIs): revenue, costs, profitability
- Familiarity with operational or analytical processes in your organization
- Experience with analysis tools (advanced Excel, Power BI)
- General concepts of Data Warehouse, ETL, or multidimensional models
- If you do not meet the prerequisites, you must have taken the Microsoft course: “International SQL Server Development Certification
- ”
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Business Intelligence Sql Server 2019 + Azure Data Scientist | 64 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 comprehensive training in database administration in on-premise environments and in the cloud with Microsoft Azure, focusing on the implementation, maintenance, safety and optimization of SQL Server and Azure SQL databases. This program prepares participants to obtain international certifications:
- SQL DATABASES FUNDAMENTS (SQLF-001)
- Administrator SQL Server 2019 (administering a SQL Database Infrastructure + Provisioning SQL Databases)
- Microsoft Certified Azure Data Fundamentals (DP-900) (included in pre-recorded videos)
- Azure Database Administrator Associate (DP-300)
- Participants will learn to design, manage and optimize SQL databases in business environments and in the Azure cloud, guaranteeing safety, scalability and efficiency in data management
- 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:
- Understand the basic concepts of relational databases and SQL
- Create and manage database objects in SQL Server and Azure SQL
- Execute consultations and manipulate data efficiently
- Implement security strategies to protect data on SQL Server and Azure
- Configure backup schemes, recovery and high availability in databases
- Manage SQL Server with advanced tools, including Powershell
- Supervise and optimize SQL database performance
- Automate administrative tasks and manage databases in cloud and on-premise environments
- Obtain international SQL Databases Fundamental certifications, administrator SQL Server 2019 and Azure Database Administrator Associate (DP-300)
Prerequisites
Requirements:
- Minimum of 2 years' experience working with relational databases
- Database design and normalization
- Creation of tables, relationships, and primary/foreign keys
- Proficiency in T-SQL queries (SELECT, JOIN, functions, subqueries)
- Basic understanding of programming structures: conditionals, loops, and functions
- Desirable Requirements:
- Basic SQL Server administration skills (security, backups, permissions)
- General knowledge of business indicators (KPIs): revenue, costs, profitability
- Familiarity with operational or analytical processes in your organization
- Experience with analysis tools (advanced Excel, Power BI)
- General concepts of Data Warehouse, ETL, or multidimensional models
- If you do not meet the prerequisites, you must have taken the Microsoft course: “International SQL Server Development Certification
- ”
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Business Intelligence Sql Server 2019 + Azure Data Scientist | 64 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.