Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.9
BUY - LIVE Online TrainingBUY TRAINING

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.

Course Details

1. 12 months of on demand access to our training videos on a 24*7 basis.

2. Students receive 13 videos with each such video about 1.5 hours in duration. (with an option to increase the access duration.)

3. 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 until 1 year.)

4. Click HERE to download the training brochure (course topics and more details).

5. The tuition fee for this course is $299 (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.

As per the Tiobe programming index, the Oracle PL/SQL language is among the top 20 most popular programming languages in computer science.

Course Topics

Introduction to Oracle PL/SQL
History of the Oracle PL/SQL language. Anonymous PLSQL block.
Variables.
Data types.
Bind variables.
PLSQL operators.
Nested blocks.
Implicit data conversion.
SELECT INTO statement.
The DBMS_OUTPUT.PUT_LINE built-in procedure.

Control structures
IF-THEN-ELSE statement
CASE statement. The simple CASE and the searched CASE.
Basic Loop and FOR Loops
WHILE Loop
Nested loops and choosing the right loop structure.

Composite data types
Using %ROWTYPE
PLSQL Records
PLSQL Table of Records
INDEX BY Table
INDEX BY Table of Records

Creating Functions
Syntax of CREATE FUNCTION
Benefits of user defined functions
Executing user defined functions
Restrictions on function calls
Dropping functions

Exceptions and Exception handling
What are Exceptions
Need for handling exceptions
Predefined exceptions
User defined exceptions
Non predefined exceptions
Raising Exceptions
Trapping Exceptions
Exception propagation in nested calls
The SQLCODE and SQLERRM in-built PL/SQL functions.
DBMS_UTILITY Package for debugging PL/SQL code.

Creating Procedures
What are Procedures.
Need for Procedures.
Syntax of CREATE PROCEDURE.
Parameter dispositions.
Parameter passing methods.
Executing procedures.
Exceptions in procedures.

Explicit Cursors and Implicit Cursors
What is a cursor.
Implicit and explicit cursors
Creating cursors
Using cursors in procedures
OPEN..FETCH CLOSE construct
The %NOTFOUND operator
FOR UPDATE cursors.
Declare and use cursors with parameters.

Creating Packages
What are packages.
Need for packages
Package Specification
Package Body
Private and Public components
Calling package functions, procedures
Referencing package constants and variables

Package Features
Overloading package subprograms
Forward declaration of subprograms
Creating bodiless package
Persistent state of package variables
Persistent state of package cursor

Oracle Supplied Packages
DBMS_OUTPUT
DBMS_SCHEDULER
UTL_FILE
UTL_RECOMP
UTL_MAIL
EXECUTE IMMEDIATE statement

Working with Database Links
Remote databases
PUBLIC and PRIVATE Database links
Querying data using database links
Creating views on database links

Oracle utilities
SQL*loader (sqlldr)
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


Course Reviews

4.8

4.8
47 ratings
  • 5 stars38
  • 4 stars9
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    I completed several courses with DBA University with Srini Raminini. Srini is a very knowledgeable professional instructor who delivered the classes in an easy going and interactive manner. The classes are very well documented and are up to date. The training environment is fabulous. Its like being there, but from wherever you want. I had to go on a trip to Dominican Republic during the course and could take classes online without any problems. The best setup for your station will be 2 monitors ( laptop and monitor ) and a wired connection. It will make the training very effective as you can look on the blackboard on one screen and have your lab machine on the other screen. The price is very reasonable as well. It’s impossible to find Oracle classes anywhere for this price while the teaching quality is so high. I am looking forward taking a few more courses with DBAUniversity and would recommend this place to everybody who wants to upgrade their knowledge in DBA field.

  2. 5

    I really enjoyed this course.
    Great examples and great teaching style.
    It covered good content.
    Good combination of the theory and practice.
    Classes were interesting.
    Srini is a good presenter.

  3. 4

    I attended the Oracle DBA course presented by Mr. Srini Ramineni; it was well planned and presented course. Mr. Ramineni’s DBA background, experience and way of presenting with practical examples really helped to understand most of Oracle DBA concepts clearly. Initially I was hesitant about the effectiveness of the online course, access to lab servers and availability. I would like to emphasize few important aspects that I liked in this training course, Mr. Ramineni’s Oracle DBA knowledge, his patience and ability to manage audience with different level of knowledge and background, interactive white board teaching experience over traditional PowerPoint presentation, course material, lab server and instructors availability to learn and apply the concepts. I really appreciate Mr. Ramineni’s dedication for extending the course duration to cover the topics that he planned in the course.

    I strongly recommend this course for anyone who is interested start their career as Oracle DBA.

  4. 5

    My experience with DBA-U was a very positive one. The latest class I attended was the Big Data Offering. I am a hands-on learner, and I do not do well with just lectures. The working labs and AWS setup made this course worth every penny. Srini was/is an excellent guide through the Big Data Maze and introducing the class to the tools of the trade as well as solid fundamentals.

  5. 5

    I highly recommend DBA University Inc to anyone looking for hands on DBA training for career change or advancement in the field of database administration.

  6. 5

    The Java course was an excellent course! I loved it! It will help me greatly with future projects.

  7. 5

    DBA University is very good for the ORACLE DBA class that I took recently. The instructor Srini is highly knowledgeable and experienced, and gives realistic examples to make students understand the topic clearly. The course covered all of the topics required for Oracle DBA job. Also, the ebook provided by DBA university is very useful and helpful.
    I am fully satisfied with the class, and I would like to take RAC and ASM class also, in the near future, from DBA university only.

  8. 4

    I took ORACLE DBA 11GR2 class with DBA University during Jun-JUL 2014. Srini ia a awesome tutor. He is methodical and brings in lot of practical example to the board.

    I will not think twice to take any further course with DBAUniversity

  9. 4

    I really enjoyed my Oracle SQL PL/SQL course at the DBA University. The SQL course was very detailed and the instructor was very knowledgeable and he provided a lot of additional information about Oracle some of which are not covered in the course content but very useful in my everyday work as a SQL developer. I would definitely recommend this course for anyone who wish to learn SQL, however, I feel that the PL/SQL section of the course was rushed and I wish we had more time for that.

  10. 5

    I recently took the oracle Dba training at the DBA University taught by Srini Ramineni. I am well pleased with his teaching strategies.He made the course more understandable in the ways he uses graphical explanations to walk the class through real world scenario. The University also provides adequate training materials and Lab practice on steps by steps approach to resolving real world databases issues. In all I have enjoyed the training and I’m looking forward to taking a course in Rac and Asm soon.

  11. 1 2 3 4 5
20 STUDENTS ENROLLED

See what others are buying

Contact Details

DBA University
605 W Madison St Suite 1108
Chicago IL 60661
United States of America

Ph 720 934 1260
Email info@dbauniversity.com

Setup Menus in Admin Panel

X