Oracle PL/SQL Training
We are currently offering very interactive Oracle PL/SQL training program with excellent remote lab access for interested students and professionals. Registration for our Oracle PL/SQL classes is open for anyone in the world because it is an online course.
Oracle Certified Associate (OCA) Certification
Students can use this training to prepare for most of the topics required to pass the Oracle Database 11g: Program with PL/SQL Exam 1Z0-144 as part of their Oracle OCA certification. The first exam is the Oracle SQL Exam in the OCA certification. If you are new to Oracle databases, then we strongly recommend you to first take our Oracle SQL Training and it will help you prepare for the Oracle Database 12c SQL 1Z0-071 exam. If you pass both these exams, you will get the Oracle OCA certification.
1. Taught by Srini Ramineni. Srini is also the founder of DBA University. His profile can be read here.
2. 12 months of on demand access to our training videos on a 24*7 basis.
3. Students receive 13 videos with each such video about 1.5 hours in duration.
4. Each student receives a dedicated Remote Desktop Connection to practice all the lab exercises for this course. This remote lab access is available for 6 months with an option to increase the duration for 1 year.
6. The tuition fee for this course is $499 (all-inclusive fee).
The demand for Oracle PL/SQL programmers
If you work with an Oracle database, you must have good PL/SQL programming skills. Furthermore, because Java is part of Oracle, most of the Oracle software development projects involve PL/SQL database programming tasks. Many Microsoft .NET and other application developers who use Oracle database as the backend repository must be proficient in programming with the Oracle PL/SQL language.
Introduction to Oracle PL/SQL
History of the Oracle PL/SQL language. Anonymous PLSQL block.
Implicit data conversion.
SELECT INTO statement.
The DBMS_OUTPUT.PUT_LINE built-in procedure.
CASE statement. The simple CASE and the searched CASE.
Basic Loop and FOR Loops
Nested loops and choosing the right loop structure.
Composite data types
PLSQL Table of Records
INDEX BY Table
INDEX BY Table of Records
Syntax of CREATE FUNCTION
Benefits of user defined functions
Executing user defined functions
Restrictions on function calls
Exceptions and Exception handling
What are Exceptions
Need for handling exceptions
User defined exceptions
Non predefined exceptions
Exception propagation in nested calls
The SQLCODE and SQLERRM in-built PL/SQL functions.
DBMS_UTILITY Package for debugging PL/SQL code.
What are Procedures.
Need for Procedures.
Syntax of CREATE PROCEDURE.
Parameter passing methods.
Exceptions in procedures.
Explicit Cursors and Implicit Cursors
What is a cursor.
Implicit and explicit cursors
Using cursors in procedures
OPEN..FETCH CLOSE construct
The %NOTFOUND operator
FOR UPDATE cursors.
Declare and use cursors with parameters.
What are packages.
Need for packages
Private and Public components
Calling package functions, procedures
Referencing package constants and variables
Overloading package subprograms
Forward declaration of subprograms
Creating bodiless package
Persistent state of package variables
Persistent state of package cursor
Oracle Supplied Packages
EXECUTE IMMEDIATE statement
Working with Database Links
PUBLIC and PRIVATE Database links
Querying data using database links
Creating views on database links
SQL Tracing and TKPROF
Profiling PL/SQL code using DBMS_HPROF supplied package.
Oracle Net Services
Understanding Oracle networking layer
Configuring net service (TNSNAMES) using NETCA
Bulk Data Processing with PL/SQL
PL/SQL Run Time engine and SQL Run Time engine
Context switching between PL/SQL Run Time engine and SQL Run Time engine.
BULK COLLECT operation in PL/SQL
FOR ALL operation in PL/SQL
Exception Handling during Bulk Data Processing.
Real world Life of an Oracle SQL, PLSQL Developer