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 |
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
Tags: Database, Database Management, Oracle Database, 23ai, RAG, SQL, PL/SQL, DBA, AI, Artificial Intelligence, Machine Learning, LLM