Oracle Database 19C: SQL Workshop (1Z0-082)

Oracle Database 19C: SQL Workshop Course (1Z0-082)

This course is designed to provide comprehensive training in management and manipulation of databases with SQL Oracle, covering from the creation of consultations and reports to the advanced administration of data and structures in Oracle Database 19C. The course prepares participants to obtain …

30 hours
Official Certificate
Expert Instructors
Online Learning
Oracle Database 19C: SQL Workshop (1Z0-082)
Oracle Academy logo

This course is designed to provide comprehensive training in management and manipulation of databases with SQL Oracle, covering from the creation of consultations and reports to the advanced administration of data and structures in Oracle Database 19C.

The course prepares participants to obtain international certification:

Oracle Database SQL (1Z0-082).

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

  • • Identify the main structural components of Oracle Database 19C
  • • Execute SQL sentences for handling and data management
  • • Create and manage tables, views and sequences
  • • Implement advanced consultations and subconsultations
  • • Manage user privileges and roles in Oracle Database
  • • Develop structured and aggregate data reports
  • • Use advanced operators and SQL functions to customize consultations
  • • Prepare for Oracle SQL 1Z0-082 certification

Courses

  1. Certificación internacional Sql Databases Fundamentals

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

  • • Familiarity with data processing concepts and techniques
  • • Basic knowledge of computer science and databases
  • These requirements guarantee that participants can focus on SQL administration and development in Oracle without initial technical difficulties

Oracle Database 19C: SQL Workshop (1Z0-082) Applies
Oracle Database 19C: SQL Workshop (1Z0-082) 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

This course is designed to provide comprehensive training in management and manipulation of databases with SQL Oracle, covering from the creation of consultations and reports to the advanced administration of data and structures in Oracle Database 19C.

The course prepares participants to obtain international certification:

Oracle Database SQL (1Z0-082).

Objectives

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

  • • Identify the main structural components of Oracle Database 19C
  • • Execute SQL sentences for handling and data management
  • • Create and manage tables, views and sequences
  • • Implement advanced consultations and subconsultations
  • • Manage user privileges and roles in Oracle Database
  • • Develop structured and aggregate data reports
  • • Use advanced operators and SQL functions to customize consultations
  • • Prepare for Oracle SQL 1Z0-082 certification

Courses

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

  • • Familiarity with data processing concepts and techniques
  • • Basic knowledge of computer science and databases
  • These requirements guarantee that participants can focus on SQL administration and development in Oracle without initial technical difficulties

offers

Oracle Database 19C: SQL Workshop (1Z0-082) Applies
Oracle Database 19C: SQL Workshop (1Z0-082) 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

Introduction

  • Course objectives, course syllabus, and appendices used in this course
  • Overview of Oracle 12c and related products
  • General description of relational database concepts and terminology
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer
  • Accessing SQL Plus from SQL Developer
  • The Human Resources (HR) schema
  • Tables used in the course

  • Capabilities of the SELECT statement
  • Arithmetic expressions and handling of null values
  • Aliases in columns
  • Use of concatenation operators, character strings, the quote operator, and the DISTINCT keyword
  • Use of the Describe command

  • Filtering records
  • Operator precedence rules in an expression
  • Variable substitution
  • Using the DEFINE and VERIFY commands

  • Present the differences between single record functions and multiple record functions
  • Manipulate character strings with the select and where clauses
  • Manipulate numbers with the ROUND, TRUNC, and MOD functions
  • Perform arithmetic operations with dates
  • Manipulate dates with date functions

  • Describe implicit and explicit data type conversion
  • Utilize the conversion functions TO_CHAR, TO_NUMBER, and TO_DATE
  • Group multiple functions
  • Apply the functions NVL, NULLIF, and COALESCE to the data
  • Use the conditional logic IF THEN ELSE in a Select statement

  • Group Functions
  • Creating Data Groups
  • Restricting Group Results

  • Introduction to Joins
  • Types of Joins
  • Natural Join
  • Self-join
  • Non-equi Joins
  • Outer Join

  • Introduction to Subqueries
  • Subqueries in Single Rows
  • Subqueries in Multiple Rows

  • SET Operators
  • UNION and UNION ALL Operator
  • INTERSECT Operator
  • MINUS Operator
  • Matches of SELECT statements
  • Using the order by clause with SET operators

  • Data Manipulation Language
  • Database Transactions

  • Introduction to the data dictionary
  • Describing the structure of data dictionaries
  • Using data dictionary views
  • Querying data dictionary views

  • General description of sequences
  • General description of synonyms
  • General description of indexes

  • General description of views

  • Displaying data using subqueries as a path
  • Working with multiple columns
  • Using Scalar queries in SQL
  • Correlated Subqueries
  • Working with the With clause

  • Using subqueries to manipulate data
  • Insertion using subquery as target
  • Using the WITH CHECK POINT clause in DML statements
  • Using correlated subqueries to update and delete fields

  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges

  • General description
  • Using INSERT across multiple tables
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking changes in data

  • Working with CURRENT_DATE, CURRENT TIMESTAMP, and LOCALTIMESTAMP
  • Working with INTERVAL in data types