Oracle PL/SQL 11g

4.8( 9 REVIEWS )

Oracle PL/SQL 11g

4.8( 9 REVIEWS )

Extra 30% OFF! Get subscription of 1000+ courses for £65!£46! Find Out More

Oracle PL/SQL 11g TAKE THIS COURSE loader


PL/SQL allows the programmer to write code in a procedural format. Combining data manipulation power of SQL (Structured Query Language) with the processing power of SQL, it creates extraordinary SQL queries. Learn how to functions with PL/SQL in Oracle through our well-designed Oracle PL/SQL 11g course. The lucid contents of the course guide you how to enhance your competency in the procedural language.      

First and foremost, the course introduces you about the PL/SQL in Oracle. Following that, it gives you a brief idea about the three components of PL/SQL architecture. It also instructs you how to use various lexicon date to summarize and manage the data. Furthermore, it teaches you how to keep the table row record, solve error management, use numbers and strings.

Overall, it teaches all the crucial aspects of PL/SQL block, units, and database server to become efficient in this field.

Who is this course for?

Oracle PL/SQL 11g is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don’t have to worry about the quality.


Our Oracle PL/SQL 11g is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.

CPD Certificate from Course Gate 

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.

Course Curriculum

Introduction 00:03:00
Preparing Your Environment
Course Setup 00:37:00
Working with Oracle Database Tools
Selecting the Appropriate Database Tool 00:31:00
Language Features
Understanding PL/SQL 00:18:00
PL/SQL Blocks 00:15:00
Working with SQL Plus 00:11:00
The DECLARE Clause
DECLARE Clause Objects 00:16:00
PL/SQL Available Data Types 00:17:00
Declaring Simple Data Types and Assignments 00:12:00
Declaring Complex RowTypes and Assignments 00:07:00
Declaring Complex RowTypes and Assignments 00:07:00
Declaring Complex Tables 00:08:00
Declaring Complex Records 00:08:00
Creating and Declaring User-Defined Types 00:09:00
The BEGIN Clause
What Can Be Included in the BEGIN Clause 00:07:00
Working with CHAR and VARCHAR2 Variables 00:08:00
Handling String Literals 00:08:00
Working with Numeric Variables 00:07:00
Working with Date Variables 00:06:00
Assigning and Using Boolean Variables 00:08:00
Using Comparison Operators 00:07:00
Using SQL Functions 00:06:00
SQL DML within PL/SQL 00:15:00
Using SELECT 00:07:00
Exceptions and Embedded SQL 00:11:00
Using Sequences 00:14:00
Logic Control and Branching 00:07:00
Using GOTO 00:06:00
Working with LOOPS 00:19:00
Creating and Using the Indefinite Loop 00:07:00
Creating and Using the Conditional Loop 00:09:00
Using Nested Loops 00:12:00
Using the If-Then-Else 00:19:00
Using the CASE Statement 00:18:00
What Are the Types of Exceptions 00:06:00
Trapping Exceptions 00:06:00
Identify Exception Details 00:11:00
Creating User-Defined Exceptions 00:11:00
Using SQLCODE and SQLERRM Objects 00:09:00
Understand the Implicit Cursor 00:15:00
Creating User-Defined Events 00:12:00
Explicit Cursors
Understanding the Concept and Purpose of Explicit Cursors 00:18:00
Learn about Cursor Attributes 00:10:00
Using the Continue Statement 00:06:00
Working with Updateable Cursors 00:19:00
Creating and Using Cursor Parameters 00:15:00
FOR…LOOP Cursors 00:07:00
Nested Blocks
Understanding Nested Blocks 00:11:00
Difference between Global vs Local Objects and Exceptions 00:13:00
Declared Subprograms
Subprograms: How They Differ from Nested Blocks 00:18:00
Conclusion 00:04:00
Oracle PL/SQL 11g

Course Reviews


9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Oracle PL/SQL 11g TAKE THIS COURSE loader


© Course Gate Edukite Ltd, Reg no: 11378092

Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £65.00 per year


No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.