Oracle Database 23ai: SQL Workshop Live Class



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Aug 12, 202409:0005:00EDTLive Virtual Class5$4,000 USDPurchase
Oct 7, 202409:0005:00EDTLive Virtual Class5$4,000 USDPurchase
Dec 2, 202411:0007:00ESTLive Virtual Class5$4,000 USDPurchase


Oracle Database 23ai: SQL Workshop Live Class

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.

Duration: 5 Days


  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using Set Operators
  • Managing Tables Using DML Statements
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, and 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
  • Table Descriptions
    • Using SQL Developer
    • Using SQL*Plus
    • Commonly Used SQL Commands
    • Generating Reports by Grouping Related Data
    • Hierarchical Retrieval
    • Writing Advanced Scripts
    • Oracle Database Architectural Components
    • Regular Expression Support
    • MySQL Syntax
Right Menu IconMENU