The Complete PLSQL Bootcamp (Beginners to Advanced)

PL/SQL stands for procedural language-structured query language. It is a significant member of Oracle programming tool set which is extensively used to code server side programming. Similar to SQL language PL/SQL is also a case-insensitive programming language.

5,003 students enrolled

PL/SQL stands for procedural language-structured query language. It is a significant member of Oracle programming tool set which is extensively used to code server side programming. Similar to SQL language PL/SQL is also a case-insensitive programming language.

Introduction

1
Introduction to PL/SQL

Installation

1
How to Install Oracle Database 19c In Windows
2
Enable Pluggable Database with TNSNAMES.ORA file
3
How To Create [TNS Service] Using Oracle Net Configuration Assistant
4
HOW TO UNLOCK HR AND SCOTT USER
5
Introduction to SQL PLUS
6
Introduction to SQL Developer with Installation

Declaring PLSQL Variables

1
Types of PLSQL blocks
2
DBMS_OUTPUT IN Oracle SQL Developer
3
Anonymous Block
4
What are Bind Variables?
5
Data Types
6
Declaring PLSQL Variables
7
Declaring PLSQL Constants

Writing Executable Statements

1
Writing Executable Statements
2
Learn to Comment the Code
3
Describe Nested Blocks
4
Identify the Operators in PLSQL
5
Indenting the Code

Writing Control Structures

1
IF STATEMENTS
2
CASE Statements
3
GO TO Statements
4
NULL Statements

Iterative processing with loops

1
Basic Loop
2
While Loop
3
For Loop
4
Continue Statements

Using Cursors

1
Using Implicit Cursors
2
Using Explicit Cursors
3
Cursor with parameters
4
PLSQL Records and Cursor
5
Cursor FOR Loops

Handling Exceptions

1
Handling Exceptions
2
Using Raise Application Error

Creating Procedures

1
Creating Procedures
2
Parameter In Procedures
3
The %ROWTYPE Attribute

Creating Functions

1
Creating Functions

Creating Packages

1
Creating and Using Packages

Creating Triggers

1
What is Trigger
2
Creating Triggers with Raise Application Error
3
Disable, Enable and Drop Triggers
4
DML Triggers
5
System Triggers
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Archive