Course Highlights
  • Prepare your environment
  • Work with Oracle database tools
  • Understand and work with 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
Skills you will learn!
Curriculum

1 Topic
Introduction

1 Topic
Course Setup

1 Topic
Selecting the Appropriate Database Tool

3 Topics
Understanding PL/SQL
PL/SQL Blocks
Working with SQL Plus

8 Topics
DECLARE Clause Objects
PL/SQL Available Data Types
Declaring Simple Data Types and Assignments
Declaring Complex Data Types and Assignments
Declaring Complex RowTypes and Assignments
Declaring Complex Tables
Declaring Complex Records
Creating and Declaring User-Defined Types

20 Topics
What Can Be Included in the BEGIN Clause
Working with CHAR and VARCHAR2 Variables
Handling String Literals
Working with Numeric Variables
Working with Date Variables
Assigning and Using Boolean Variables
Using Comparison Operators
Using SQL Functions
SQL DML within PL/SQL
Using SELECT
Exceptions and Embedded SQL
Using Sequences
Logic Control and Branching
Using GOTO
Working with LOOPS
Creating and Using the Indefinite Loop
Creating and Using the Conditional Loop
Using Nested Loops
Using the If-Then-Else
Using the CASE Statement

7 Topics
What Are the Types of Exceptions
Trapping Exceptions
Identify Exception Details
Creating User-Defined Exceptions
Using SQLCODE and SQLERRM Objects
Understand the Implicit Cursor
Creating User-Defined Events

6 Topics
Understanding the Concept and Purpose of Explicit Cursors
Learn about Cursor Attributes
Using the Continue Statement
Working with Updateable Cursors
Creating and Using Cursor Parameters
FOR...LOOP Cursors

2 Topics
Understanding Nested Blocks
Difference between Global vs Local Objects and Exceptions

1 Topic
Subprograms: How They Differ from Nested Blocks

1 Topic
Conclusion

  Write a Review

Oracle 11g PL/SQL Fundamentals I

Go to Paid Course