Udemy - The Complete PL/SQL Bootcamp : 'Beginner to Advanced PL/SQL'

Category: Technical

Tag: Database/SQL


Posted on 2019-05-16, by phaelx.

Description



Date: March 2019
Author: Oracle Master Training • 30,000+ Students Worldwide

Size: 5.6 GB
Format: MP4
Download     >>    https://dropapk.com/abvic1kqcok8
What you'll learn
   *Pass the Oracle 1Z0-144 : Program with PL/SQL Certification Exam - on your first try!
   *Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
   *Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
   *Every Subject is Explained from the Easiest to the Most Advanced.
   *Real-World Examples for Every Section
   *Some Advanced SQL Techniques
   *Using SQL Developer Efficiently for PL/SQL
   *Improving Performance & Security of Your Codes
   *PL/SQL Architecture
   *Creating Dynamic Queries
   *Use PL/SQL Like Object Oriented Programming.
   *PL/SQL Tuning


Course content

What is PL/SQL ?
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1

Software Installation
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions

Let's Start Coding!..
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2

PL/SQL Variables
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables

Control Structures
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures

Using SQL in PL/SQL
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL

Composite Data Types
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types

PL/SQL Cursors
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)

PL/SQL Exceptions
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)

PL/SQL Functions & Procedures
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)

PL/SQL Packages
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?

PL/SQL Triggers
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)

Debugging Your Code
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production

Using PL/SQL Objects
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production
   On Production

Using PL/SQL Compiler
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production
   On Production
   On Production

Using Large Objects(LOB) in PL/SQL
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production
   On Production
   On Production
   Thank you for your understanding..

PL/SQL Performance & Tuning
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production
   On Production
   On Production
   Thank you for your understanding..
   On Production

Bonus (+) Section
   Course Introductory Video
   UDEMY 101: How to Use Udemy? +Some Useful Tips
   What is PL/SQL and Why to Use?
   PL/SQL Architecture
   The Sample (HR) Schema Used in This Course
   Bonus Materials : Course Material & PL/SQL Cheatsheet
   Quiz 1
   About the Installation
   Which Option to Have a Database?
   Option 1 : Having The Database with Oracle VirtualBox
   Option 2 : Downloading and Installing Oracle Database
   Configuring and Using SQL Developer
   How to Unlock HR Schema in Oracle?
   Option 3 : Using Oracle Live SQL
   Option 3: About Oracle Live SQL Restrictions
   Anonymous Blocks
   PL/SQL Outputs
   Quiz 2
   What are Variables and Why to Use Them?
   Naming Rules & Naming Conventions
   Declaring & Initializing & Using Variables - Part 1
   Declaring & Initializing & Using Variables - Part 2
   Declaring & Initializing & Using Variables (Code Samples)
   Using %TYPE Attribute
   Using %Type Attribute (Code Samples)
   PL/SQL Delimiters and Commenting Your Code
   PL/SQL Delimiters and Commenting (Code Samples)
   PL SQL Variable Scope
   PL SQL Variable Scope (Code Samples)
   Using Bind Variables
   Using Bind Variables (Code Samples)
   Quiz 3 - Variables
   What are Control Structures & IF Statements
   What are Control Structures & IF Statements (Code Samples)
   Case Expressions
   Case Expressions (Code Samples)
   What are Loops - Basic Loops
   Basic Loops (Code Samples)
   While Loops
   While Loops (Code Samples)
   For Loops
   For Loops (Code Samples)
   Nested Loops & Loop Labeling
   Nested Loops & Loop Labeling (Code Samples)
   Continue Statement
   Continue Statement (Code Samples)
   GOTO Statement
   GOTO Statement (Code Samples)
   Quiz 4 - Control Structures
   Operating with Selected Database Data..
   Operating Wİth Selected Queries (Code Samples)
   DML Operations in PL/SQL
   DML Operations in PL/SQL (Code Samples)
   Using Sequences in PL/SQL
   Using Sequences in PL/SQL (Code Samples)
   Bonus - Enabling Server Outputs by Default.
   Quiz 5 - Using SQL in PL/SQL
   Simple Data Types vs Composite Data Types
   PL/SQL Records - Part 1
   PL/SQL Records - Part 2
   PL/SQL Records (Code Samples)
   Easy DML With Records
   Easy DML With Records (Code Samples)
   What Are Collections?
   Varrays & Collection Methods
   Varrays (Code Samples)
   Nested Tables
   Nested Tables (Code Samples)
   PL&SQL Associative Arrays (Part 1)
   PL&SQL Associative Arrays (Part 2)
   Associative Arrays (Code Samples)
   Storing Collections in Tables - (Part 1)
   Storing Collections in Tables - (Part 2)
   Storing Collections in Tables (Code Samples)
   Quiz 6 - Composite Data Types
   What are Cursors and Cursor Types in PL SQL?
   Using Explicit Cursors
   Using Explicit Cursors (Code Samples)
   Using Cursors with Records
   Cursors with Records (Code Samples)
   Looping with Cursors
   Looping with Cursors (Code Samples)
   PL SQL Cursors with Parameters
   PL SQL Cursors with Parameters (Code Samples)
   PL SQL Cursor Attributes
   PL SQL Cursor Attributes (Code Samples)
   For Update Clause
   For Update Clause (Code Samples)
   Where Current Of Clause
   Where Current Of Clause (Code Samples)
   Reference Cursors
   Reference Cursors - (Code Samples)
   What are the Exceptions?
   What are the Exceptions (Code Sample)
   Handling the Exceptions!
   Handling the Exceptions (Code Samples)
   Handling the Nonpredefined Exceptions
   Handling Nonpredefined Exceptions (Code Sample)
   Handling & Raising User-Defined Exceptions
   Handling & Raising User-Defined Exceptions (Code Samples)
   Using RAISE_APPLICATION_ERROR() Procedure
   Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
   What are Functions & Procedures and Why We Use?
   What are Functions & Procedures and Why We Use (Code Samples)
   Creating and Using Stored Procedures
   Creating and Using Stored Procedures (Code Samples)
   Using IN & OUT Parameters
   Using IN & OUT Parameters (Code Samples)
   Named & Mixed Notations and Default Option
   Named & Mixed Notations and Default Option (Code Samples)
   Creating and Using Functions (Part 1)
   Creating and Using Functions (Part 2)
   Creating and Using PL/SQL Functions (Code Samples)
   Local Subprograms
   Local Subprograms (Code Samples)
   Overloading the Subprograms
   Overloading the Subprograms (Code Samples)
   Handling the Exceptions in Subprograms
   Handling the Exceptions in Subprograms (Code Samples)
   Finding & Removing the Subprograms
   Regular & Pipelined Table Functions
   Regular & Pipelined Table Functions (Code Samples)
   What Are Packages?
   Creating & Using & Modifying & Removing the Packages
   Creating & Using & Modifying & Removing the Packages (Code Samples)
   Visibility of Package Objects
   Visibility of Package Objects (Code Samples)
   Illegal Object Reference & Forward Declaration
   Package Initialization
   Persistent State of Packages - Part 1
   Persistent State of Packages - Part 2
   Persistent State of Packages (Code Samples)
   Using Collections in Packages - Part 1
   Using Collections in Packages - Part 2
   Using Collections in Packages (Code Samples)
   How Can I Find the Packages?
   What are Triggers & Trigger Types
   Understanding DML Triggers
   Specifying the Timing of Triggers
   Specifying the Timing of Triggers (Code Samples)
   Statement & Row Level Triggers
   Statement & Row Level Triggers (Code Samples)
   Using New & Old Qualifiers in Triggers
   Using New & Old Qualifiers in Triggers (Code Samples)
   Using Conditional Predicates
   Using Conditional Predicates (Code Samples)
   Using RAISE_APPLICATION_ERROR Procedure in Triggers
   Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
   Using Update Of Event in Triggers
   Using Update Of Event in Triggers (Code Samples)
   Using WHEN Clause in Triggers
   Using When Clause in Triggers (Code Samples)
   INSTEAD OF Triggers
   Instead of Triggers (Code Samples)
   Exploring & Managing the Triggers
   Creating Disabled Triggers
   Creating Disabled Triggers (Code Samples)
   Additional Real-World Examples for DML Triggers
   Additional Real-World Examples for DML Triggers (Code Samples)
   Compound Triggers
   Compound Triggers (Code Samples)
   Handling Mutating Table Errors
   Handling Mutating Table Errors (Code Samples)
   For Your Attention!..
   On Production
   On Production
   On Production
   Thank you for your understanding..
   On Production
   Bonus (+) Lecture: Special Discounts for Our Students!


Sponsored High Speed Downloads
9706 dl's @ 3127 KB/s
Download Now [Full Version]
7532 dl's @ 2646 KB/s
Download Link 1 - Fast Download
5954 dl's @ 3051 KB/s
Download Mirror - Direct Download



Search More...
Udemy - The Complete PL/SQL Bootcamp : 'Beginner to Advanced PL/SQL'

Search free ebooks in ebookee.com!


Links
Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.


Related Books


Comments

No comments for "Udemy - The Complete PL/SQL Bootcamp : 'Beginner to Advanced PL/SQL'".


    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.
    Back to Top