Oracle

shinelogics-pl

Oracle PL/SQL


Week Topics
1
    Overview of PL/SQL
  • Advantages of PL/SQL
  • Understanding the Main Features of PL/SQL
  • PL/SQL Architecture
  • Fundamentals of PL/SQL Language
  • Character Set
  • Lexical Units Declarations
  • PL/SQL Naming Conventions
  • Scope and Visibility of PL/SQL Identifiers
  • Assigning Values to Variables
  • PL/SQL Expressions and Comparisons
  • Summary of PL/SQL Built-In Functions
  • PL/SQL Datatypes
  • Overview of Predefined PL/SQL Datatypes
  • Overview of PL/SQL Subtypes
  • Converting PL/SQL Datatypes
2
    Using PL/SQL Control Structures
  • Overview of PL/SQL Control Structures
  • Testing Conditions: IF and CASE Statements
  • Controlling Loop Iterations: LOOP and EXIT Statements
  • Sequential Control: GOTO and NULL Statements
  • Using PL/SQL Collections and Records
  • What Is a Collection?
  • Choosing Which PL/SQL Collection Types to Use
  • Defining Collection Types
  • Declaring PL/SQL Collection Variables
  • Initializing and Referencing Collections
  • Assigning Collections
  • Comparing Collections
  • Using PL/SQL Collections with SQL Statements
  • Using Multilevel Collections
  • Using Collection Methods
  • Avoiding Collection Exceptions
  • What Is a PL/SQL Record?
  • Defining and Declaring Records
  • Assigning Values to Records
3
    Performing SQL Operations from PL/SQL
  • Overview of SQL Support in PL/SQL
  • Performing DML Operations from PL/SQL (INSERT, UPDATE, and DELETE)
  • Using PL/SQL Records in SQL INSERT and UPDATE Statements
  • Issuing Queries from PL/SQL
  • Querying Data with PL/SQL
  • Using Subqueries
  • Using Correlated Subqueries
  • Using Cursor Attributes
  • Using Cursor Variables (REF CURSORs)
  • Using Cursor Expressions
  • Overview of Transaction Processing in PL/SQL
  • Doing Independent Units of Work with Autonomous Transactions
  • Performing SQL Operations with Native Dynamic SQL
  • What Is Dynamic SQL?
  • Why Use Dynamic SQL?
  • Using the EXECUTE IMMEDIATE Statement
  • Building a Dynamic Query with Dynamic SQL
  • Examples of Dynamic SQL for Records, Objects, and Collections
  • Using Bulk Dynamic SQL
  • Guidelines for Dynamic SQL
4
    Using PL/SQL Subprograms
  • What Are Subprograms?
  • Advantages of PL/SQL Subprograms
  • Understanding PL/SQL Procedures
  • Understanding PL/SQL Functions
  • Declaring Nested PL/SQL Subprograms
  • Passing Parameters to PL/SQL Subprograms
  • Overloading Subprogram Names
  • How Subprogram Calls Are Resolved
  • Using Invoker's Rights Versus Definer's Rights (AUTHID Clause)
  • Using Recursion with PL/SQL
  • Calling External Subprograms
  • Creating Dynamic Web Pages with PL/SQL Server Pages
  • Controlling Side Effects of PL/SQL Subprograms
  • Understanding Subprogram Parameter Aliasing
  • Using PL/SQL Packages
  • What Is a PL/SQL Package?
  • Advantages of PL/SQL Packages
  • Understanding The Package Specification
  • Understanding The Package Body
  • Some Examples of Package Features
  • Private Versus Public Items in Packages
  • Overloading Packaged Subprograms
  • How Package STANDARD Defines the PL/SQL Environment
  • Overview of Product-Specific Packages
  • Guidelines for Writing Packages
  • Separating Cursor Specs and Bodies with Packages
5
    Handling PL/SQL Errors
  • Overview of PL/SQL Runtime Error Handling
  • Advantages of PL/SQL Exceptions
  • Summary of Predefined PL/SQL Exceptions
  • Defining Your Own PL/SQL Exceptions
  • How PL/SQL Exceptions Are Raised
  • How PL/SQL Exceptions Propagate
  • Reraising a PL/SQL Exception
  • Handling Raised PL/SQL Exceptions
  • Tips for Handling PL/SQL Errors
  • Using PL/SQL Object Types
  • Overview of PL/SQL Object Types
  • What Is an Object Type?
  • Why Use Object Types?
  • Structure of an Object Type
  • Components of an Object Type
  • Defining Object Types
  • Declaring and Initializing Objects
  • Accessing Object Attributes
  • Defining Object Constructors
  • Calling Object Constructors
  • Calling Object Methods
  • Sharing Objects through the REF Modifier
  • Manipulating Objects through SQL

Trainer Information

Trainer Name Experience Working In
Antony 11 years MNC