*#1 Most Popular Online Course in Computer Science* You can enroll today & get certified from EasyShiksha &
Welcome to the Mastering Oracle PL/SQL course, an in-depth and comprehensive program designed for database developers aiming to elevate their expertise in Oracle's powerful procedural language for SQL, PL/SQL. Whether you're a beginner looking to establish a strong foundation or an experienced developer seeking to enhance your skills, this course offers a structured and hands-on learning experience that caters to various proficiency levels.
Course Overview:
CHAPTER 1 PL/SQL Concepts
LAB 1.1 PL/SQL in Client/Server Architecture
1.1.1 Use PL/SQL Anonymous Blocks
1.1.2 Understand How PL/SQL Gets Executed
LAB 1.2 PL/SQL in SQL*Plus
1.2.1 Use Substitution Variables
1.2.2 Use the DBMS_OUTPUT.PUT_LINE Statement
CHAPTER 2 General Programming Language
LAB 2.1 PL/SQL Programming Fundamentals
2.1.1 Make Use of PL/SQL Language Components
2.1.2 Make Use of PL/SQL Variables
2.1.3 Handle PL/SQL Reserved Words
2.1.4 Make Use of Identifiers in PL/SQL
2.1.5 Make Use of Anchored Datatypes
2.1.6 Declare and Initialize Variables
2.1.7 Understand the Scope of a Block, Nested Blocks, and Labels
CHAPTER 3 SQL in PL/SQL
LAB 3.1 Making Use of DML in PL/SQL
3.1.1 Use the Select INTO Syntax for Variable Initialization
3.1.2 Use DML in a PL/SQL Block
3.1.3 Make Use of a Sequence in a PL/SQL Block
LAB 3.2 Making Use of SAVEPOINT
3.2.1 Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block
CHAPTER 4 Conditional Control: IF Statements
LAB 4.1 IF Statements
4.1.1 Use the IF-THEN Statement
4.1.2 Use the IF-THEN-ELSE Statement
LAB 4.2 ELSIF Statements
4.2.1 Use the ELSIF Statement
LAB 4.3 Nested IF Statements
4.3.1 Use Nested IF Statements
CHAPTER 5 Conditional Control: CASE Statements
LAB 5.1 CASE Statements
5.1.1 Use the CASE Statement
5.1.2 Use the Searched CASE Statement
LAB 5.2 CASE Expressions
5.2.1 Use the CASE Expression
LAB 5.3 NULLIF and COALESCE Functions
5.3.1 The NULLIF Function
5.3.2 Use the COALESCE Function
CHAPTER 6 Iterative Control: Part I
LAB 6.1 Simple Loops
6.1.1 Use Simple Loops with EXIT Conditions
6.1.2 Use Simple Loops with EXIT WHEN Conditions
LAB 6.2 WHILE Loops
6.2.1 Use WHILE Loops
LAB 6.3 Numeric FOR Loops
6.3.1 Use Numeric FOR Loops with the IN Option
6.3.2 Use Numeric FOR Loops with the REVERSE Option
CHAPTER 7 Iterative Control: Part II
LAB 7.1 The CONTINUE Statement
7.1.1 Use the CONTINUE Statement
7.1.2 Use the CONTINUE WHEN Condition
LAB 7.2 Nested Loops
7.2.1 Use Nested Loops
CHAPTER 8 Error Handling and Built-in Exceptions
LAB 8.1 Handling Errors
8.1.1 Understand the Importance of Error Handling
LAB 8.2 Built-in Exceptions
8.2.1 Use Built-in Exceptions
CHAPTER 9 Exceptions
LAB 9.1 Exception Scope
9.1.1 Understand the Scope of an Exception
LAB 9.2 User-Defined Exceptions
9.2.1 Use User-Defined Exceptions
LAB 9.3 Exception Propagation
9.3.1 Understand How Exceptions Propagate
9.3.2 Reraise Exceptions
CHAPTER 1 PL-SQL Concepts
PL-SQL in Client-Server Architecture
PL-SQL BLOCK STRUCTURE
EXECUTABLE SECTION
EXCEPTION-HANDLING SECTION
HOW PL-SQL GETS EXECUTED
Use PL-SQL Anonymous Blocks
Understand How PL-SQL Gets Executed
LAB 1.2 PL-SQL in SQLPlus
SUBSTITUTION VARIABLES
SUBSTITUTION VARIABLES
DBMS_OUTPUT.PUT_LIN
Use the DBMS_OUTPUT.PUT_LINE Statement
CHAPTER 2 General Programming Language Fundamentals
LEXICAL UNITS
Make Use of PLSQL Variables
Make Use of PLSQL Variables
Make Use of PLSQL Variables
Handle PLSQL Reserved Words
Make Use of Identifiers in PLSQ
Make Use of Anchored Datatypes
THE MOST COMMON DATATYPES
THE MOST COMMON DATATYPES
Declare and Initialize Variables
Declare and Initialize Variables
Declare and Initialize Variables
Understand the Scope of a Block, Nested Blocks, and Labels
LABELS AND NESTED BLOCKS
LABELS AND NESTED BLOCKS
CHAPTER 3 SQL in PLSQL
LAB 3.1 EXERCISES
Use the Select INTO Syntax for Variable Initialization
DRAWING NUMBERS FROM A SEQUENC
LAB 3.2 Making Use of SAVEPOINT
LAB 3.2 Making Use of SAVEPOINT
COMMIT
LAB 3.2 EXERCISES
Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PLSQL Block
CHAPTER 4 Conditional Control IF Statements
IF-THEN STATEMENTS
IF-THEN-ELSE STATEMENT
NULL CONDITION
Use the IF-THEN Statement
Use the IF-THEN Statement
Use the IF-THEN-ELSE Statement
Use the IF-THEN-ELSE Statement
Use the IF-THEN-ELSE Statement.
ELSIF Statements.
LAB 4.2 ELSIF Statements.
LAB 4.2 ELSIF Statements
Use the ELSIF Statement
Use the ELSIF Statement
LAB 4.3 Nested IF Statements.
LOGICAL OPERATORS
Use Nested IF Statements
Use Nested IF Statements
Conditional Control - CASE Statements
CASE STATEMENTS
DIFFERENCES BETWEEN CASE AND SEARCHED CASE STATEMENTS
DIFFERENCES BETWEEN CASE AND SEARCHED CASE STATEMENTS
Use the CASE Statement
Use the Searched CASE Statement
Use the Searched CASE Statement
CASE Expressions
LAB 5.2 CASE Expressions
LAB 5.2 CASE Expressions
Use the CASE Expression
THE NULLIF FUNCTION
THE COALESCE FUNCTION
The NULLIF Function
Use the COALESCE Function
Iterative Control Part I
EXIT WHEN STATEMENT
Use Simple Loops with EXIT Conditions
Use Simple Loops with EXIT Conditions
Use Simple Loops with EXIT WHEN Conditions
WHILE Loops
PREMATURE TERMINATION OF THE LOOP
LAB 6.2 EXERCISES
Use WHILE Loops
Use WHILE Loops
Numeric FOR Loops
PREMATURE TERMINATION OF THE LOOP
Use Numeric FOR Loops with the IN Option
Use Numeric FOR Loops with the REVERSE Option
Iterative Control Part II
THE CONTINUE WHEN STATEMENT
EXERCISES
Use the CONTINUE Statement
Use the CONTINUE Statement
Use the CONTINUE WHEN Condition
Nested Loops
LAB 7.2 EXERCISES
Use Nested Loops
Error Handling and Built-in Exceptions
Handling Errors
LAB 8.1 Handling Errors
Understand the Importance of Error Handling
LAB 8.2 Built-in Exceptions
LAB 8.2 Built-in Exceptions
LAB 8.2 Built-in Exceptions
EXERCISES
Use Built-in Exceptions
Use Built-in Exceptions
Exceptions
Exception Scope
EXERCISES
Understand the Scope of an Exception
User-Defined Exceptions
User-Defined Exceptions
User-Defined Exceptions
LAB 9.2 EXERCISES
Exception Propagation
LAB 9.3 Exception Propagation
LAB 9.3 Exception Propagation
Understand How Exceptions Propagate
Understand How Exceptions Propagate
The following course is fully online, and hence there is no need for any physical classroom session. The lectures and assignments can be accessed anytime and anywhere through a smart web or mobile device.
Anyone can choose a preferred course and start immediately without any delay.
As this is a purely online course program, you can choose to learn at any time of the day and for as much time as you want. Though we follow a well-established structure and schedule, we recommend a routine for you as well. But it finally depends on you, as you have to learn.
If you have completed the course, you would be able to have lifetime access to it for future reference too.
Yes, you can access and download the content of the course for the duration. And even have lifetime access to it for any further reference.
All the software/tools that you need for the course would be shared with you during the training as and when you need them.
No, only a soft copy of the certificate will be awarded, which can be downloaded and printed, if required.
You can try to make the payment through a different card or account (maybe a friend or family). If the problem persists, email us at info@easyshiksha.com
Due to some technical faults, this can happen. In such a case the amount deducted will be transferred to the bank account in the next 7-10 working days. Normally the bank takes this much time to credit the amount back into your account.
At times, there may be a slight delay in your payment reflecting on your EasyShiksha dashboard. However, if the problem is taking longer than 30 minutes, please let us know by writing to us at info@easyshiksha.com from your registered email id, and attach the screenshot of the payment receipt or transaction history. Soon after verification from the backend, we will update the payment status.
If you have enrolled, and are facing any technical problem then you can request a refund. But once the certificate has been generated, we shall not refund that.
Yes! You surely can. To begin this, just click the course of your interest and fill in the details to enrol. You are ready to learn, once the payment is made. For the same, you earn a certificate too.
Please contact us at: info@easyshiksha.com
Discover thousands of colleges and courses, enhance skills with online courses and internships, explore career alternatives, and stay updated with the latest educational news..
Gain high-quality, filtered student leads, prominent homepage ads, top search ranking, and a separate website. Let us actively enhance your brand awareness.
Download EasyShiksha Mobile Apps from Android Play Store, Apple App Store, Amazon App Store, and Jio STB.
1 million+ learned on the EasyShiksha App
