Oracle 11g PL/SQL Fundamentals I
4.6 (740 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,344 students enrolled

Oracle 11g PL/SQL Fundamentals I

An introduction to the PL/SQL database programming language
Highest Rated
4.6 (740 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,344 students enrolled
Last updated 3/2017
English
English [Auto], Arabic, 8 more
  • French
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Description

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Who this course is for:
  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users
Course content
Expand all 51 lectures 09:50:38
+ Introduction
1 lecture 03:06
The instructor has provided additional resources and example files for you to use.  If you would like to access these, please download the attached .zip file, which contains the files shown in this course. 
Preview 03:06
+ Working with Oracle Database Tools
1 lecture 30:45
Selecting the Appropriate Database Tool
30:45
+ Language Features
3 lectures 44:18
Understanding PL/SQL
17:59
PL/SQL Blocks
15:19
+ The DECLARE Clause
8 lectures 01:28:00
DECLARE Clause Objects
16:25
PL/SQL Available Data Types
16:55
Declaring Simple Data Types and Assignments
12:16
Declaring Complex Data Types and Assignments
10:38
Declaring Complex RowTypes and Assignments
07:02
Declaring Complex Tables
07:44
Declaring Complex Records
08:12
+ The BEGIN Clause
20 lectures 03:19:06
What Can Be Included in the BEGIN Clause
07:02
Working with CHAR and VARCHAR2 Variables
07:30
Handling String Literals
07:41
Working with Numeric Variables
06:40
Working with Date Variables
06:00
Assigning and Using Boolean Variables
07:44
Using Comparison Operators
07:24
Using SQL Functions
06:04
SQL DML within PL/SQL
15:05
Using SELECT
06:32
Exceptions and Embedded SQL
11:16
Using Sequences
14:28
Logic Control and Branching
06:58
Working with LOOPS
18:53
Creating and Using the Indefinite Loop
06:59
Creating and Using the Conditional Loop
08:48
Using Nested Loops
11:33
Using the If-Then-Else
18:54
Using the CASE Statement
17:43
+ The EXCEPTION Clause
7 lectures 01:08:21
Trapping Exceptions
05:32
Identify Exception Details
10:57
Creating User-Defined Exceptions
10:49
Using SQLCODE and SQLERRM Objects
08:29
Understand the Implicit Cursor
14:37
Creating User-Defined Events
12:26
+ Explicit Cursors
6 lectures 01:15:09
Understanding the Concept and Purpose of Explicit Cursors
18:10
Learn about Cursor Attributes
10:12
Using the Continue Statement
05:44
Working with Updateable Cursors
19:25
Creating and Using Cursor Parameters
14:45
FOR...LOOP Cursors
06:53
+ Nested Blocks
2 lectures 23:21
Understanding Nested Blocks
10:46
Difference between Global vs Local Objects and Exceptions
12:35
+ Declared Subprograms
1 lecture 17:37
Subprograms: How They Differ from Nested Blocks
17:37