Learn Oracle PL/SQL - A Comprehensive Training Course

A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills
4.3 (94 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,174 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 74
  • Length 7.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

Course Description

In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.


Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!

By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

What are the requirements?

  • A Desire To Learn

What am I going to get from this course?

  • To Master Oracle PL/SQL - Learn From A Leading Expert

What is the target audience?

  • Users Of All Levels

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Important - Download These First - Working Files
Preview
Article
0101 What Is PL/SQL
Preview
04:01
0102 Course Expectations
Preview
04:18
Section 2: An Overview Of PL/SQL
0201 The Difference Between SQL And PL/SQL
06:42
0202 Where To Access Oracle - Part 1
04:28
0203 Where To Access Oracle - Part 2
05:53
0204 Block Structure
07:03
0205 Functions Procedures Packages
09:45
0206 Data Types
07:19
0207 Complex Objects
07:12
0208 Variables Constants Parameters - Part 1
05:56
0209 Variables Constants Parameters - Part 2
07:30
0210 Flow Control
07:35
0211 Errors Exceptions
07:46
0212 Commenting Code
03:46
Section 3: Data Types In Detail
0301 Strings
05:06
0302 Numbers
04:27
0303 Date And Time
03:46
0304 Booleans Lobs
03:43
Section 4: Complex Data Structures
0401 Records
07:00
0402 Associative Array
06:35
0403 Nested Tables
03:26
0404 Varrays
02:50
0405 Arrays Of Records
04:23
Section 5: Programming PL/SQL
0501 SQLplus
03:26
0502 SQL Developer - Part 1
04:45
0503 SQL Developer - Part 2
06:27
Section 6: A First Program
0601 Hello World
04:06
0602 Create Assign Use Variables
05:33
0603 Create Procedure
05:50
0604 Autonomous Transactions
07:07
Section 7: Flow Control
0701 If Statements
04:50
0702 Case Statements
06:26
0703 Loops - Part 1
05:20
0704 Loops - Part 2
07:24
Section 8: Functions
0801 Functions - Part 1
07:23
0802 Functions - Part 2
03:04
0803 Built in Functions
09:07
Section 9: Exception Handling
0901 What Are Exceptions - Part 1
06:28
0902 Predefined Exceptions
04:41
0903 Raising Exceptions
05:20
0904 Suggestions For Exception Handling
05:57
0905 User Defined Exceptions
07:38
Section 10: SQL In PL/SQL
1001 Inserting In PL/SQL
07:09
1002 Updates And Deletes In PL/SQL
08:25
1003 Selecting Data In PL/SQL
06:08
1004 Cursors
05:21
1005 Cursor For Loops
02:07
1006 Bulk Operations
07:51
Section 11: Packages
1101 Package Specifications
04:45
1102 Package Bodies
03:59
1103 Public And Private Globals - Part 1
06:46
1104 Public And Private Globals - Part 2
03:04
1105 Package Initialization
05:00
1106 Forward Declarations
04:29
1107 Package Cursors
03:58
1108 Utl File
07:34
1109 Overloading
09:23
Section 12: Triggers
1201 DML Triggers
08:30
1202 Compound Triggers
02:42
1203 Instead Of Triggers
02:48
1204 Database Triggers
02:55
Section 13: PL/SQL Objects
1301 Object Types
05:55
1302 Constructors
07:16
1303 Members
05:47
1304 Equality
06:49
1305 Inheritance
08:25
Section 14: Dynamic SQL
1401 Dynamic SQL
11:32
1402 DBMS SQL - Part 1
07:15
1403 DBMS SQL - Part 2
04:49
1404 DBMS SQL - Part 3
05:31
1405 DBMS SQL - Part 4
09:35
1406 NDS - Part 1
08:12
1407 NDS - Part 2
13:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course