Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.8
BUY RECORDED TRAININGBUY RECORDED TRAINING
12 months video access
6 months lab access
BUY RECORDED TRAINING
12 months video access
6 months lab access
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. 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.

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

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.

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
48 ratings
  • 5 stars39
  • 4 stars9
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    Totally recommend and encourage to take this training. It´s a great support along Oracle SQL training plan, since this is focused on database progamming. Excellent experience and looking forward to continue studying in DBA University.

  2. 5

    I took 2 courses (oracle DBA training and SQL training ) at DBA university. Both courses were well presented and had a good number of labs. SRINI is a great instructor and has a lot of experience. He has great knowledge on database administration.He is very engaging and patient.He provided very good and clear explanations of very difficult concepts and made sure every student was on the same page.I learned a lot of valuable information from him and was able to pass my exams.I can only say job well done and money well spent. I am currently taking my 3rd course( Oracle RAC ,ASM and DATA GUARD ) and so far i am having a wonderful experience.

  3. Kadhir Velavan Ramasubramanian01/14/2017 at 3:51 pm

    5

    I underwent training in this DBA university and the faculty is amazing…I didnt expect this much of information to be acquired out of this training. The faculty uses white board and instant lab sessions, so you will feel like typical classroom training and since the lab sessions are completed then and there, you dont need to work hard after the session gets over. You just need to be focused and follow instruction of the faculty to become a expert DBA either in core concepts or in RAC,ASM and DG. The training is truly amazing and enhanced my knowledge multi fold.

  4. 5

    I felt its worth spending time and money on Oracle DBA training session provided by srini , am from different background and never felt its difficult in shifting my career towards oracle DBA it was that smooth and clean training provided by srini.

    Am looking forward to take RAC DBA training session.

  5. 4

    It was really great to be a part of ORACLE SQL class. Teacher was very cooperative and helpful. I am planning to do more classes with them in future.

  6. 4

    DBA training was very good , dedicated and gave us the most important topics that we need as an oracle DBA .My advice to all is to be prepared for this course study day by day as you could and keep searching about more details to get the full benefit from this training .
    Thanks to Srini he was very helpful ,patient and friendly.

  7. 5

    Very few trainers spend time explaining every detail of a course. I have had the chance to do just one course (Oracle DBA) at DBA university, but will not hesitate one moment taking up another course. The trainer summarized his tremendous experience in the IT sector, and passed it on to the students, addressing every concept that matters with practical exercises! At the beginning it was not that easy, but thanks to the trainer for making it possible to enjoy an entirely new domain.
    Beside the skills, the platform is amazing. The sound quality is excellent!
    I could not differentiate from a traditional 4-wall classroom…GREAT JOB!

  8. 5

    I took the Oracle RAC ASM DG course and thoroughly enjoyed it. This was my second course with DBA University (the first being the Oracle DBA Training course), and both were well worth it.

    Srini is a pretty knowledgeable instructor. Not only did he explain things clearly but he related the course material to real-life situations as well.

    I wish such advanced topics as encryption, data masking, Virtual Private Databases, etc. had been covered. Maybe something for the future or possibly even a new course altogether!

    I strongly recommend these courses for anyone thinking about going into Oracle database administration, and I won’t hesitate to take future courses with DBA University.

  9. 1 3 4 5
38 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
Bitnami