Duración

5 días - 30 horas

Descripción

The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Objetivos

  • Identify the major components of an Oracle Database
  • Retrieve row and column data from tables with the SELECT statements
  • Create reports of sorted and restricted data
  • Employee SQL functions

Contenidos del curso

  1. Introduction
  2. Retrieving Data Using the SQL SELECT Statement
  3. Restricting and Sorting Data
  4. Using Single-Row Functions to Customize Output
  5. Using Conversion Functions and Conditional Expressions
  6. Reporting Aggregated Data Using the Group Functions
  7. Displaying Data from Multiple Tables Using Joins
  8. Using Subqueries to Solve Queries
  9. Using Set Operators
  10. Managing Tables Using DML Statements in Oracle
  11. Managing Tables Using DML Statements in MySQL
  12. Introduction to Data Definition Language in Oracle
  13. Introduction to Data Definition Language in MySQL
  14. Introduction to Data Dictionary Views
  15. Creating Sequences, Synonyms, and Indexes
  16. Creating Views
  17. Managing Schema Objects
  18. Retrieving Data by Using Subqueries
  19. Manipulating Data by Using Subqueries
  20. Controlling User Access
  21. Manipulating Data Using Advanced Queries
  22. Managing Data in Different Time Zones
  23. Conclusion

Información general

Área formativa

Cursos ELS Oracle Database

Fabricante

Oracle

Metodología

Presencial | Learning virtual class

Certificación

Propia del fabricante

 

¿TIENES DUDAS? PREGÚNTANOS

    He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

     

     

    Fecha y precios de nuestros cursos

    Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
    17 Jun 2024
    De 9.00 a 15.00 horas
    Formación en Aula Virtual
    2.395,00€+IVA

    ¿Necesitas Ayuda?

    Consúltanos si necesitas información de nuestros cursos o masters.

     

    Contacta con Core Networks