SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental

SQL Databases Fundamentals Course and Certification

The SQL DATABASES Fundamental course is designed to provide participants with a solid understanding of relational databases, SQL language and basic database administration. This course prepares students to obtain international certification: SQL DATABASES FUNDAMENTS (SQLF-001). Aimed at peop…

30 hours
Official Certificate
Expert Instructors
Online Learning
Certificación internacional Sql Databases Fundamentals
Certitalents logo

The SQL DATABASES Fundamental course is designed to provide participants with a solid understanding of relational databases, SQL language and basic database administration.

This course prepares students to obtain international certification:

SQL DATABASES FUNDAMENTS (SQLF-001).

Aimed at people interested in starting their career in database administration, the course covers from the foundations to the management and optimization of SQL consultations.

Under the practical Learning Method approach, participants will work on laboratories, practical workshops and/or real projects, ensuring the effective application of knowledge acquired in business environments.

At the end of the course, participants will be able to:

  • Understand the basic concepts of databases, including relational and non -relational databases
  • Create and manage database objects, such as tables and schemes
  • Manipulate data through SQL sentences (SELECT, INSERT, UPDATE, DELETE)
  • Optimize SQL queries, using standardization rates and techniques
  • Apply transactions and concurrence control, ensuring the integrity of the data
  • Manage and manage databases, implementing good practices in SQL
  • Obtain the International SQL Databases Fundamental certification (SQLF-001)

To participate in this training, attendees must meet the following requirements:

  • Basic knowledge of computer science
  • These requirements ensure that participants can focus on the practical application of development with SQL without initial technical difficulties

Certificación internacional Sql Databases Fundamentals Applies
Certificación internacional Sql Databases Fundamentals 30 hours

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:
  • a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
  • b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
  • c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Pre-enrollment

You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.

Pre-enroll now

Infinity Payments

Make your payment quickly, safely and reliably


- For bank transfer payments, request the details by email capacita@aulamatriz.edu.co.

- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.

To continue you must
Or if you don't have an account you must

Description

The SQL DATABASES Fundamental course is designed to provide participants with a solid understanding of relational databases, SQL language and basic database administration.

This course prepares students to obtain international certification:

SQL DATABASES FUNDAMENTS (SQLF-001).

Aimed at people interested in starting their career in database administration, the course covers from the foundations to the management and optimization of SQL consultations.

Under the practical Learning Method approach, participants will work on laboratories, practical workshops and/or real projects, ensuring the effective application of knowledge acquired in business environments.

Objectives

At the end of the course, participants will be able to:

  • Understand the basic concepts of databases, including relational and non -relational databases
  • Create and manage database objects, such as tables and schemes
  • Manipulate data through SQL sentences (SELECT, INSERT, UPDATE, DELETE)
  • Optimize SQL queries, using standardization rates and techniques
  • Apply transactions and concurrence control, ensuring the integrity of the data
  • Manage and manage databases, implementing good practices in SQL
  • Obtain the International SQL Databases Fundamental certification (SQLF-001)

To participate in this training, attendees must meet the following requirements:

  • Basic knowledge of computer science
  • These requirements ensure that participants can focus on the practical application of development with SQL without initial technical difficulties

offers

Certificación internacional Sql Databases Fundamentals Applies
Certificación internacional Sql Databases Fundamentals 30 hours

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor(live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

La metodología persigue que el estudiante "does not memorize", but rather "understands" the concepts and how they are applied in a work environment."

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:
  • a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
  • b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
  • c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Course 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

  • 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

  • Query mechanisms
  • Query clauses
  • Select clause  
    • Alias
    • Remove duplicates
    • From clause      
    • Tables    
    • Linked tables      
    • Define table aliases
  • Where clause
  • Group by and having clause
  • Order by clause

  • Conditions
    • Use of parameters
    • Not operator
  • Construction of conditions
  • Types of conditions Equality
    • Range
    • Membership
    • Similarity
  • Null

  • 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

  • Set Theory
  • Set Theory in Practice 
  • Set Operators
    • Union
    • Intersect
    • Except
  • Rules of Set Operations
    • Ordering Compound Queries
    • Precedence of Operations

  • Working with character strings      
    • Generation      
    • Manipulation
  • Working with numeric data      
    • Arithmetic functions      
    • Controlling number precision
  • Working with temporal data      
    • Time zone      
    • Generating temporal data      
    • Manipulating temporal data

  • Grouping concepts
  • Aggregation functions      
    • Implicit versus explicit      
    • Count distinct values      
    • Using expressions      
    • How nulls are interpreted
  • Generating groupings      
    • One column      
    • Multiple columns      
    • Grouping with expressions

  • 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

  • Multi-user databases
    • Locking  
    • Granular locking
  • What is a transaction
    • Start a transaction      
    • End a transaction      
    • Transaction savepoints

  • What are views 
  • Why use views
    • Data security
    • Data aggregation
    • Hiding complexity
    • Joining partitioned tables