Oracle Oracle PLSQL

Oracle PLSQL

Catalog: Oracle
Short name: PLSQL
Course start date: 2024-07-02
Paystack
Enroll Me

Description

About PLSQL Enviornment and Benefits: Here you will learn about the PLSQL Enviornment in a better manner and the benefits in an enhanced fashion

Naming Rules, Scalar Data types: Here you will learn about naming rules, scalar data types in a much better sense

Percentage type Attributes, Composit Data Types: This section will help you understand how to read percentage type attributes and composit data types

Nested Blocks, Identifiers, Programming Guidelines: In this section, you will learn the importance of nested blocks, identifiers and programming guidelines

Package, Developing Package, Public ConstructsL: Here you will learn about the package, Developing Package, Public ConstructsL for better understanding of the industry

Implementing Triggers: This section will help you understand implementing triggers

Managing Dependencies: Here you will learn about managing dependencies in a real manner

Sections

General
0 activities

About PLSQL Enviornment and Benefits
Benefits of Sub programs ‚ Invoking Procedures and Functions
PLSQL Block Structure‚ Block Type and Program Structure
PLSQL Block Structure‚ Block Type and Program Structure count..
Naming Rules‚ Scalar Data types
Base scalar data types
Percentage type Attributes‚ Composit Data Types
Declaring Variables
PLSQL Block Syntax‚ SQL function in PLSQL
Nested Blocks‚ Identifiers‚ Programming Guidelines
Practical Examples Session 2
SQL Statements and Naming Conventions
Manipulating Data‚ Naming Conventions
SQL Cursor
Practical Examples Session 3 - 1
Practical Examples Session 3 - 2
Writing Control Structures
If Statements and Case Expressions
Logic Tables and Iterative Constructs
WHILE Loops
Practical Examples Session 4-1
Practical Examples Session 4-2
PLSQL record and rowtype Attribute
Creating and Using Index By Table
Creating and Using Index By Table (summary)
Working with Composite Data Types
Cursors‚ Declare‚ Open and Fetch cursors
Fetching Data from the Cursor
Explicit Cursor‚ Records and For Loops
Cursors and Records
Writing Explicit Cursors
Advanced Explicit Cursor
The WHERE CURRENTOF Clause
Advanced Explicit Cursor Concepts
Exception‚ Trapping Predefined Exception
Non predefined Error
Trapping User-Defined Exceptions
Handling Exceptions
PLSQL Program Constructs‚ Developing Sub Program
PLSQL Subprograms
Procedures‚ Syntax‚ Paramaters‚ In Parameters
Formal Versus Actual Parameters
Out Parameters‚ In OUTParameters and Declaring Sub Programs
Methods for Passing Parameters
Invoking Procedure‚ Handled and Unhandled Exception and Removing Procedure
Invoking Procedure‚ Handled and Unhandled Exception and Removing Procedure summary
Creating Procedures 1
Creating Procedures 2
Creating Procedures 3
Overview of Stored Functions
Creating a Stored Function by Using iSQLPlus
Invoking Functions‚ Removing Functions and Benefits
Invoking Functions‚ Removing Functions and Benefits summery
Creating Functions
Reqiured Privileges‚ Invokers Rights and User Objects
User Source‚User errors and Debugging
Managing Subprograms
Package‚ Developing Package‚ Public Constructs
Creating Package‚ Bodiless Package‚ removing Package
Practical Examples Packages
Overloading‚ Forward Declarations
Overloading
User Defined Packages ‚ PACK_Cur
Controlling the Persistent State of a Package Cursor
More Package Concepts
More Package Concepts 2
DBMS_SQL‚DBMS_DDL and DBMS_JOB
Using DBMS_SQL
Submitting Jobs‚ UTL_FILES and Exceptions in UTL_FILES
Using the DBMS_OUTPUTPackage
UTL_HTTP and UTL_TCP
Oracle Supplied Packages 1
Oracle Supplied Packages 2
LOBs and BFILEs
Internal LOBs
DIRECTORIES‚ BFILENAME functions
Loading BFILEs & Migrating from LONG to LOB
DBMS_LOB READ and DBMS_LOB WRITE
Removing LOBs and Temporary LOBs
Manipulating Large Objects
Types of Triggers‚ DML Triggers and Firing Sequence
DML Trigger Components & Firing Sequence
Syntax for Creating DML Statement Triggers
Using OLD and NEW Qualifiers Example Using Audit_Emp_Table
Creating an INSTEAD OF Trigger
DROP TRIGGER Syntax
After Row and After Statement Triggers
Creating Database Triggers 1
Creating Database Triggers 2
Creating Database Triggers 3
Creating Database Triggers 4
Creating Database Triggers 5
Creating Database Triggers‚ LogOn LogOff and Server Facility to Audit
Implementing Triggers
Enforcing Data Integrity ‚ Replicating a Table
Logging Events‚ Managing Triggers and Listing the code of trigger
More Trigger Concepts
Managing Dependencies
Displaying Direct Dependencies by Using USER_DEPENDENCIES
REMOTE_DEPENDENCIES_MODE Parameter
Signature Mode & Recompiling a PLSQL Program Unit
Course Certificate
Secure Video
101
Certificate
1
Cost: 5000
Enroll Me