Your Cart

Your cart is empty. Continue Shopping!

Processing order...

The Oracle 11g PL/SQL Bootcamp Bundle

2 Courses & 19 Hours

Deal Price$19.99

Suggested Price

$54.00

You save 62%

What's Included

$27.00 Value

Oracle 11g PL/SQL Part 1

Intellezy Learning

51 Lessons (9h)

Lifetime

Experience level required: Beginner
Access 51 lectures & 9 hours of content 24/7
Length of time users can access this course: Lifetime

Course Curriculum

51 Lessons (9h)

Your First Program
Preview
Introduction
Introduction3:06
Preparing Your Environment
Course Setup37:03
Working with Oracle Database Tools
Selecting the Appropriate Database Tool30:45
Language Features
Understanding PL SQL17:59
PL SQL Blocks15:19
Working with SQL Plus11:00
The DECLARE Clause
DECLARE Clause Objects16:25
PL SQL Available Data Types16:55
Declaring Simple Data Types and Assignments12:16
Declaring Complex Data Types and Assignments10:38
Declaring Complex RowTypes and Assignments7:02
Declaring Complex Tables7:44
Declaring Complex Records8:12
Creating and Declaring User-Defined Types8:48
The BEGIN Clause
What Can Be Included in the BEGIN Clause7:02
Working with CHAR and VARCHAR2 Variables7:30
Handling String Literals7:41
Working with Numeric Variables6:40
Working with Date Variables6:00
Assigning and Using Boolean Variables7:44
Using Comparison Operators7:24
Using SQL Functions6:04
SQL DML within PL SQL15:05
Using SELECT6:32
Exceptions and Embedded SQL11:16
Using Sequences14:28
Logic Control and Branching6:58
Using GOTO5:52
Working with LOOPS18:53
Creating and Using the Indefinite Loop6:59
Creating and Using the Conditional Loop8:48
Using Nested Loops11:33
Using the If-Then-Else18:54
Using the CASE Statement17:43
The EXCEPTION Clause
What Are the Types of Exceptions5:31
Trapping Exceptions5:32
Identify Exception Details10:57
Creating User-Defined Exceptions10:49
Using SQLCODE and SQLERRM Objects8:29
Understand the Implicit Cursor14:37
Creating User-Defined Events12:26
Explicit Cursors
Understanding the Concept and Purpose of Explicit Cursors18:10
Learn about Cursor Attribute10:12
Using the Continue Statement5:44
Working with Updateable Cursors19:25
Creating and Using Cursor Parameters14:45
FOR...LOOP Cursors6:53
Nested Blocks
Understanding Nested Blocks10:46
Understanding the Difference between Global vs Local Objects and Exceptions12:35
Declared Subprograms
What Are Subprograms and How Are They Different from Nested Blocks17:37
Conclusion
Course Recap3:52

Oracle 11g PL/SQL Part 1

Intellezy LearningIntellezy Learning
A professional delivery should be accompanied by an equally impressive presentation. While other video eLearning solutions utilize "at-home technology" to film and produce content, Intellezy’s video library is produced by professionals, in a studio, for professionals like you. Start watching and find out how valuable 3 minutes can be.

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

Access 51 lectures & 9 hours of content 24/7
Work with Oracle database tools
Learn about the language features
Use the DECLARE, BEGIN, & EXCEPTION clauses
Understand the concept & purpose of explicit cursors
Learn the difference between Global vs Local Objects and Exceptions
Know what subprograms are & how they are different from nested blocks

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop & mobile
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner
Have questions on how digital purchases work? Learn more here

Requirements

Any device with basic specifications

$27.00 Value

Oracle 11g PL/SQL Part 2

Intellezy Learning

46 Lessons (10h)

Lifetime

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

The Oracle 11g PL/SQL Bootcamp Bundle

2 Courses & 19 Hours

Deal Price$19.99

Suggested Price

$54.00

You save 62%

What's Included

$27.00 Value

Oracle 11g PL/SQL Part 1

Intellezy Learning

51 Lessons (9h)

Lifetime

Experience level required: Beginner
Access 51 lectures & 9 hours of content 24/7
Length of time users can access this course: Lifetime

Course Curriculum

51 Lessons (9h)

Your First Program
Preview
Introduction
Introduction3:06
Preparing Your Environment
Course Setup37:03
Working with Oracle Database Tools
Selecting the Appropriate Database Tool30:45
Language Features
Understanding PL SQL17:59
PL SQL Blocks15:19
Working with SQL Plus11:00
The DECLARE Clause
DECLARE Clause Objects16:25
PL SQL Available Data Types16:55
Declaring Simple Data Types and Assignments12:16
Declaring Complex Data Types and Assignments10:38
Declaring Complex RowTypes and Assignments7:02
Declaring Complex Tables7:44
Declaring Complex Records8:12
Creating and Declaring User-Defined Types8:48
The BEGIN Clause
What Can Be Included in the BEGIN Clause7:02
Working with CHAR and VARCHAR2 Variables7:30
Handling String Literals7:41
Working with Numeric Variables6:40
Working with Date Variables6:00
Assigning and Using Boolean Variables7:44
Using Comparison Operators7:24
Using SQL Functions6:04
SQL DML within PL SQL15:05
Using SELECT6:32
Exceptions and Embedded SQL11:16
Using Sequences14:28
Logic Control and Branching6:58
Using GOTO5:52
Working with LOOPS18:53
Creating and Using the Indefinite Loop6:59
Creating and Using the Conditional Loop8:48
Using Nested Loops11:33
Using the If-Then-Else18:54
Using the CASE Statement17:43
The EXCEPTION Clause
What Are the Types of Exceptions5:31
Trapping Exceptions5:32
Identify Exception Details10:57
Creating User-Defined Exceptions10:49
Using SQLCODE and SQLERRM Objects8:29
Understand the Implicit Cursor14:37
Creating User-Defined Events12:26
Explicit Cursors
Understanding the Concept and Purpose of Explicit Cursors18:10
Learn about Cursor Attribute10:12
Using the Continue Statement5:44
Working with Updateable Cursors19:25
Creating and Using Cursor Parameters14:45
FOR...LOOP Cursors6:53
Nested Blocks
Understanding Nested Blocks10:46
Understanding the Difference between Global vs Local Objects and Exceptions12:35
Declared Subprograms
What Are Subprograms and How Are They Different from Nested Blocks17:37
Conclusion
Course Recap3:52

Oracle 11g PL/SQL Part 1

Description

Access 51 lectures & 9 hours of content 24/7
Work with Oracle database tools
Learn about the language features
Use the DECLARE, BEGIN, & EXCEPTION clauses
Understand the concept & purpose of explicit cursors
Learn the difference between Global vs Local Objects and Exceptions
Know what subprograms are & how they are different from nested blocks

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop & mobile
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner
Have questions on how digital purchases work? Learn more here

Requirements

Any device with basic specifications

$27.00 Value

Oracle 11g PL/SQL Part 2

Intellezy Learning

46 Lessons (10h)

Lifetime

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

The Oracle 11g PL/SQL Bootcamp Bundle | New Atlas Deals