Program Modules
Module I: Introduction
- Introduction to databases
- Non-relational
- Relational
- Basic terminology
- What is SQL
- Types of SQL statements
- SQL as a non-procedural language
- Examples of SQL
Module II: Creating and Populating a Database
- Create a database
- Data types
- Character
- Numeric
- Temporal data
- Table creation
- Design refinement
- Schema creation
- Populate and modify data in the table
- Insert
- Update
- Delete
- When good instructions do not work
- Without primary key
- Without foreign key
- Column violation
- Invalid date conversions
Module III: Basic Queries
- Mechanisms of queries
- Clauses of queries
- Select clause
- Alias
- Remove duplicates
- From clause
- Tables
- Linked tables
- Define table aliases
- Where clause
- Group by and having clause
- Order by clause
Module IV: Filters
- Conditions
- Use of parameters
- Not operator
- Construction of conditions
- Types of conditions
- Equality
- Range
- Membership Similarity
- Null
Module V: Querying Multiple Tables
- What is a join
- Cartesian product
- Inner joins
- ANSI join syntax
- Joining three or more tables
- Using subqueries as tables
- Using the same table twice
Module VI: Working with Sets
- Set Theory
- Set Theory in Practice
- Set Operators
- Union
- Intersect Except
- Rules of Set Operations
- Ordering Compound Queries
- Precedence of Operations
Module VII: Data Generation, Manipulation, and Conversion
- Working with character strings
- Generation Manipulation
- Working with numeric data
- Aritmetic functions
- Controlling number precision
- Working with temporal data
- Time zone
- Generate temporal data
- Manipulate temporal data
Module VIII: Grouping and Aggregation
- Grouping concepts
- Aggregation functions
- Implicit versus explicit
- Count distinct values
- Use expressions
- How nulls are interpreted
- Generate groupings
- One column
- Multiple columns
- Group with expressions
- Generate rollups
Module IX: Subqueries
- What is a subquery
- Types of subqueries
- Unrelated subqueries
- Multiple columns
- Multiple rows, single column
- Related subqueries
- Exists operator
- Data manipulation using subqueries
- When to use subqueries.
- Subquery as a data source
- Subquery as an expression
Module X: Transactions
- Multi-user databases
- Locking
- Granular locking
- What is a transaction
- Starting a transaction
- Ending a transaction
- Transaction savepoints
Module I: Introduction to Microsoft SQL Server 2019
- The basic architecture of SQL Server
- Versions and editions of SQL Server
- Getting started with SQL Server Management Studio
Module II: Writing SELECT Queries
- Writing Simple SELECT statements
- Removing duplicates with DISTINCT
- Using columns and table aliases
- Writing Simple CASE expressions
Module III: Queries of Multiple Tables
- Understanding Joins
- Queries with Inner Joins
- Queries with Outer Joins
- Querying with Cross Joins and Self Joins
Module IV: Sorting and Filtering Data
- Sorting data
- Filtering data with predicates
- Filtering with TOP and OFFSET-FETCH
- Working with unknown values
Module V: Working with SQL Server 2019 and Data Types
- Introduction to SQL Server 2019 Data Types
- Working with Character Data
- Working with Date and Time Data
Module VI: Using DML to Modify Data
- Insert data
- Modify and delete data
Module VII: Use of Built-in Functions
- Write queries with built-in functions
- Use conversion functions
- Using logical functions
- Use functions to work with NULL
Module VIII: Data Grouping and Aggregation
- Using aggregation functions
- Using the GROUP BY clause
- Filtering groups with HAVING
Module IX: Use of Subqueries
- Writing standalone subqueries
- Writing correlated subqueries
- Using the Exists prefix with subqueries
Module X: Use of Table Expressions
- Using Views
- Using Inline Table-Valued Functions
- Using Derived Tables
- Use of Common Table Expressions
Module XI: Using Window Ranking, Offset, and Aggregate Functions
- Creating Windows with Over
- Exploring Window Functions
Module XII: Rotating and Grouping Sets
- Write queries with PIVOT and UNPIVOT
- Work with grouping sets
Module XIII: Executing Stored Procedures
- Querying data with stored procedures
- Passing parameters to stored procedures
- Creating simple stored procedures
- Working with dynamic SQL
Module XIV: Programming with T-SQL
- Variable declaration and batch delimitation
- Use of flow control elements
- Use of variables in a dynamic SQL statement
- Use of synonyms
Module XV: Implementation of Error Management
- Implementation of T-SQL Error Handling
- Implementation of Structured Exception Handling
Module XVI: Transaction Implementation
- Transactions and database engines
- Transaction control
Module I: Introduction to Database Development
- Introduction to the SQL Server platform
- SQL Server database development tasks
Module II: Design and Implementation of Tables
- Table Design
- Data Types
- Working with Schemas
- Creation and Modification of Tables
Module III: Advanced Table Designs
- Data Partitioning
- Data Compression
- Temporal Tables
Module IV: Ensuring Data Integrity through Constraints
- Application of data integrity
- Implementation of data domain integrity
- Implementation of entity and referential integrity
Module V: Introduction to Indexes
- Basic concepts of indexing
- Data types and indexes
- Stacked, clustered, and non-clustered indexes
- Single-column and composite indexes
Module VI: Designing Optimized Indexing Strategies
- Indexing Strategies
- Index Management
- Execution Plans
- The Database Engine Optimization Advisor
- Query Store
Module VII: Columnstore Indexes
- Introduction to Columnstore indexes
- Creating column indexes
- Working with Columnstore indexes
Module VIII: Design and Implementation of Views
- Introduction to Views
- Creation and Management of Views
- Performance Considerations for Views
Module IX: Design and Implementation of User-Defined Functions
- Overview of functions
- Design and implementation of scalar functions
- Design and implementation of table-valued functions
- Considerations for function implementation
- Alternatives to functions
Module X: Responding to Data Manipulation through Triggers
- Design of DML triggers
- Implementation of DML triggers
- Advanced concepts of triggers
Module XI: Use of In-Memory Tables
- Memory-Optimized Tables
- Natively Compiled Stored Procedures
Module XII: Storing and Querying XML Data in SQL Server
- Introduction to XML Schemas and XML
- Storage of XML Data and Schemas in SQL Server
- Implementation of the XML Data Type
- Using the Transact-SQL FOR XML Statement
- Introduction to XQuery - Destroying XML
Module XIII: Storage and Querying of Spatial Data in SQL Server
- Introduction to Spatial Data
- Working with SQL Server Spatial Data Types
- Using Spatial Data in Applications
Module XIV: Storing and Querying BLOBs and Text Documents in SQL Server
- Considerations for BLOB data
- Working with FILESTREAM
- Using full-text search
Module XV: Concurrency in SQL Server
- Concurrency and transactions
- Internal locking
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
Module III: Non-relational Data in Azure
- Non-relational data offerings in Azure
- Provisioning and implementation of non-relational data services in Azure
- Managing non-relational data warehouses in Azure
Module IV: Modern Analysis of the Data Warehouse in Azure
- Components of a modern data warehouse
- Data ingestion in Azure
- Data storage and processing in Azure
- Creating with Power
Module I: Exploring Process and Storage Options for Data Engineering Workloads
- Introduction to Azure Synapse Analytics
- Description of Azure Databricks
- Introduction to Azure Data Lake Storage
- Description of Delta Lake Architecture
- Working with Data Streams using Azure Stream Analytics
Module II: Executing Interactive Queries with SQL Pools on Azure Synapse Analytics
- Exploring the capabilities of SQL pools on Azure Synapse
- Querying data in the lake using SQL pools on Azure Synapse
- Creating metadata objects in SQL pools on Azure Synapse
- Data protection and user management in SQL pools on Azure Synapse
Module III: Data Exploration and Transformation in Azure Databricks
- Description of Azure Databricks
- Reading and writing data in Azure Databricks
- Working with DataFrame elements in Azure Databricks
- Working with advanced DataFrame methods in Azure Databricks
Module IV: Exploration, Transformation, and Loading in Data Warehouses with Apache Spark
- Definition of big data engineering with Apache Spark in Azure Synapse Analytics
- Data insertion with Apache Spark in Azure Synapse Analytics
- Data transformation with DataFrame objects of Apache Spark groups in Azure Synapse Analytics
- Integration of SQL groups and Apache Spark in Azure Synapse Analytics
Module V: Data Insertion and Loading in Data Warehouses
- Use of best practices for data loading in Azure Synapse Analytics
- Petabyte-scale insertion with Azure Data Factory
Module VI: Data Transformation with Azure Data Factory or Azure Synapse Pipelines
- Data integration with Azure Data Factory or Azure Synapse pipeline
- Performing no-code transformations at scale with Azure Data Factory or Azure Synapse pipelines
Module VII: Organization of Data Movements and Transformations in Azure Synapse Pipelines
- Data movements and transformations in Azure Data Factory
Module VIII: Comprehensive Security with Azure Synapse Analytics
- Creation of a data warehouse in Azure Synapse Analytics
- Configuration and management of secrets in Azure Key Vault
Module IX: Support for Hybrid Transactional Analytical Processing with Azure Synapse Link
- Design of hybrid analytical and transactional processing using Azure Synapse Analytics
- Configuration of Azure Synapse Link with Azure Cosmos DB
- Querying Azure Cosmos DB with Apache Spark pools
- Querying Azure Cosmos DB with serverless SQL pools
Module X: Real-time Sequence Processing with Stream Analytics
- Enabling reliable messaging for big data applications with Azure Event Hubs
- Working with data streams using Azure Stream Analytics
- Ingesting data streams with Azure Stream Analytics
Module XI: Creating a Sequence Processing Solution with Event Hubs and Azure Databricks
- Streaming data processing with Azure Databricks Structured Streaming
Current process description
This program is designed to provide advanced training in administration of hybrid environments with Microsoft Azure and Windows Server, allowing professionals to manage hybrid infrastructure, integrating local environments with the Azure cloud. This program prepares participants to obtain international certifications:
- Azure fundamentals (AZ-900) (included in offline mode-pre-registered videos with certified instructors)
- Azure Administrator Associate (AZ-104)
- Windows Server Hybrid Administrator Associate (AZ-800 + AZ-801)
- Participants will learn to administer identities, networks, storage, safety and virtual machines in the Azure cloud, as well as manage Windows Server in hybrid environments with tools such as Windows Admin Center and Powershell
- 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:
- Manage identities in Azure Active Directory and Windows Server
- Configure security policies in hybrid environments with Azure Security Center and Azure Sentinel
- Administer subscriptions and resources in the Azure cloud
- Configure hybrid networks with Vnet Peering, VPN and Expressroute
- Manage storage in Azure and Windows servers
- Implement and manage virtual machines in local and cloud environments
- Configure disaster recovery strategies and high availability
- Supervise the infrastructure in Azure and Windows Server with advanced tools
- Obtain international certifications AZURE ADMINISTRATOR ASSOCIATE (AZ-104) and Windows Server Hybrid Administrator Associate (AZ-800 + AZ-801)
Prerequisites
To participate in this training, attendees must meet the following requirements:
- Experience in Windows Server Systems Administration and Services such as Active Directory (AD DS), DNS, DHCP, Hyper-V and storage
- Knowledge in networks, including IP addressing, name resolution and DHCP
- Familiarity with virtualization and administration of servers with Microsoft Hyper-V
- Basic knowledge of Azure Administration, including Active Directory and IAAS services
- Basic experience with Windows Powershell
- These requirements guarantee that participants can focus on the hybrid infrastructure administration without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Sql Databases Fundamentals + Development Sql Server 2019 + Azure Data Engineer | 102 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 advanced training in administration of hybrid environments with Microsoft Azure and Windows Server, allowing professionals to manage hybrid infrastructure, integrating local environments with the Azure cloud. This program prepares participants to obtain international certifications:
- Azure fundamentals (AZ-900) (included in offline mode-pre-registered videos with certified instructors)
- Azure Administrator Associate (AZ-104)
- Windows Server Hybrid Administrator Associate (AZ-800 + AZ-801)
- Participants will learn to administer identities, networks, storage, safety and virtual machines in the Azure cloud, as well as manage Windows Server in hybrid environments with tools such as Windows Admin Center and Powershell
- 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:
- Manage identities in Azure Active Directory and Windows Server
- Configure security policies in hybrid environments with Azure Security Center and Azure Sentinel
- Administer subscriptions and resources in the Azure cloud
- Configure hybrid networks with Vnet Peering, VPN and Expressroute
- Manage storage in Azure and Windows servers
- Implement and manage virtual machines in local and cloud environments
- Configure disaster recovery strategies and high availability
- Supervise the infrastructure in Azure and Windows Server with advanced tools
- Obtain international certifications AZURE ADMINISTRATOR ASSOCIATE (AZ-104) and Windows Server Hybrid Administrator Associate (AZ-800 + AZ-801)
Prerequisites
To participate in this training, attendees must meet the following requirements:
- Experience in Windows Server Systems Administration and Services such as Active Directory (AD DS), DNS, DHCP, Hyper-V and storage
- Knowledge in networks, including IP addressing, name resolution and DHCP
- Familiarity with virtualization and administration of servers with Microsoft Hyper-V
- Basic knowledge of Azure Administration, including Active Directory and IAAS services
- Basic experience with Windows Powershell
- These requirements guarantee that participants can focus on the hybrid infrastructure administration without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Sql Databases Fundamentals + Development Sql Server 2019 + Azure Data Engineer | 102 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.