Oracle 11g PL/SQL Fundamentals I

An introduction to the PL/SQL database programming language
4.4 (58 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.
480 students enrolled
$55
Take This Course
  • Lectures 51
  • Contents Video: 10 hours
  • Skill Level Beginner Level
  • 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 5/2013 English

Course 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).

What are the requirements?

  • Familiarity with database and programming principles

What am I going to get from this course?

  • Prepare your environment
  • Work with Oracle database tools
  • Understand and work work 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

What is the target audience?

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

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
03:13
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. 
Section 2: Preparing Your Environment
Course Setup
37:09
Section 3: Working with Oracle Database Tools
Selecting the Appropriate Database Tool
30:52
Section 4: Language Features
Understanding PL/SQL
18:06
PL/SQL Blocks
15:26
Working with SQL Plus
Preview
11:07
Section 5: The DECLARE Clause
DECLARE Clause Objects
16:32
PL/SQL Available Data Types
17:02
Declaring Simple Data Types and Assignments
12:23
Declaring Complex Data Types and Assignments
10:45
Declaring Complex RowTypes and Assignments
07:08
Declaring Complex Tables
07:51
Declaring Complex Records
08:18
Creating and Declaring User-Defined Types
Preview
08:55
Section 6: The BEGIN Clause
What Can Be Included in the BEGIN Clause
07:08
Working with CHAR and VARCHAR2 Variables
07:37
Handling String Literals
07:47
Working with Numeric Variables
06:47
Working with Date Variables
06:07
Assigning and Using Boolean Variables
07:51
Using Comparison Operators
07:31
Using SQL Functions
06:11
SQL DML within PL/SQL
15:11
Using SELECT
06:39
Exceptions and Embedded SQL
11:23
Using Sequences
14:34
Logic Control and Branching
07:05
Using GOTO
Preview
05:59
Working with LOOPS
19:00
Creating and Using the Indefinite Loop
07:06
Creating and Using the Conditional Loop
08:55
Using Nested Loops
11:40
Using the If-Then-Else
19:01
Using the CASE Statement
17:49
Section 7: The EXCEPTION Clause
What Are the Types of Exceptions
Preview
05:37
Trapping Exceptions
05:39
Identify Exception Details
11:03
Creating User-Defined Exceptions
10:56
Using SQLCODE and SQLERRM Objects
08:36
Understand the Implicit Cursor
14:43
Creating User-Defined Events
12:32
Section 8: Explicit Cursors
Understanding the Concept and Purpose of Explicit Cursors
18:17
Learn about Cursor Attributes
10:19
Using the Continue Statement
05:51
Working with Updateable Cursors
19:31
Creating and Using Cursor Parameters
14:52
FOR...LOOP Cursors
07:00
Section 9: Nested Blocks
Understanding Nested Blocks
10:53
Difference between Global vs Local Objects and Exceptions
12:42
Section 10: Declared Subprograms
Subprograms: How They Differ from Nested Blocks
17:55
Section 11: Conclusion
Conclusion
03:58

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course