Our Courses

Course Library View the full range of courses

2
- × Oracle 11g PL/SQL Part 1 1 × Original price was: £125.Current price is: £19.99.
- × PDF Certificate + Transcript (Special 50% Discount for Limited-Time) 1 × Original price was: £13.98.Current price is: £6.99.
Subtotal: £26.98

View basket Checkout
Log in

Empower Yourself!!

Join our community of 70k+ learners, upskill with CPD accredited courses, explore career development tools and psychometrics.

Having trouble Logging in? Get in Touch

Don’t have an account yet? Sign Up

Already have an account? Log In

[wplms_lost_password_form]

Remember your password? Back to Login

Oracle 11g PL/SQL Part 1

(10 Reviews)

Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE

The Oracle 11g PL/SQL Part 1 course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts.

Initially, you’ll learn how to start programming in Oracle PL/SQL. You’ll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable.

Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career.

From beginners to expert learner can benefit from this course. So enrol today and see what else is in the Oracle 11g PL/SQL Part 1 course.

What Will I Learn?

Prepare your environment
Work with Oracle database tools
Understand and work with language features
Work with the DECLARE clause
Work with the BEGIN clause
Work with the EXCEPTION clause
Use explicit cursors
Understand and use nested blocks
Understand the difference between nested blocks and subprograms

Requirements

Familiarity with database and programming principles

Who is the target audience?

Application designers and developers
Database administrators
Business users and non-technical senior end users

Course content

12 Sections 51 lectures 9 hours 54 mins in total

Introduction

1 lecture • 3 m: 0 s

Introduction

00:03:00

Preparing Your Environment

1 lecture • 37 m: 0 s

Course Setup

00:37:00

Working with Oracle Database Tools

1 lecture • 31 m: 0 s

Selecting the Appropriate Database Tool

00:31:00

Language Features

3 lectures • 44 m: 0 s

Understanding PL/SQL

00:18:00
PL/SQL Blocks

00:15:00
Working with SQL Plus

00:11:00

The DECLARE Clause

8 lectures • 1 hour 28 mins

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 Data Types and Assignments

00:11: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

20 lectures • 3 hour 20 mins

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:08:00
Using Nested Loops

00:12:00
Using the If-Then-Else

00:19:00
Using the CASE Statement

00:18:00

The EXCEPTION Clause

7 lectures • 1 hour 10 mins

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

6 lectures • 1 hour 15 mins

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

2 lectures • 24 m: 0 s

Understanding Nested Blocks

00:11:00
Difference between Global vs Local Objects and Exceptions

00:13:00

Declared Subprograms

1 lecture • 18 m: 0 s

Subprograms: How They Differ from Nested Blocks

00:18:00

Conclusion

1 lecture • 4 m: 0 s

Conclusion

00:04:00

Course Certification

0 lectures • 0 m: 0 s

Certification

After successfully completing the course, you will be able to get the and internationally accepted certificate to share your achievement with potential employers or include it in your CV.

Student Reviews

Excellent

4.9 Average 10 Reviews

Reviews

Great learning experience with iStudy. Clear lessons and easy to follow. Really impressed.

Loved the flexibility. Studied at my own pace and finished quickly.

Excellent course quality. I feel more confident in my skills now.

iStudy delivered exactly what I needed. Very smooth process.

Customer support was fast and helpful. Got answers straight away.

Great platform. Well-structured lessons and simple navigation.

Really happy with the experience. The certificate arrived quickly.

Clear teaching style and easy to understand. Highly recommend.

Self-paced learning was a huge benefit. Finished around my schedule.

Great value for money. Quality courses and helpful support.

I enjoyed learning with iStudy. Everything was straightforward.

Quick, simple and informative. Made studying stress-free.

Fantastic support team. They resolved my issue in minutes.

Course material was clear and engaging. Very happy overall.

Loved the layout and simple step-by-step lessons.

Prompt certificate delivery. Really impressed with the service.

Good quality courses and easy platform to use.

Very convenient. Learned at my own pace without pressure.

Great experience from start to finish. Worth every penny.

Clear content, supportive team and fast responses. Highly recommend iStudy.

Frequently Asked Question

Are there any prerequisites for taking the course?

There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course.

Can I access the course at any time, or is there a set schedule?

You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience.

How long will I have access to the course?

For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime.

Is there a certificate of completion provided after completing the course?

Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.

Can I switch courses or get a refund if I'm not satisfied with the course?

We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.

How do I track my progress in the course?

Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.

What if I have technical issues or difficulties with the course?

If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.