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: Transactions, Dynamic SQL & Debugging

Course Summary

In this course, we will talk in detail about transaction management in Oracle. We will take an in-depth look at dynamic SQL and debugging options in PL/SQL, and explore in detail the SQL Developer Debugger.


  • +

    Course Syllabus

    Introduction
    - 6m 30s

    —Overview 2m 54s
    —Prerequisites 1m 3s
    —Audience 1m 5s
    —Tools 1m 27s
    Transaction Management in PL/SQL
    - 50m 9s

    —Transaction Management in Oracle 8m 22s
    —Transaction Names & Read Only Transactions 4m 41s
    —Commits 4m 18s
    —Rollbacks & Statement Level Atomicity 3m 52s
    —Demo: Commit & Rollback 9m 40s
    —Savepoints 6m 8s
    —Demo: Savepoints 7m 5s
    —Explicit Locks 5m 7s
    —Summary 0m 54s
    Autonomous Transactions
    - 27m 36s
    Native Dynamic SQL
    - 58m 47s
    Dynamic SQL Using DBMS_SQL
    - 1h 1m
    Debugging PL/SQL Code
    - 37m 22s


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