Oracle Database SQL Workshop II Ed 2

Course overview for Oracle Database SQL Workshop II Ed 2

The Oracle Database SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Course Information

  • Delivery Method: Classroom
  • Course Duration: 2 days
  • Course Level: Advanced

Audience Summary

  • Oracle Databases Administrators
  • PL/SQL Developers

Prerequisites for the course Oracle Database SQL Workshop II Ed 2

  • Oracle Database: Introduction to SQL Ed 2 course
  • Oracle Database: SQL Workshop II Ed 2 course
  • And Oracle Databases concepts

Learn To

  • Grant and revoke privileges and roles.
  • Manage schema objects and data dictionary views.
  • Write efficient and complex subqueries.
  • Use the in-built functions supporting the usage of regular expressions and time zone..

Course content summary for Oracle Database SQL Workshop II Ed 2

  • Introduction
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data Using Advanced Queries
  • Managing Data in Different Time Zones.

More Evolutiontech Courses for Oracle Database

Fale Conosco

Solicite o completo ao nosso departamento comercial

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *