The Ultimate Oracle, SAP & Salesforce Training Prep Bundle

6 Courses & 85 Hours
$24.99$1,200.00
You save 97% -

What's Included

Oracle 11g PL/SQL Part 1
  • 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
  • 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

I
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

Requirements

  • Understanding of basic database architecture

Terms

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