The Oracle 11g PL/SQL Bootcamp Bundle

2 Courses & 19 Hours
$20.00$400.00
You save 95% -

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

IL
Intellezy Learning

Intellezy 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

Terms

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