• Oracle Database 23ai PL/SQL Workshop

Oracle Database 23ai PL/SQL Workshop

This course is designed for Developers and Database Administrators, beginning with the foundational concepts of relational databases and the PL/SQL programming language. It covers writing Executable Statements against single and multiple tables, Declaring PL/SQL Variables, Working with Composite Data Types, manipulating data within tables, and conditionally control code flows. Participants will learn how to create Stored Procedures and Functions, Triggers, Packages, manage schema objects.

Certification: This course will help you to pass the Oracle Database 23ai SQL and Administration Associate | 1Z0-171 and 1Z0-182 exams.


On successful Completion of the Fundamentals of Modelling course you will be able to:


  • Write Executable Statements
  • Declaring PL/SQL Variables
  • Working with Composite Data Types
  • Conditionally control code flow (loops, control structures)
  • Explicit cursors
  • Handle runtime errors
  • Describe and Create PL/SQL Stored Procedures and Functions
  • Describe and Create PL/SQL Triggers
  • Describe and Create PL/SQL Packages
  • Employ PL/SQL functions to generate and retrieve customized data
  • Utilise new JSON features and improvements
  • Blockchain Table
Course Requirements
Prerequisites Existing database administration experience on a modern version of Oracle Database.
Target Audience
Audience Database Administrators Data Warehouse Administrators Database Designers Support Engineers

Write a review

Please login or register to review

Oracle Database 23ai PL/SQL Workshop

  • Brand: Weblearning Publishing
  • Product Code: Oracle Database 23ai PL/SQL Workshop
  • Reward Points: 100
  • Availability: In Stock
  • £139.99
  • £124.99

  • Price in reward points: 1500

  • 2 or more £110.99
  • 4 or more £99.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database, Database Management, Oracle Database, 23ai, RAG, SQL, PL/SQL, DBA, AI, Artificial Intelligence, Machine Learning, LLM