Skip to content

Campaigns
Free Workshops
Principals
Blog & Resources
Facilities Rental
Team Building

All Courses

Search for:

HRD Corp Claimable

My Account
- Username:
  Password:
  Remember Me
  Register
Request a Quote
WooCommerce Cart

Menu

Principals
All Courses
Campaigns
Free Workshops
Blog & Resources
Modalities
Facilities Rental
My Account

Cart

Search for:

Home » Oracle Education » Oracle Database » OD-23ai-SQLW: Oracle Database 23ai: SQL Workshop

OD-23ai-SQLW: Oracle Database 23ai: SQL Workshop

Enhance Your SQL Skills with Oracle Database 23ai.

Elevate your SQL expertise with the Oracle Database 23ai. Designed for database professionals and developers, this course offers in-depth training on the latest SQL features and enhancements in Oracle Database 23ai. Learn to write efficient queries, leverage advanced SQL functions, and optimize database performance.

Gain practical skills to manage and analyze data more effectively, making the most of Oracle’s cutting-edge SQL capabilities.

Oracle Database 23ai Q1 Promo: Sign-up and enjoy 5% OFF for upcoming 3-7 Mar 2025 intake.

Fees:

RM6,500.00

Course duration

5 days

Accredited by

Array
(
    [ID] => 8287
    [id] => 8287
    [title] => oracle
    [filename] => oracle.svg
    [filesize] => 1870
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
    [link] => https://trainocate.com.my/?attachment_id=8287
    [alt] => Oracle Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => oracle
    [status] => inherit
    [uploaded_to] => 9057
    [date] => 2021-08-25 01:59:22
    [modified] => 2021-12-24 07:10:28
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

Home » Oracle Education » Oracle Database » OD-23ai-SQLW: Oracle Database 23ai: SQL Workshop

OD-23ai-SQLW: Oracle Database 23ai: SQL Workshop

Enhance Your SQL Skills with Oracle Database 23ai.

Elevate your SQL expertise with the Oracle Database 23ai. Designed for database professionals and developers, this course offers in-depth training on the latest SQL features and enhancements in Oracle Database 23ai. Learn to write efficient queries, leverage advanced SQL functions, and optimize database performance.

Gain practical skills to manage and analyze data more effectively, making the most of Oracle’s cutting-edge SQL capabilities.

Oracle Database 23ai Q1 Promo: Sign-up and enjoy 5% OFF for upcoming 3-7 Mar 2025 intake.

Course duration:

5 days

Fees:

RM6,500.00

Accredited by:

Array
(
    [ID] => 8287
    [id] => 8287
    [title] => oracle
    [filename] => oracle.svg
    [filesize] => 1870
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
    [link] => https://trainocate.com.my/?attachment_id=8287
    [alt] => Oracle Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => oracle
    [status] => inherit
    [uploaded_to] => 9057
    [date] => 2021-08-25 01:59:22
    [modified] => 2021-12-24 07:10:28
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

HRD Corp SBL-Khas Claimable

Overview
Course Curriculum
Training Options
Exam & Certification
FAQs

Overview

This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.

You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.

Skills Covered

Learn to:

Retrieve Data using the SQL SELECT Statement
Restrict and Sort Data
Customize Output Using Single-Row Functions
Use Conversion Functions and Conditional Expressions
Report Aggregated Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Manage Tables by Using DML Statements
Create Sequences, Synonyms, Indexes, Views, and Schema Objects
Manage Data by Using Subqueries and Advanced Queries
Control User Access and Manage Data in Different Time Zones

Who Should Attend

Database Administrator
Developer

Course Curriculum

Prerequisites

There are no prerequisites required to attend this course.

Download Syllabus

Download Course Syllabus

First Name*

Last Name*

Email*

Phone*

Download Link

Request a callback*

Yes - Please reach out to me

No - That's all for now

This field should be left blank

Course Modules

Expand all Collapse all

Module 1: Course Overview

Course Overview – Oracle Database 23ai: SQL Workshop
Course Practice Environment: Security Credentials

Module 2: Oracle Database 23ai SQL Enhancements

Oracle Database 23ai SQL New Features
Returning clause of UPDATE and MERGE Statements, IF (NOT) EXISTS

Module 3: Introduction to SQL and Database Concepts

Overview of Oracle Database 23ai and Related Products
Overview of Relational Database Management Concepts and Terminologies
Human Resources (HR) Schema and the Tables Used in This Course
Introduction to SQL and Its Development Environments
Oracle Database 23ai SQL Documentation and Additional Resources

Module 4: Retrieving Data Using the SQL SELECT Statement

Capabilities of SQL SELECT Statements
Arithmetic Expressions and NULL Values in the SELECT statement
Column Aliases
Use of the Concatenation Operator, Literal Character Strings, Alternative Quote Operator, and the DISTINCT Keyword
DESCRIBE Command

Module 5: Restricting and Sorting Data

Limiting Rows
Rules of Precedence for Operators in an Expression
Sorting Rows Using the ORDER BY Clause
SQL Row Limiting Clause in a Query
Substitution Variables in Oracle
Assigning Values to Variables
Practices for Lesson 3: Restricting and Sorting Data

Module 6: Using Single-Row Functions to Customize Output

Single-Row SQL Functions
Character Functions
Nesting Functions
Number Functions
Working with Dates in Oracle Databases
Date Functions

Module 7: Using Conversion Functions and Conditional Expressions

Implicit and Explicit Data Type Conversion
TO_CHAR, TO_DATE, and TO_NUMBER Functions in Oracle
General Functions
Conditional Expressions

Module 8: Reporting Aggregated Data Using the Group Functions

JSON Functions
Reporting Aggregated Data Using the Group Functions/Group Functions
Grouping Rows
Nesting Group Functions

Module 9: Displaying Data from Multiple Tables Using Joins

Displaying Data from Multiple Tables Using Joins
Natural Join
Join with the USING Clause
Join with the ON Clause
Self-Join
Nonequijoins
Outer Join
Cartesian Product

Module 10: Using Subqueries to Solve Queries

Using Subqueries to Solve Queries
Single-Row Subqueries
Multiple-Row Subqueries
Multiple-Column Subqueries
Null Values in a Subquery

Module 11: Using Set Operators

Using Set Operators
Tables Used in This Lesson
UNION and UNION ALL Operators
INTERSECT Operator
MINUS Operator
Matching SELECT Statements
Using the ORDER BY Clause in Set Operations

Module 12: Manipulating Data

Managing Tables Using DML Statement
Changing Data in a Table
Removing Rows from a Table
Database Transaction Control
Read Consistency
Manual Data Locking

Module 13: Introduction to Data Definition Language

Introduction to Data Definition Language
CREATE TABLE Statement
Data Types
Constraints: Overview
Creating a Table by Using a Subquery
ALTER TABLE Statement
DROP TABLE Statement

Module 14: Introduction to Data Dictionary Views

Introduction to Data Dictionary
Querying the Dictionary Views
Adding a Comment to a Table and Querying the Dictionary Views

Module 15: Creating Sequences, Synonyms, and Indexes

Create, Maintain, and Use Sequences
Create Private and Public Synonyms
Create and Maintain Indexes

Module 16: Creating Views

Creating Views
Creating, Modifying, and Retrieving Data from a View
Data Manipulation Language (DML) Operations on a View
Dropping a View

Module 17: Managing Schema Objects

Managing Schema Objects
Create and Use Temporary Tables
Creating and Using External Tables

Module 18: Retrieving Data Using Subqueries

Retrieving Data by Using a Subquery as a Source
Writing a Multiple -Column Subquery
Using Scalar Subqueries in SQL
Solving Problems with Correlated Subqueries
Using the EXISTS and NOT EXISTS Operators
Using the WITH Clause

Module 19: Manipulating Data Using Subqueries

Manipulating Data by Using Subqueries
Inserting Values by Using a Subquery as a Target
Using the WITH CHECK OPTION keyword on DML statements
Using Correlated Subqueries to Update and Delete Rows

Module 20: Controlling User Access

Controlling User Access
Creating a Role
Object Privileges
Revoking Object Privileges

Module 21: Manipulating Data Using Advanced Queries

Manipulating Data Using Advanced Queries
Multitable INSERTs
Merging Rows in a Table
Performing Flashback Operations
Tracking the Changes in Data Over a Period of Time

Module 22: Managing Data in Different Time Zones

Managing Data in Different Time Zones
INTERVAL Data Types
Aggregation over INTERVAL types
Additional Date Functions
SYSDATE and SYSTIMESTAMP Data Handling

Request More Information

I'm inquiring for

Myself

My Company

By providing your contact details, you agree to our Privacy Policy

This field should be left blank

Training Options

Filter by:

ILT: Instructor-Led Training
VILT: Virtual Instructor-Led Training

Intake: 9-13 Jun 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 9-13 Jun 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 22-26 Sep 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 22-26 Sep 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 15-19 Dec 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 15-19 Dec 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Exam & Certification

Oracle Database 23ai SQL Associate (1Z0-171).

Training & Certification Guide

Frequently Asked Questions

Stay connected. Be the first to know.

Company

About Us
Blog & Resources
Modalities
Career
Become Our Trainer
Contact Us

Customer Service

My Account
Payment & Policies
PDPA
Copyright & Trademarks

Principals

Microsoft Certified
Red Hat Training
Google Cloud Certified
IBM Education
DELL-EMC
View All

2024 TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE-01

HRD Corp Training Provider 2

Stay connected. Be the first to know.

TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE 2024

HRD Corp Training Provider 2

No. 1 IT Training Center & Provider in Malaysia

Trainocate is the new and exciting development of the 25-year old establishment – Global Knowledge. The name Trainocate is inspired from the term “Training Advocate” which resonates the feeling of continuous learning, something that each member of the Trainocate team carries with them. We are in the business of empowering work forces in the Asia-Pacific region by maximizing their capabilities through training and certification. This not only helps with improving work performance but also, explores untapped potential within each individual.

Located in KL Eco City and just next to Mid Valley City, Trainocate Malaysia is a HRD Corp Registered Training Provider and Authorized Training Partner for big tech companies such as AWS, Alibaba Cloud, Cisco, Dell EMC, Fortinet, Google Cloud, IBM, Microsoft, NetApp, Nutanix, Oracle, Splunk, Red Hat, Trend Micro, and VMware. We also provide a broad range of human capital development and people skills training to individuals and organizations under American Management Association (AMA).

Years of experience in IT Training Provider Industry equates to bettering ourselves to ensure we deliver only the best training programs to our loyal clients, both in technology and people skills.

© Copyright Trainocate 2024. All rights reserved. IT Training Provider Malaysia

Use "Up" and "Down" arrows to move between options

Click the right arrow to expand children, left arrow to collapse.