Virtual Instructor-Led Training

Onsite Training

Oracle Database: SQL Workshop II Ed 2

AI & Data

Oracle SQL

Oracle

<ul><li>Course Objectives, Course Agenda and Appendixes Used in this Course</li><li>Provide an insight of the development environments</li><li>Tables used in the Course</li><li>Review of the SQL Concepts</li></ul>

Introduction

<ul><li>Introduction to Data Dictionary</li><li>Describe the Data Dictionary Structure</li><li>Using the Data Dictionary views</li><li>Querying the Data Dictionary Views</li></ul>

Introduction to Data Dictionary Views

<ul><li>Overview of sequences</li><li>Overview of synonyms</li><li>Overview of indexes</li></ul>

Creating Sequences, Synonyms, Indexes

Creating Views

<ul><li>Managing constraints</li><li>Creating and using temporary tables</li><li>Creating and using external tables</li></ul>

Managing Schema Objects

<ul><li>Retrieving Data by Using a Subquery as Source</li><li>Working with Multiple-Column subqueries</li><li>Using Scalar subqueries in SQL</li><li>Correlated Subqueries</li><li>Working with the WITH clause</li></ul>

Retrieving Data by Using Subqueries

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

Manipulating Data by Using Subqueries

<ul><li>System privileges</li><li>Creating a role</li><li>Object privileges</li><li>Revoking object privileges</li></ul>

Controlling User Access

<ul><li>Overview of the Explicit Default Feature</li><li>Using multitable INSERTs</li><li>Using the MERGE statement</li><li>Performing flashback operations</li><li>Tracking Changes in Data</li></ul>

Manipulating Data Using Advanced Queries

<ul><li>Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP</li><li>Working with INTERVAL data types</li><li>Using Datetime functions in queries</li></ul>

Managing Data in Different Time Zones

Microsoft Azure

courseBanner

Course Banner

courseOverview

Course Overview section

courseAnnouncement

Additional information.

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Microsoft

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

Autodesk

Cloud

Security

Networking

App Development

Architecture & Design

Business Applications

Business Process

Business & Leadership

e-Learning

Trainings

Managed Learning Services

NetCom365

Learning Passport

EdAssist

Talents for Hire

NetCom Learning Academy

AI Summer Skill Fest 2025

Financial Services

Healthcare

Federal Government

State & Local Government

Technology

Complimentary AI+ Foundation™ Training

Free AI Training Consultation

AI Certs Training Bundles

CompTIA Continuing Education (CE)

CompTIA Exam Prep e-Learning Bundles

Microsoft ECIF Program

Microsoft QuickStart Program

Microsoft Partner Training

Microsoft AI Bootcamp for Educators

Microsoft Applied Skills

AWS Skill Builder

AWS Blended Learning

AWS Learning Needs Analysis (LNA)

AWS e-Learning

Cisco Continuing Education (CE)

Cisco Learning Credits

Cisco U

Free Networking Training Consultation

Google Cloud Leadership AI Training

Solutions

Resources

Company

Oracle Database: SQL Workshop II Ed 2

Upcoming Schedules

Course Prerequisites

Required

Course Outline