MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle PL/SQL 11g - Fundamentals

Course Summary

PL/SQL Language Fundaments,PL/SQL Data Types,Control Structures,Composite Datatypes,Cursors,Exception Handling,Procedure

  • +

    Course Syllabus

    • Overview of PL/SQL
      • Getting Started With PL/SQL
      • Features and Architecture of PL/SQL
      • Quiz
    • Introduction to SQL Developer
      • Getting Started With SQL Developer
      • Practical Demonstration
      • Quiz
    • PL/SQL Language Fundaments
      • Character Sets and Lexical Units
      • PL/SQL Block, Declarations, %TYPE Atribute, Scope and Visibility of Identifiers
      • Expressions and Operators
      • Quiz
    • PL/SQL Data Types
      • Scalar Data types
      • Composite Datatype, LOB Datatype and User-Defined PL/SQL Subtypes
      • Datatype Conversion
      • Quiz
    • Interacting With Oracle Server
      • Statements in PL/SQL
      • Practical demonstration
      • Quiz
    • Control Structures
      • Introduction to Control Structures, Conditional Control Structure and CASE Stat
      • Iterative Control Structures: LOOP, WHILE – LOOP, FOR LOOP
      • Practical Demonstrations
      • Quiz
    • Composite Datatypes
      • Working with Records
      • Working with INDEX BY TABLE
      • Practical Demonstration
      • Quiz
    • Cursors
      • Working with Implicit Cursors
      • Working with Explicit Cursors
      • Working with Cursors and Records, Cursor FOR LOOP
      • Practical Demonstration
      • Quiz
    • Exception Handling
      • Handling PL/SQL Errors
      • Predefined Exceptions
      • Non-Predefined Exceptions
      • User Defined Exceptions
      • Practical Demonstration
      • Quiz
    • Procedures
      • Introduction to Program Units in PL/SQL
      • Starting With Procedures in PL/SQL
      • Parameter Passing Methods and DEFAULT Option
      • Exception Handling in Procedures and Removing Procedure
      • Practical demonstration
      • Quiz
    • Functions
      • Working With Functions
      • Practical demonstration
      • Quiz
    • Managing Subprograms
      • Working with Records
      • Practical demonstration
      • Quiz

Course Fee:
USD 129

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Enterprise Applications and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top