[NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c

[NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c, available at $19.99, has an average rating of 4.18, with 193 lectures, based on 129 reviews, and has 740 subscribers.

You will learn about Anonymous Block Control Structure Error handling Cursors Procedure, Function Triggers Packages Dynamic SQL Collections PL/SQL Compiler Dependencies Pipeline Functions Handling LOBs Security Performance Tuning Bulk Collect Caching Best Practices Real life Examples Lots of coding Practice Latest version of PL/SQL on Oracle 21c Course by Professionals for Professionals Instructor has 10+ years real time experience in PL/SQL Brand New Course Published on 16th Sep 2023 This course is ideal for individuals who are Database Developers or Data Analysts or ETL Developers or Database Administrators or Application Designers or QA Professional to write stored procedures for data validations. or DBA – Database Administrator For Automating Jobs and Securitiy Implemetation or Anybody Interested to Learn PL/SQL Programming Language or Anybody looking for Advanced PL/SQL concepts. or Brand New Course Published on 16th Sep 2023 It is particularly useful for Database Developers or Data Analysts or ETL Developers or Database Administrators or Application Designers or QA Professional to write stored procedures for data validations. or DBA – Database Administrator For Automating Jobs and Securitiy Implemetation or Anybody Interested to Learn PL/SQL Programming Language or Anybody looking for Advanced PL/SQL concepts. or Brand New Course Published on 16th Sep 2023.

Enroll now: [NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c

Summary

Title: [NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c

Price: $19.99

Average Rating: 4.18

Number of Lectures: 193

Number of Published Lectures: 191

Number of Curriculum Items: 193

Number of Published Curriculum Objects: 191

Original Price: ₹4,499

Quality Status: approved

Status: Live

What You Will Learn

Anonymous Block
Control Structure
Error handling
Cursors
Procedure, Function
Triggers
Packages
Dynamic SQL
Collections
PL/SQL Compiler
Dependencies
Pipeline Functions
Handling LOBs
Security
Performance Tuning
Bulk Collect
Caching
Best Practices
Real life Examples
Lots of coding Practice
Latest version of PL/SQL on Oracle 21c
Course by Professionals for Professionals
Instructor has 10+ years real time experience in PL/SQL
Brand New Course Published on 16th Sep 2023

Who Should Attend

Database Developers
Data Analysts
ETL Developers
Database Administrators
Application Designers
QA Professional to write stored procedures for data validations.
DBA – Database Administrator For Automating Jobs and Securitiy Implemetation
Anybody Interested to Learn PL/SQL Programming Language
Anybody looking for Advanced PL/SQL concepts.
Brand New Course Published on 16th Sep 2023

Target Audiences

Database Developers
Data Analysts
ETL Developers
Database Administrators
Application Designers
QA Professional to write stored procedures for data validations.
DBA – Database Administrator For Automating Jobs and Securitiy Implemetation
Anybody Interested to Learn PL/SQL Programming Language
Anybody looking for Advanced PL/SQL concepts.
Brand New Course Published on 16th Sep 2023

Oracle PL/SQL Training Syllabus

<< Note:Brand New Course Published on16th Sep 2023 >>

Introduction to PL/SQL

PL/SQL Overview
Benefits of PL/SQL Subprograms
Overview of the Types of PL/SQL blocks
Create a Simple Anonymous Block
Generate Output from a PL/SQL Block

PL/SQL Identifiers

List the different Types of Identifiers in a PL/SQL subprogram.
Usage of the Declarative Section to define Identifiers.
Use variables to store data.
Identify Scalar Data Types
The %TYPE Attribute
What are Bind Variables?
Sequences in PL/SQL Expressions

Write Executable Statements

Describe Basic PL/SQL Block Syntax Guidelines
Comment Code
Deployment of SQL Functions in PL/SQL
How to convert Data Types?
Nested Blocks
Identify the Operators in PL/SQL

Interaction with the Oracle Server

Invoke SELECT Statements in PL/SQL to Retrieve data.
Data Manipulation in the Server Using PL/SQL
SQL Cursor concept
Usage of SQL Cursor Attributes to Obtain Feedback on DML
Save and Discard Transactions

Control Structures

Conditional processing Using IF Statements
Conditional processing Using CASE Statements
Use simple Loop Statement
Use While Loop Statement
Use For Loop Statement
Describe the Continue Statement

Explicit Cursors

What are Explicit Cursors?
Declare the Cursor
Open the Cursor
Fetch data from the Cursor
Close the Cursor
Cursor FOR loop
Explicit Cursor Attributes
FOR UPDATE Clause and WHERE CURRENT Clause

Exception Handling

Understand Exceptions
Handle Exceptions with PL/SQL
Trap Predefined Oracle Server Errors
Trap Non-Predefined Oracle Server Errors
Trap User-Defined Exceptions
Propagate Exceptions
RAISE_APPLICATION_ERROR Procedure

Stored Procedures and Functions

Understand Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms.
Create a Simple Procedure
Create a Simple Procedure with IN parameter.
Create a Simple Function
Execute a Simple Procedure
Execute a Simple Function

Create Stored Procedures

Create a Modularized and Layered Subprogram Design
Modularize Development With PL/SQL Blocks
Describe the PL/SQL Execution Environment
Identity the benefits of Using PL/SQL Subprograms
List the differences Between Anonymous Blocks and Subprograms
Create, Call, and Remove Stored Procedures Using the CREATE Command and SQL Developer
Implement Procedures Parameters and Parameters Modes
View Procedures Information Using the Data Dictionary Views and SQL Developer

Create Stored Functions

Create, Call, and Remove a Stored Function Using the CREATE Command and SQL Developer
Identity the advantages of Using Stored Functions in SQL Statements
List the steps to create a stored function.
Implement User-Defined Functions in SQL Statements
Identity the restrictions when calling Functions from SQL statements.
Control Side Effects when calling Functions from SQL Expressions
View Functions Information

Create Packages

Identity the advantages of Packages
Describe Packages
List the components of a Package.
Develop a Package
How to enable visibility of a Package’s components?
Create the Package Specification and Body Using the SQL CREATE Statement and SQL Developer
Invoke Package Constructs
View PL/SQL Source Code Using the Data Dictionary

Implement Oracle-Supplied Packages in Application Development

What is Oracle-Supplied Packages?
Examples of Some of the Oracle-Supplied Packages
How Does the DBMS_OUTPUT Package Work?
Use the UTL_FILE Package to Interact With Operating System Files
Invoke the UTL_MAIL Package
Write UTL_MAIL Subprograms

Triggers

Describe Triggers
Identify the Trigger Event Types and Body
Business Application Scenarios for Implementing Triggers
Create DML Triggers Using the CREATE TRIGGER Statement and SQL Developer
Identify the Trigger Event Types, Body, and Firing (Timing)
Statement Level Triggers Versus Row Level Triggers
Create Instead of and Disabled Triggers
How to Manage, Test, and Remove Triggers?

Create Compound, DDL, and Event Database Triggers

What are Compound Triggers?
Identify the Timing-Point Sections of a Table Compound Trigger
Compound Trigger Structure for Tables and Views
Implement a Compound Trigger to Resolve the Mutating Table Error
Compare Database Triggers to Stored Procedures
Create Triggers on DDL Statements
Create Database-Event and System-Event Triggers
System Privileges Required to Manage Triggers

Composite Data Types – Collections

Use PL/SQL Records
The %ROWTYPE Attribute
Insert and Update with PL/SQL Records
Associative Arrays (INDEX BY Tables)
Examine INDEX BY Table Methods
Use INDEX BY Table of Records

Dynamic SQL

The Execution Flow of SQL
What is Dynamic SQL?
Declare Cursor Variables
Dynamically executing a PL/SQL Block
Configure Native Dynamic SQL to Compile PL/SQL Code
Invoke DBMS_SQL Package
Implement DBMS_SQL with a Parameterized DML Statement
Dynamic SQL Functional Completeness

PL/SQL Advanced

Packages

Overloading Subprograms in PL/SQL
Use Forward Declarations to Solve illegal Procedure Reference
Persistent State of Packages Variables
Persistent State of a Package Cursor

Manage Dependencies

Overview of Schema Object Dependencies
Query Direct Object Dependencies using the USER_DEPENDENCIES View
Query an Object’s Status
Invalidation of Dependent Objects
Display the Direct and Indirect Dependencies
Understand Remote Dependencies
Recompile a PL/SQL Program Unit

Pipeline functions

What are pipeline functions?
Create is pipeline functions.
Check PGA memory consumption pipeline functions.
Error handling pipeline functions

The Trainer is an Architect with over 19+ years of experience, he has spent 10+ years working with PL/SQL

An Oracle Certified Professions (OCP)

Oracle Technology Network (OTN) Points:12,975 Level:Master

Course Curriculum

Chapter 1: Introduction

Lecture 1: PL/SQL Overview

Lecture 2: Course Structure and How to Maximize Its Benefits

Lecture 3: Message From Trainer

Chapter 2: Environment Setup

Lecture 1: Live SQL cloud account creation, demo data setup

Lecture 2: Oracle 21c – XE Installation

Lecture 3: Multitenant Architecture overview

Lecture 4: Create PDB, Schema user, Connect to 21C from Oracle SQL Developer

Chapter 3: PL/SQL – Anonymous Block

Lecture 1: Create a Simple Anonymous Block

Lecture 2: Overview of the Types of PL/SQL blocks

Lecture 3: Generate Output from a PL/SQL Block

Lecture 4: Lab & Assignment – 01

Lecture 5: Solution – 01

Lecture 6: Recap

Chapter 4: PL/SQL Identifiers

Lecture 1: List the different Types of Identifiers in a PL/SQL subprogram

Lecture 2: Usage of the Declarative Section to define Identifiers

Lecture 3: Use variables to store data

Lecture 4: Identify Scalar Data Types

Lecture 5: The %TYPE and %ROWTYPE Attribute

Lecture 6: What are Bind Variables?

Lecture 7: Sequences in PL/SQL Expressions

Lecture 8: Lab & Assignment – 02

Lecture 9: Solution – 02

Lecture 10: Recap

Chapter 5: Write Executable Statements

Lecture 1: Describe Basic PL/SQL Block Syntax Guidelines

Lecture 2: Comment Code

Lecture 3: Deployment of SQL Functions in PL/SQL

Lecture 4: How to convert Data Types?

Lecture 5: Nested Blocks

Lecture 6: Identify the Operators in PL/SQL

Lecture 7: Assignment – 03

Lecture 8: Solution – 03

Lecture 9: Recap

Chapter 6: Interaction with the Oracle Server

Lecture 1: Invoke SELECT Statements in PL/SQL to Retrieve data

Lecture 2: Data Manipulation in the Server Using PL/SQL

Lecture 3: SQL Cursor concept

Lecture 4: Usage of SQL Cursor Attributes to Obtain Feedback on DML

Lecture 5: Save and Discard Transactions

Lecture 6: Assignment – 04

Lecture 7: Solution – 04

Lecture 8: Recap

Chapter 7: Control Structures

Lecture 1: Conditional processing Using IF Statements

Lecture 2: Conditional processing Using CASE Statements

Lecture 3: Use simple Loop Statement

Lecture 4: Use While Loop Statement

Lecture 5: Use For Loop – Part I

Lecture 6: Use For Loop – Part II

Lecture 7: Describe the Continue Statement

Lecture 8: GO TO statement

Lecture 9: NULL Statement

Lecture 10: Assignment – 05

Lecture 11: Solution – 05

Lecture 12: Recap

Chapter 8: Explicit Cursors

Lecture 1: What are Explicit Cursors?

Lecture 2: Open the Cursor, Fetch a Cursor data, Close a Cursor

Lecture 3: Cursor FOR loop

Lecture 4: Explicit Cursor Attributes

Lecture 5: FOR UPDATE Clause and WHERE CURRENT Clause

Lecture 6: Assignment – 06

Lecture 7: Solution – 06

Lecture 8: Recap

Chapter 9: Exception Handling

Lecture 1: Understand Exceptions

Lecture 2: Handle Exceptions with PLSQL

Lecture 3: Trap Predefined Oracle Server Errors

Lecture 4: Trap Non-Predefined Oracle Server Errors

Lecture 5: User-Defined Exceptions – Part I

Lecture 6: User-Defined Exceptions – Part II (RAISE_APPLICATION_ERROR)

Lecture 7: Propagate Exceptions

Lecture 8: Demo – Live Project

Lecture 9: Assignment – 07

Lecture 10: Solution – 07

Lecture 11: Recap

Chapter 10: Stored Procedures and Functions – Part I

Lecture 1: Understand Stored Procedures and Functions

Lecture 2: Create a Simple Procedure

Lecture 3: Execute a Simple Procedure

Lecture 4: Create a Simple Procedure with IN parameter

Lecture 5: Create a Simple Function

Lecture 6: Execute a Simple Function

Lecture 7: Create a Simple Function with IN parameter

Lecture 8: Demo & Assignment – 08

Lecture 9: Solution – 08

Lecture 10: Recap

Chapter 11: Stored Procedures – Part II

Lecture 1: Procedure Parameters Modes (IN / OUT/ IN OUT)

Lecture 2: Create a Modularized and Layered Subprogram Design

Lecture 3: DROP and CREATE OR REPLACE Command.

Lecture 4: View Procedures Information Using the Data Dictionary Views

Lecture 5: Lab & Assignment – 09

Lecture 6: Solution – 09

Lecture 7: Recap

Chapter 12: Stored Functions – Part II

Instructors

Global Trainers
Technical Architect

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 9 votes
4 stars: 37 votes
5 stars: 79 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu