Mastering Oracle PL/SQL: Comprehensive Course for Database Developers

*#1 Most Popular Online Course in Computer Science* You can enroll today & get certified from EasyShiksha & HawksCode

Mastering Oracle PL/SQL: Comprehensive Course for Database Developers Description

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

Advanced Oracle PL/SQL: Mastering the Art of High-Performance Database Development

Advanced Oracle PL/SQL: Mastering the Art of High-Performance Database Development Part-2

Course Content

course-lock CHAPTER 1 PL-SQL Concepts course-lock PL-SQL in Client-Server Architecture course-lock PL-SQL BLOCK STRUCTURE course-lock EXECUTABLE SECTION course-lock EXCEPTION-HANDLING SECTION course-lock HOW PL-SQL GETS EXECUTED course-lock Use PL-SQL Anonymous Blocks course-lock Understand How PL-SQL Gets Executed course-lock LAB 1.2 PL-SQL in SQLPlus course-lock SUBSTITUTION VARIABLES course-lock SUBSTITUTION VARIABLES course-lock DBMS_OUTPUT.PUT_LIN course-lock Use the DBMS_OUTPUT.PUT_LINE Statement course-lock CHAPTER 2 General Programming Language Fundamentals course-lock LEXICAL UNITS course-lock Make Use of PLSQL Variables course-lock Make Use of PLSQL Variables course-lock Make Use of PLSQL Variables course-lock Handle PLSQL Reserved Words course-lock Make Use of Identifiers in PLSQ course-lock Make Use of Anchored Datatypes course-lock THE MOST COMMON DATATYPES course-lock THE MOST COMMON DATATYPES course-lock Declare and Initialize Variables course-lock Declare and Initialize Variables course-lock Declare and Initialize Variables course-lock Understand the Scope of a Block, Nested Blocks, and Labels course-lock LABELS AND NESTED BLOCKS course-lock LABELS AND NESTED BLOCKS course-lock CHAPTER 3 SQL in PLSQL course-lock LAB 3.1 EXERCISES course-lock Use the Select INTO Syntax for Variable Initialization course-lock DRAWING NUMBERS FROM A SEQUENC course-lock LAB 3.2 Making Use of SAVEPOINT course-lock LAB 3.2 Making Use of SAVEPOINT course-lock COMMIT course-lock LAB 3.2 EXERCISES course-lock Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PLSQL Block course-lock CHAPTER 4 Conditional Control IF Statements course-lock IF-THEN STATEMENTS course-lock IF-THEN-ELSE STATEMENT course-lock NULL CONDITION course-lock Use the IF-THEN Statement course-lock Use the IF-THEN Statement course-lock Use the IF-THEN-ELSE Statement course-lock Use the IF-THEN-ELSE Statement course-lock Use the IF-THEN-ELSE Statement. course-lock ELSIF Statements. course-lock LAB 4.2 ELSIF Statements. course-lock LAB 4.2 ELSIF Statements course-lock Use the ELSIF Statement course-lock Use the ELSIF Statement course-lock LAB 4.3 Nested IF Statements. course-lock LOGICAL OPERATORS course-lock Use Nested IF Statements course-lock Use Nested IF Statements course-lock Conditional Control - CASE Statements course-lock CASE STATEMENTS course-lock DIFFERENCES BETWEEN CASE AND SEARCHED CASE STATEMENTS course-lock DIFFERENCES BETWEEN CASE AND SEARCHED CASE STATEMENTS course-lock Use the CASE Statement course-lock Use the Searched CASE Statement course-lock Use the Searched CASE Statement course-lock CASE Expressions course-lock LAB 5.2 CASE Expressions course-lock LAB 5.2 CASE Expressions course-lock Use the CASE Expression course-lock THE NULLIF FUNCTION course-lock THE COALESCE FUNCTION course-lock The NULLIF Function course-lock Use the COALESCE Function course-lock Iterative Control Part I course-lock EXIT WHEN STATEMENT course-lock Use Simple Loops with EXIT Conditions course-lock Use Simple Loops with EXIT Conditions course-lock Use Simple Loops with EXIT WHEN Conditions course-lock WHILE Loops course-lock PREMATURE TERMINATION OF THE LOOP course-lock LAB 6.2 EXERCISES course-lock Use WHILE Loops course-lock Use WHILE Loops course-lock Numeric FOR Loops course-lock PREMATURE TERMINATION OF THE LOOP course-lock Use Numeric FOR Loops with the IN Option course-lock Use Numeric FOR Loops with the REVERSE Option course-lock Iterative Control Part II course-lock THE CONTINUE WHEN STATEMENT course-lock EXERCISES course-lock Use the CONTINUE Statement course-lock Use the CONTINUE Statement course-lock Use the CONTINUE WHEN Condition course-lock Nested Loops course-lock LAB 7.2 EXERCISES course-lock Use Nested Loops course-lock Error Handling and Built-in Exceptions course-lock Handling Errors course-lock LAB 8.1 Handling Errors course-lock Understand the Importance of Error Handling course-lock LAB 8.2 Built-in Exceptions course-lock LAB 8.2 Built-in Exceptions course-lock LAB 8.2 Built-in Exceptions course-lock EXERCISES course-lock Use Built-in Exceptions course-lock Use Built-in Exceptions course-lock Exceptions course-lock Exception Scope course-lock EXERCISES course-lock Understand the Scope of an Exception course-lock User-Defined Exceptions course-lock User-Defined Exceptions course-lock User-Defined Exceptions course-lock LAB 9.2 EXERCISES course-lock Exception Propagation course-lock LAB 9.3 Exception Propagation course-lock LAB 9.3 Exception Propagation course-lock Understand How Exceptions Propagate course-lock Understand How Exceptions Propagate

What You Need For This Course?

  • Access to Smart Phone / Computer
  • Good Internet Speed (Wifi/3G/4G)
  • Good Quality Earphones / Speakers
  • Basic Understanding of English
  • Dedication & Confidence to clear any exam

Internship Students Testimonials

Relevant Courses

easyshiksha badges
Frequently Asked Questions

Q.Is the course 100% online? Does it require any offline classes too?

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.

Q.When can I start the course?

Anyone can choose a preferred course and start immediately without any delay.

Q.What are the course and session timings?

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.

Q.What will happen when my course is over?

If you have completed the course, you would be able to have lifetime access to it for future reference too.

Q.Can I download the notes and study material?

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.

Q. What software/tools would be needed for the course and how can I get them?

All the software/tools that you need for the course would be shared with you during the training as and when you need them.

Q. Do I get the certificate in a hard copy?

No, only a soft copy of the certificate will be awarded, which can be downloaded and printed, if required.

Q. I’m unable to make a payment. What to do now?

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

Q. The payment got deducted, but the updated transaction status is showing “failed”. What to do now?

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.

Q. The payment was successful but it still shows ‘Buy Now’ or not showing any videos on my dashboard? What should I do?

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.

Q. What is the refund policy?

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.

Q.Can I just enrol in a single course?

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.

My questions are not listed above. I need further help.

Please contact us at: info@easyshiksha.com

Experience the Speed: Now Available on Mobile!

Download EasyShiksha Mobile Apps from Android Play Store, Apple App Store, Amazon App Store, and Jio STB.

Curious to learn more about EasyShiksha's services or need assistance?

Our team is always here to collaborate and address all your doubts.