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: Create and Populate 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
- No primary key
- No foreign key
- Column violation
- Invalid date conversions
Module III: Basic Queries
Query mechanisms
Query clauses
Select clause
- Alias
- Remove duplicates
From clause
- Tables
- Linked tables
- Define table aliases
Where clause
Group by and having 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 Composite Queries
- Precedence of Operations
Module VII: Data Generation, Manipulation, and Conversion
- Working with character strings
- Generation
- Manipulation
- Working with numeric data
- Arithmetic 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 XI: Views
- What are views
- Why use views
- Data security
- Data aggregation
- Hiding complexity
- Joining partitioned tables
Module I: User Authentication and Authorization
- Connection authentication with SQL Server
- How to enable logins to access databases
- Authorization on servers
- Partially contained databases
Module II: Assignment of Server and Database Roles
- Working with server roles
- Working with fixed database roles
- Creating user-defined database roles
Module III: How to Authorize Users to Access Resources
- Authorize user access to objects
- Authorize users to execute code
- Configuration of permissions at the schema level
Module IV: Data Protection with Encryption and Auditing
- Data access auditing options in SQL Server
- Implementation of SQL Server auditing
- Management of SQL Server auditing
- Data protection with encryption
Module V: SQL Server Recovery Models
- Backup strategies
- Description of SQL Server transaction log
- Planning a SQL Server backup strategy
Module VI: SQL Server Database Backup
- Database and transaction log backups
- Database backup management
- Working with backup options
Module VII: Restoration of SQL Server Databases
- Understanding the restoration process
- Restoration of databases
- Working with point-in-time recovery
- Restoration of system databases and individual files
Module VIII: Automation of SQL Server Administration
- Automation of SQL Server Administration
- Working with the SQL Server Agent
- Management of SQL Server Agent Jobs
- Multi-Server Management
Module IX: Configuring Security for SQL Server Agent
- Description of SQL Server Agent security
- Configuration of credentials
- Configuration of proxy accounts
Module X: SQL Server Monitoring with Alerts and Notifications
- Configuration of the database email
- Monitoring SQL Server errors
- Configuration of operators, alerts, and notifications
- Alerts in Azure SQL Database
Module XI: Introduction to SQL Server Administration using PowerShell
- Configure SQL Server using PowerShell
- Manage SQL Server using PowerShell
- Maintain the SQL Server environment using PowerShell
- Administration of Azure SQL Server databases using PowerShell
Module XII: SQL Server Supervision
- Monitoring activity
- Performance data capture and management
- Analyze the collected performance data
- SQL Server utility
Module XIII: Troubleshooting SQL Server
- SQL Server troubleshooting methodology
- Troubleshooting service-related issues
- Troubleshooting connection and connectivity issues
- Common troubleshooting
Module XIV: Data Import and Export
- Data transfer to/from SQL Server
- Importing and exporting table data
- Using BCP and BULK INSERT to import data
- Implementation and updating of data-level applications
Part 2: Provisioning SQL Databases
- Introduction to the SQL Server platform
- Overview of SQL Server architecture
- SQL Server services and configuration options
Module II: Installation of SQL Server 2019
- Considerations for installing SQL Server
- TempDB Files
- Installation of SQL Server 2019
- Automation of the installation
Module III: Upgrading SQL Server to SQL Server 2019
- Upgrade requirements
- Upgrade SQL Server services
- Migration of SQL Server data and applications
Module IV: Working with Databases
- Introduction to SQL Server Databases
- Creating Databases
- Database Files and Filegroups
- Moving Database Files
- Extending the Buffer Pool
Module V: Database Storage Options
- SQL Server Storage Performance
- SMB Fileshare
- Stretch Databases
Module I: Data Fundamentals
- Data fundamentals
- 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 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: The Role of the Azure Database Administrator
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
Module II: Planning and Implementing Data Platform Resources
- Implementation of SQL Server using IaaS
- Implementation of SQL Server using PaaS
- Implementation of open-source database solutions on Azure
Module III: Implementing a Secure Environment
- Configure database authentication
- Configure database authorization
- Implement security for data at rest
- Implement security for data in transit
- Implement compliance controls for sensitive data
Module IV: Monitoring and Optimizing Operational Resources
- Baseline and performance monitoring
- Main causes of performance issues
- Resource configuration for optimal performance
- User database configuration
- Performance-related maintenance tasks
Module V: Optimize Query Performance
- Understand SQL Server query plans
- Explore performance-based database design
- Evaluate performance improvements
Module VI: Task Automation
- Configuration of automatic deployment
- Definition of scheduled tasks
- Configuration of extended events
- Management of Azure PaaS resources through automated methods
Module VII: Planning and Implementing a High Availability and Disaster Recovery Environment
- High availability and disaster recovery strategies
- IaaS platform and database tools for HADR
- PaaS platform and database tools for HADR
- Database backup and recovery
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
To participate in this training, attendees must meet the following requirements:
- Basic computer concepts
- General knowledge about relational databases
- Familiarity with SQL and basic consultations
- Interest in Business Database Administration
- These requirements guarantee that participants can focus on the 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 Sql Databases Fundamentals + Administrator Sql Server 2019 + Azure Database Administrator | 96 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
To participate in this training, attendees must meet the following requirements:
- Basic computer concepts
- General knowledge about relational databases
- Familiarity with SQL and basic consultations
- Interest in Business Database Administration
- These requirements guarantee that participants can focus on the 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 Sql Databases Fundamentals + Administrator Sql Server 2019 + Azure Database Administrator | 96 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.