Program Modules
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
- Utilize 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
- Using 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 using 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
- Declaration of variables and batch delimitation
- Use of flow control elements
- Use of variables in a dynamic SQL statement
- Use of synonym
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
- Temporary Tables
Module IV: Ensuring Data Integrity through Constraints
- Application of data integrity
- Implementation of domain data 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 Tuning 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
Module XI: Use of In-Memory Tables
- Memory-Optimized Tables
- Natively Compiled Stored Procedures
Module XII: Storage and Querying of 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
- Destructuring XML
Module XIII: Storage and Querying of Spatial Data in SQL Server
- Introduction to Spatial Data
- Working with Spatial Data Types in SQL Server
- 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 locks
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 implementing 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 implementation of 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: Exploring Computing and Storage Options for Data Engineering Workloads
- Introduction to Azure Synapse Analytics
- Describe Azure Databricks
- Introduction to Azure Data Lake Storage
- Describe the Delta Lake architecture - Working with data streams using Azure Stream Analytics
Module II: Design and Implement the Service Layer
- Design a multidimensional schema to optimize analytical workloads
- No-code transformation at scale with Azure Data Factory
- Fill slowly changing dimensions in Azure Synapse Analytics pipelines
Module III: Data Engineering Considerations for Source Files
- Design a modern data warehouse using Azure Synapse Analytics
- Secure a data warehouse in Azure Synapse Analytics
Module IV: Execute Interactive Queries Using Azure Synapse Analytics Serverless SQL Pools
- Explore the capabilities of Azure Synapse Serverless SQL Pools
- Query data in the lake using Azure Synapse Serverless SQL Pools
- Create metadata objects in Azure Synapse Serverless SQL Pools
- Secure data and manage users in Azure Synapse Serverless SQL Pools
Module V: Explore, Transform, and Load Data into the Data Warehouse Using Apache Spark
- Understand big data engineering with Apache Spark in Azure Synapse Analytics
- Data ingestion with Apache Spark notebooks in Azure Synapse Analytics
- Transform data with DataFrames in Apache Spark Pools in Azure Synapse Analytics
- Integrate SQL pools and Apache Spark in Azure Synapse Analytics
Module VI: Data Exploration and Transformation in Azure Databricks
- Describe Azure Databricks
- Read and write data in Azure Databricks
- Work with DataFrames in Azure Databricks
- Work with advanced DataFrame methods in Azure Databricks
Module VII: Ingest and Load Data into the Data Warehouse
- Utilize best practices for data loading in Azure Synapse Analytics
- Petabyte-scale ingestion with Azure Data Factory
Module VIII: Transforming Data with Azure Data Factory or Azure Synapse Pipelines
- Data integration with Azure Data Factory or Azure Synapse Pipelines
- No-code transformation at scale with Azure Data Factory or Azure Synapse Pipelines
Module IX: Orchestrating the Movement and Transformation of Data in Azure Synapse Pipelines
- Orchestrating the movement and transformation of data in Azure Data Factory
Module X: Optimize Query Performance with Dedicated SQL Pools in Azure Synapse
- Optimize the performance of data warehouse queries in Azure Synapse Analytics
- Understand the data warehouse scheduler functions of Azure Synapse Analytics
Module XI: Analyze and Optimize Data Warehouse Storage
- Analyze and optimize data warehouse storage in Azure Synapse Analytics
Module XII: Supporting Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
- Design a hybrid transactional and analytical processing using Azure Synapse Analytics
- Configure Azure Synapse Link with Azure Cosmos DB
- Query Azure Cosmos DB with Apache Spark pools
- Query Azure Cosmos DB with serverless SQL pools
Module XIII: End-to-End Security with Azure Synapse Analytics
- Securing a data warehouse in Azure Synapse Analytics
- Configuring and managing secrets in Azure Key Vault
- Implementing compliance controls for sensitive data
Module XIV: Real-Time Stream Processing with Stream Analytics
- Enable reliable messaging for Big Data applications using Azure Event Hubs
- Work with data streams using Azure Stream Analytics
- Ingest data streams with Azure Stream Analytics
Module XV: Create a Stream Processing Solution with Event Hubs and Azure Databricks
- Process streaming data with Azure Databricks structured streaming
Module XVI: Building Reports Using Power BI Integration with Azure Synapse Analytics
- Create reports with Power BI using its integration with Azure Synapse Analytics
Module XVII: Implementing Machine Learning Processes Integrated in Azure Synapse Analytics
- Utilize the integrated machine learning process in Azure Synapse Analytics
Current process description
This program provides integral training in database development with SQL Server 2019 and Azure Data Engineering, covering the creation, consultation, administration and optimization of databases in on-premise environments and in the cloud. This program prepares participants to obtain international certifications:
- SQL Server 2019 Development
- Microsoft Certified Azure Data Fundamentals (DP-900) (included in offline mode with pre-recorded videos)
- Azure Data Engineer Associate (DP-203)
- Participants will learn to develop scalable database solutions in SQL Server and Azure, implement query optimization strategies and configure data flows in the cloud
- 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:
- Design, develop and manage SQL Server and Azure SQL databases
- Write complex consultations in Transact-SQL to handle large volumes of data
- Optimize the performance of databases and SQL consultations
- Implement indexing strategies, views and stored procedures
- Transform data with tools such as Azure Data Factory and Azure Synapse Pipelines
- Eating and loading data in modern data stores in Azure
- Automate data engineering processes with Apache Spark and Azure Databricks
- Perform real -time flow processing with Azure Stream Analytics and Event Hubs
- Implement safety and compliance in cloud databases
- Obtain international SQL Server 2019 Development and Azure Data Engineer Associate (DP-203) international certifications
Prerequisites
To participate in this training, attendees must meet the following requirements:
- Basic knowledge in databases or having taken the SQL Databases fundamental course in matrix classroom
- Familiarity with SQL and basic consultations
- Experience in data manipulation and database structures
- These requirements guarantee that participants can focus on the development and administration of databases without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Development Sql Server 2019 + Azure Data Engineer | 72 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 provides integral training in database development with SQL Server 2019 and Azure Data Engineering, covering the creation, consultation, administration and optimization of databases in on-premise environments and in the cloud. This program prepares participants to obtain international certifications:
- SQL Server 2019 Development
- Microsoft Certified Azure Data Fundamentals (DP-900) (included in offline mode with pre-recorded videos)
- Azure Data Engineer Associate (DP-203)
- Participants will learn to develop scalable database solutions in SQL Server and Azure, implement query optimization strategies and configure data flows in the cloud
- 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:
- Design, develop and manage SQL Server and Azure SQL databases
- Write complex consultations in Transact-SQL to handle large volumes of data
- Optimize the performance of databases and SQL consultations
- Implement indexing strategies, views and stored procedures
- Transform data with tools such as Azure Data Factory and Azure Synapse Pipelines
- Eating and loading data in modern data stores in Azure
- Automate data engineering processes with Apache Spark and Azure Databricks
- Perform real -time flow processing with Azure Stream Analytics and Event Hubs
- Implement safety and compliance in cloud databases
- Obtain international SQL Server 2019 Development and Azure Data Engineer Associate (DP-203) international certifications
Prerequisites
To participate in this training, attendees must meet the following requirements:
- Basic knowledge in databases or having taken the SQL Databases fundamental course in matrix classroom
- Familiarity with SQL and basic consultations
- Experience in data manipulation and database structures
- These requirements guarantee that participants can focus on the development and administration of databases without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Programa para certificación internacional Development Sql Server 2019 + Azure Data Engineer | 72 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.