Learn Oracle PL/SQL - A Comprehensive Training Course
4.4 (148 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,377 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Oracle PL/SQL - A Comprehensive Training Course to your Wishlist.

Add to Wishlist

Learn Oracle PL/SQL - A Comprehensive Training Course

A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills
4.4 (148 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,377 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To Master Oracle PL/SQL - Learn From A Leading Expert
View Curriculum
Requirements
  • A Desire To Learn
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.

Who is the target audience?
  • Users Of All Levels
Students Who Viewed This Course Also Viewed
Curriculum For This Course
74 Lectures
07:18:58
+
An Overview Of PL/SQL
12 Lectures 01:20:55

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
+
Data Types In Detail
4 Lectures 17:02
0301 Strings
05:06

0302 Numbers
04:27

0303 Date And Time
03:46

0304 Booleans Lobs
03:43
+
Complex Data Structures
5 Lectures 24:14
0401 Records
07:00

0402 Associative Array
06:35

0403 Nested Tables
03:26

0404 Varrays
02:50

0405 Arrays Of Records
04:23
+
Programming PL/SQL
3 Lectures 14:38
0501 SQLplus
03:26

0502 SQL Developer - Part 1
04:45

0503 SQL Developer - Part 2
06:27
+
A First Program
4 Lectures 22:36
0601 Hello World
04:06

0602 Create Assign Use Variables
05:33

0603 Create Procedure
05:50

0604 Autonomous Transactions
07:07
+
Flow Control
4 Lectures 24:00
0701 If Statements
04:50

0702 Case Statements
06:26

0703 Loops - Part 1
05:20

0704 Loops - Part 2
07:24
+
Functions
3 Lectures 19:34
0801 Functions - Part 1
07:23

0802 Functions - Part 2
03:04

0803 Built in Functions
09:07
+
Exception Handling
5 Lectures 30:04
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
+
SQL In PL/SQL
6 Lectures 37:01
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
4 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
42,610 Reviews
714,539 Students
331 Courses
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.