top of page
Login
Image by Oleg Demakov

Perfect career with perfect training

Level up your database skills and become a sought-after developer. Automate tasks, boost efficiency, and write clean, maintainable code.

  • Sessions and Duration

    • 2 weeks training starting Jan 08, 2024

    • Session on weekdays (Monday to Friday)

     

    Timings:

    • 04:00 pm - 05:00 pm IST (Indian Standard Time)

    • 05:30 am - 06:30 am EST (Eastern Standard Time)

    • 10:30 am - 11:30 am GMT (Greenwich Mean Time)

  • Module 1: PL/SQL Basics

    • PL/SQL block structure

    • Variables and data types

    • Conditional statements (IF, CASE)

    • Loops (WHILE, FOR)

    • Exception handling (TRY-CATCH)

    Module 2: SQL in PL/SQL

    • Embedding SQL in PL/SQL

    • Cursors in PL/SQL

    • Implicit vs. explicit cursors

    • Cursor attributes and operations

    Module 3: PL/SQL Procedures

    • Creating and executing procedures

    • Input and output parameters

    • Calling procedures from SQL and PL/SQL

     

    Module 4: PL/SQL Functions

    • Creating and executing functions

    • Returning values from functions

    • Calling functions from SQL and PL/SQL

     

    Module 5: PL/SQL Triggers

    • Introduction to triggers

    • Trigger types (BEFORE, AFTER, INSTEAD OF)

    • Trigger syntax and execution

    • Trigger examples and use cases

     

    Module 6: PL/SQL Packages

    • Understanding packages

    • Creating and using packages

    • Package specifications and bodies

    • Access control and encapsulation

     

    Module 7: Dynamic SQL in PL/SQL

    • Dynamic SQL concepts

    • EXECUTE IMMEDIATE statement

    • Dynamic SQL examples

    • Security considerations

     

    Module 8: Error Handling and Debugging

    • Error handling best practices

    • DBMS_ERRLOG and EXCEPTION_INIT

    • Debugging tools and techniques

    • Profiling and performance tuning

  • Design a database for Netflix which will store movies, actors, directors, and genres. Develop PL/SQL procedures to add/update/delete movies, search by title/genre/actor, recommend similar movies based on user ratings, etc.

Oracle's powerful language.

Oracle PL/SQL

Gain the expertise you need to master the latest features and capabilities of Oracle's most advanced database technology.

  • Sessions and Duration

    • 4 weeks training starting May 06, 2024

    • Session on weekdays (Monday to Friday)

    Timings:

    • 04:00 pm - 05:00 pm IST (Indian Standard Time)

    • 06:30 am - 07:30 am EST (Eastern Standard Time)

    • 11:30 am - 12:30 am GMT (Greenwich Mean Time)

  • Module 1: Oracle 21c Architecture

    • Oracle Instance vs Database

    • Multi-tenant Overview

    • SGA, PGA and 

    • Loops (WHILE, FOR)

    • Exception handling (TRY-CATCH)

    Module 2: SQL in PL/SQL

    • Embedding SQL in PL/SQL

    • Cursors in PL/SQL

    • Implicit vs. explicit cursors

    • Cursor attributes and operations

    Module 3: PL/SQL Procedures

    • Creating and executing procedures

    • Input and output parameters

    • Calling procedures from SQL and PL/SQL

     

    Module 4: PL/SQL Functions

    • Creating and executing functions

    • Returning values from functions

    • Calling functions from SQL and PL/SQL

     

    Module 5: PL/SQL Triggers

    • Introduction to triggers

    • Trigger types (BEFORE, AFTER, INSTEAD OF)

    • Trigger syntax and execution

    • Trigger examples and use cases

     

    Module 6: PL/SQL Packages

    • Understanding packages

    • Creating and using packages

    • Package specifications and bodies

    • Access control and encapsulation

     

    Module 7: Dynamic SQL in PL/SQL

    • Dynamic SQL concepts

    • EXECUTE IMMEDIATE statement

    • Dynamic SQL examples

    • Security considerations

     

    Module 8: Error Handling and Debugging

    • Error handling best practices

    • DBMS_ERRLOG and EXCEPTION_INIT

    • Debugging tools and techniques

    • Profiling and performance tuning

  • Design a database for Netflix which will store movies, actors, directors, and genres. Develop PL/SQL procedures to add/update/delete movies, search by title/genre/actor, recommend similar movies based on user ratings, etc.

World's most powerful database.

Oracle 19c ASM Administration

Gain the expertise you need to master the latest features and capabilities of Oracle's most advanced database technology.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

Future of database mystery.

Join Now for $799

Oracle 21c Administration

Elevate your database management skills to ensure high availability and scalability with Oracle 21c Real Application Cluster

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

High efficiency in clusters.

Join Now for $799

Oracle 21c RAC

Skyrocket your cloud skills with Oracle Cloud Infrastructure online training. 

Gain expertise in containerization, security, and automation.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

  • This is your Product section paragraph. It’s an ideal place to showcase the types of products available, and underline any important or unique features.

Your cloud starts here.

Join Now for $799

Oracle Cloud Infrastructure

bottom of page