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 Fundamentals - Part 1

Course Summary

In this course you will learn about the fundamentals of Oracle PL/SQL programming language. You will gain a solid understanding of Pl/SQL datatypes and programming constructs like loops, conditional execution, cursors and exception handling, which will en


  • +

    Course Syllabus

    ● Course Introduction
        ◦ What is PL/SQL?
        ◦ Why learn PL/SQL?
        ◦ Audience
        ◦ How is PL/SQL Processed?
        ◦ Tools
    ● Anonymous Blocks
        ◦ Overview
        ◦ What is an Anonymous Block?
        ◦ Structure of Anonymous Blocks
        ◦ Comments in Anonymous Blocks
        ◦ Demo of Anonymous Block Structure and Comment Styles
        ◦ Nesting of Anonymous Blocks
        ◦ Scope and Visibility of Variables in Nested Blocks
        ◦ Labels
        ◦ Demo: Scope and Visibility of Variables and Block Labels
        ◦ Summary
    ● PL/SQL Commonly Used Datatypes
        ◦ Introduction
        ◦ Number: Fixed and Floating Type
        ◦ Assignments, Defaults and Constants
        ◦ Demo: Numbers
        ◦ Subtypes
        ◦ %TYPE
        ◦ PLS_INTEGER or BINARY_INTEGER
        ◦ BINARY_DOUBLE and BINARY_FLOAT
        ◦ Character Datatypes
        ◦ Demo: Character
        ◦ DateTime Datatypes
        ◦ Demo: DateTime Datatypes
        ◦ Interval Datatype
        ◦ Time Datatype Usage Guidelines
        ◦ Boolean Datatype
        ◦ Composite Datatype: Records
        ◦ Composite Datatype: %ROWTYPE
        ◦ Other Datatypes
        ◦ Summary
    ● Loops
        ◦ Overview
        ◦ Simple Loops
        ◦ Demo: Simple Loops
        ◦ FOR Loops
        ◦ Demo: FOR Loop
        ◦ FOR Loop Counter
        ◦ Continue Statement
        ◦ Nesting of Loops
        ◦ Exit When & Continue When
        ◦ While Loop
        ◦ Summary
    ● Conditional Execution
        ◦ Overview
        ◦ If Elseif Else Statements & Nesting
        ◦ Demo: If Elsif Else Statements & Nesting
        ◦ Case Statement
        ◦ Case Expressions
        ◦ Demo: Case Statement & Expressions
        ◦ Summary
    ● Cursors
        ◦ Introduction
        ◦ Implicit Cursors
        ◦ Demo: Implicit Cursors
        ◦ Explicit Cursors
        ◦ Cursor FOR Loop
        ◦ Cursor FOR Update
        ◦ Ref Cursors or Cursor Variables
        ◦ Weak Ref Cursors
        ◦ Cursor Expressions
        ◦ Summary
    ● Exceptions
        ◦ Introduction
        ◦ Oracle Internal Exceptions
        ◦ Predefined Exceptions
        ◦ User Defined Exceptions
        ◦ Exception Scope & Propagation
        ◦ Summary
    ● Debugging
        ◦ Introduction
        ◦ DBMS_OUTPUT
        ◦ DBMS_UTILITY
        ◦ Demo: DBMS_OUTPUT & DBMS_UTILITY
        ◦ SQLDeveloper Debugger: Privileges & Setup
        ◦ Debugging with SQLDeveloper
        ◦ Debugging an Exception with SQLDeveloper
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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