The Ultimate Oracle, SAP & Salesforce Training Prep Bundle

6 Courses & 85 Hours

$24.99$60.00

You save 58%

What's Included

$10.00 Value

Oracle 11g PL/SQL Part 1

Intellezy

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

Intellezy | Computer Training Specialists

4.4/5 average rating: ★ ★ ★ ★ ★ ★

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

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

4.5/5 average rating: ★ ★ ★ ★ ★ ★

Access 51 lectures & 9 hours of content 24/7
Understand PL SQL1
Declare simple & complex data types and assignments
Declare complex row types & assignments
Declare complex tables & records
Work with CHAR & VARCHAR2 variables
Work with numeric & data variables
Assign & use Boolean variables
Understand the difference between global vs local objects & exceptions

"The instructor's explanations are very well organized, articulate, and thorough. One of the best online courses on PL/SQL I've sampled. Great course for beginners as well as experienced professionals looking for a refresher" – Rodney

Specs

Important Details

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

Requirements

Understanding of basic database architecture

$10.00 Value

Oracle 11g PL/SQL Part 2

Intellezy

46 Lessons (10h)

Lifetime

$10.00 Value

Complete Salesforce Trailhead 2021: From Zero to Hero Bundle: 7 Courses in 1

Jimmy Tanzil

234 Lessons (53h)

Lifetime

$10.00 Value

Oracle 12C Release 2 Backup & Recovery Using RMAN

Oak Academy

39 Lessons (6h)

Lifetime

$10.00 Value

Learn SAP ABAP: SAP ABAP Programming Language for Beginners

Oak Academy

109 Lessons (6h)

Lifetime

$10.00 Value

SAP Netweaver ABAP Developer Edition Installation

Oak Academy

14 Lessons (1h)

Lifetime

Terms

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

Your cart is empty. Continue Shopping!

Processing order...