Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.8
BUY ON DEMAND TRAININGBUY LIVE TRAINING
12-DEC-2020 to 10-JAN-2021
BUY 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. 4

    i enjoyed my PL/SQL training class the best please to take the program i look forward to take more classes with DBA

  2. 5

    Oracle PL/SQL is a good course from DBA university, instructor is very knowledgeable. The course materials is very helpful for learning

  3. 5

    I recently took the Oracle DBA course taught by Srini Ramineni. I was impressed with the course and the way the material was presented. I have taken much more expensive training where the instructor simply puts the book material in a Powerpoint presentation and reads it line by line. This course is not like that. It is very interactive. All of the material is written on a white board and explained in a way that is easy to understand. This is a fantastic course and will provide you with a good, solid core set of DBA skills. I would definitely consider taking another course from DBA University.

    Dennis

  4. 5

    I have really enjoyed the Oracle DBA training sessions. I highly appreciate the level of patience and professionalism from Srini Ramineni. He is an excellent trainer with unique approach. I have never come across such intense, well-structured, and hand-on online training before. This is one of a kind. Thanks to DbaUniversity!!

  5. 5

    I have taken the Oracle Rac and Dataguard course with Michael Melchar. It was a great class. The lab was well designed that I can really get hand on experience for setting up the RAC environment. Without the help from Michael, I don’t think I can do it myself. I have been an DBA for 20 years but I tried to learn RAC. It was very difficult until I took this class. The price is extremely pleasant compare to Oracle. I also like the schedule that we meet 2 hours a day for 4 days a week. At such, you have a chance to digest the class material.

  6. 5

    I took the Oracle DBA course and was very impressed with the teaching method and course material. Srini is a top notch instructor. He is very detailed in explaining different scenarios, and answers questions very well. I have learnt a lot from Srini’s vast knowledge and real life working experience. I just had a job interview with a senior dba, and most of the questions asked were scenarios explained in class by Srini. I would absolutely recommend DBA University to anyone wishing to get into the oracle dba field.

  7. 5

    I recently took Oracle RAC and data guard class with Michelle Malcher, It was simply a great class. Michelle is highly knowledgeable, her course material and classes were very informative. We had sufficient time to complete the lab and learnt a lot and the course was pretty hands-on. I have tried creating RAC myself in the past but was never successful, but after taking the course it helped me and makes me feel very confident. We created the RAC and data guard environments on our personal laptop which is much better, even for future reference. I would highly recommend anybody looking for a career as DBA.

  8. umugwaneza Marie Providence01/23/2015 at 7:55 am

    5

    As a DBA Junior, I took the PL/SQL Course in march 2014 and ORACLE DBA in august 2014 from DBA university. The DBA university has an excellent way of teaching and transmetting knowledge through its expert teacher in database administration and programming. I have improve myself and I met my career goal. The lecture and training materials are well organized , the lab practice was very helpful. The Instructor is very smart, patient and answered questions. I would recommend for anyone who is interested to learn this course, He won’t regret. I am preparing for next course with DBA Center of ORACLE RAC, DATA GUARD

  9. 4

    Interactive session with lab sessions and very useful tips during the sessions. No disappointment at all for anyone.
    Thanks to Srini.

  10. 5

    I have taken the DBA I, Srini is an excellent teacher. What I like about him is that, he is passionate about this teaching thing. He makes sure that you understand the materials. The most notable part of this class was, Srini would bring a up a situation from real world and discuss it in the class then solve the problem. I felt very comfortable with his teaching technique, I am thinking of taking the PS/SQL course with him.

  11. 1 2 3 4 5
31 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