CATEGORY: Working Area

PL/SQL Fundamentals

Course Access: Lifetime
Course Overview

About this course:

The PL/SQL course is for anyone who is keen on learning the fundamentals of PL/SQL in Oracle. PL/SQL is a procedural extension for SQL and the Oracle database, made by Oracle. Pl/SQL can boost productivity as well as save time on design and debugging. Learning PL/SQL goes a long way in learning about databases,

Course Pre-requisites:

  • Familiarization with SQL concepts is useful

Learning Units:

  • Unit 1: Flow Control

  • Unit 2: Cursors

  • Unit 3: Handling Runtime Errors

  • Unit 4: Stored Procedures and Functions

  • Unit 5: Working with Composite Data Types

  • Unit 6: PL/SQL Variables

  • Unit 7: Anonymous PL/SQL Blocks

  • Unit 8: Declare Identifiers and Trap Exceptions

  • Unit 9: Triggers

  • Unit 10: Using Dynamic SQL 

  • Unit 11: PL/SQL Packages

Pass Requirement:

Minimum of 60% for the Master Quiz.
Minimum of 60% for the IKM assessment.

Course Duration:

1 Week

Access Duration:

1 Month

Submit a Comment

Your email address will not be published. Required fields are marked *