Live Panel Discussion - Leveraging Red Hat OpenShift for a Multi-Cloud Strategy

closeClose

Using Java - for PL/SQL and Database Developers

Course Details
Code: D80194GC10
Tuition (CAD): $1,930.00 • Classroom (2 days)

Familiarity with SQL Developer, SQL*Plus

Skills Gained

  • Add new users with different levels of access privileges
  • Manage schema objects
  • Run data definition language (DDL) statements to create and manage schema objects
  • Manage objects with data dictionary views
  • Control database access to specific objects
  • Manipulate large data sets in the Oracle database by using subqueries
  • Manage data in different time zones
  • Write multiple-column subqueries
  • Use scalar and correlated subqueries

Who Can Benefit

  • Application Developers
  • Forms Developer
  • Functional Implementer
  • PL/SQL Developer
  • System Analysts

Prerequisites

  • Familiarity with SQL Developer, SQL*Plus
  • Basic Knowledge of SQL

Course Details

Introduction

  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Provide an insight of the development environments
  • Tables used in the Course
  • Review of the SQL Concepts

Introduction to Data Dictionary Views

  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary Views
  • Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes

  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes

Creating Views

  • Overview of views

Managing Schema Objects

  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables

Retrieving Data by Using Subqueries

  • Retrieving Data by Using a Subquery as Source
  • Working with Multiple-Column subqueries
  • Using Scalar subqueries in SQL
  • Correlated Subqueries
  • Working with the WITH clause

Manipulating Data by Using Subqueries

  • Using Subqueries to Manipulate Data
  • Inserting by Using a Subquery as a Target
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Using Correlated Subqueries to Update and Delete rows

Controlling User Access

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

Manipulating Data

  • Overview of the Explicit Default Feature
  • Using multitable INSERTs
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking Changes in Data

Managing Data in Different Time Zones

  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types
  • Using Datetime functions in queries