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 have just finished taking the Oracle DBA course at DBA University and I’ve learned a ton. I found the course to be very well structured and was delivered in a way anyone can learn and develop a skill set that will make a difference. The training materials were user-friendly with a very informative text-book that is easy to read and understand. The labs were well organized with step-by step categories that are color coded for ease reference.

    My teacher was Srini Ramineni and he did an awesome job. I found him to be a very knowledgeable instructor who knows his subject matter. He was very clear and thorough in every topic and I have gained a lot of knowledge from watching and listening to his lectures. As a visual learner myself, I have benefitted greatly from his labs demonstrations and the diagrams that he draws to elaborate on the key points that should not be missed by any future DBA. Without doubt, he knows how to break down even the most seemingly complex topic and he teach it in a way anyone can understand. As a student who took the recorded version of the training, I never felt alone or forgotten. Whenever I needed help, my instructor was available without fail and in a timely fashion. He made my learning experience to be fun and indeed, I enjoyed every step of the way.

    To anyone who is looking to learn a skill set that will change your life for the better, DBA University is a great place to be. You can rest assured that you will be equipped with knowledge and ability that will lead to a very rewarding career.

    Margaret
    Worcester, Massachusetts

  2. 5

    Oracle DBA course material is very well prepared and organized. Lab practices and home works are very well timed with the topics covered during the training sessions. Most importantly, the experienced, knowledgeable and professional instructor (Srini) is excellent in teaching, training and preparing the students to achieve their future career goals in the database field. If needed, the instructor also goes beyond the training schedule to cover the material. I not only recommend the course, but also strongly recommend any courses that are offered by this instructor. And I have already registered myself for the next course (“Oracle RAC, ASM and DG”) offered by the same instructor.

    ################################

    I have taken the course “Oracle RAC, ASM and DG” at the DBA University. It’s an excellent course tought by experienced, knowledgeable and professional instructor (Srini Ramineni). 25% of training on lab machine and remaining will be on student’s PCs so that it helps student to continue to practice even after the course is completed. I also strongly recommend this course and any other courses offered by this instructor.

  3. 5

    Oracle DBA training is an excellent course to get your head around the key concepts of Oracle 11G and 12c. Srini does an excellent job explaining and teaching by real-world examples. Coming from a SQL Server background he was able to explain the similarities and differences to help me understand Oracle perfectly. I would recommend this course to anyone looking to learn Oracle and definitely sign up for the second part which is on ASM, RAC and Data Guard. I have signed up and am looking forward to it.

  4. 5

    It was a nice experience for me taking oracle DBA online training from dba university.The study material is well prepared and very clear for a beginner to follow .I really like the teaching style of our experienced instructor (Srini Ramineni) and his quick response for every student.The class is mix of theory and lab practice which makes learning more interesting.From my point of view this course is better than class room training .So i highly recommend this course .

  5. 5

    I really enjoyed this training class. Had little knowledge about rdbms, but Srini explained every step in his dba training materials and made sure ever student understood the concept and real world application.

    Very satisfied with the knowledge I gained from this training.

  6. 5

    I have recently finished Oracle DBA, training from DBA University. Srini is a very well experienced teacher with hands on industry experience. He explains the DBA concepts very well with LAB examples. This course is better than class room training. I highly recommend this course.

  7. 5

    It was a big experience for me taking this online course whith really white board ,Srini is a very good teacher who have a big understanding of the subject 9Oracle dba). I will take more course with Dba University…Highly recommended for everyone ….And the price is reasonable…

  8. 5

    Last month I finished the Oracle DBA Training and it was a great course. Srini Ramineni has a lot of experience in the industry and he explains really well. For me this course was complementary because I have experience as an Oracle DBA and I took the official course “Workshop I” by Oracle University, but there are many topics where they used GUI (Enterprise Manager) however the method used in Oracle DBA Training by DBA University is different because they work with command line (sql plus) and most of the companies required these skills.

  9. 5

    I attended Core DBA training online from DBA University. I really like Srini Ramineni teaching fashion which easily makes his student involve into the subject because his way of delivering topics are really impressing. He brings real time challenging topics that he has experienced in his career and explain it in a sweet way which give me confident to build my carrier as an Oracle DBA. LAB facility is full day during the weekend and 5 hours during week days. I always wanted to be a part of a game not to just watch a game and I achieved same in “DBA University”.

  10. 5

    I have recently finished Oracle DBA, RAC, ASM and Data Guard from DBA University. Srini is a very well experienced teacher who has lots of hands on industry experience. He explains each and every topic very well and makes learning really easy for you. You don’t really want to miss any moment of his class. He is a wonderful teacher. I am looking forward to join his Hadoop Class also.

  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