About the Course

This course is designed for fresh grads, programmers/developers. The creation of PL/SQL programs, executing the PL/SQL program units, maintaining or managing PL/SQL program units are dealt in greater details. In addition, commonly used Oracle-supplied packages are also included and explained with examples. The student/participant in the course would gain in-depth knowledge of PL/SQL program units such as cursors, stored procedures, stored functions, packages, triggers.

2 General Programming Language Fundamentals 2.1 PL/SQL Programming Fundamentals 2.1.1 Make Use of PL/SQL Components 2.1.2 Male Use of PL/SQL Variables 2.1.3 Handle PL/SQL Reserved Words 2.1.4 Make Use of Identifiers in PL/SQL 2.1.5 Make Use of Anchored Data Types 2.1.6 Declare and Initialize Variables 2.1.7 Understand the Scope of a Block, Nested Blocks, and Labels

3 SQL in PL/SQL 3.1 Making Use of DML in PL/SQL 3.1.1 Use the SELECT INTO syntax for variable initialization 3.1.2 Use DML in PL/SQL Block 3.1.3 Make use of sequence in a PL/SQL Block 4 Conditional Control: IF Statements 4.1 IF statement 4.1.1 Use IF-THEN statements 4.1.2 Use IF-THEN-ELSE statement 4.2 ELSIF Statement 4.3 Nested IF Statement

6 Iterative Control: Part 1 6.1 Simple Loops 6.1.1 Use Simple Loops with EXIT condition 6.1.2 Use Simple Loops with EXIT WHEN condition 6.2 WHILE Loop 6.3 Numeric FOR Loops 6.3.1 Use the Numeric FOR loops with IN option 6.3.2 Use the Numeric FOR loops with REVERSE Option

11 Introduction to Cursors 11.1 Cursor Manipulation 11.1.1 Make Use of Record Types 11.1.2 Process an Explicit Cursor 11.1.3 Make Use of Cursor Attributes 11.2 Using Cursor FOR loops and Nested Cursors 11.2.1 Use a Cursor FOR loop 11.2.2 Process Nested Cursors

12 Advanced Cursors 12.1 Using Parameters with Cursors. 12.2 FOR UPDATE and WHERE CURRENT cursors

13 Triggers 13.1 What are Triggers 13.1.1 Understand what a Trigger is 13.1.2 Use BEFORE and AFTER triggers 13.2 Type of Triggers 13.2.1 Use Row and Statement Triggers 13.2.2 Use INSTEAD of Triggers

About the Trainer

Having 16+ years of experience in design, development of various database applications using Oracle 12c/11g/10g/9i/8i/8.0 under Unix/Linux environment. Have excellent communication and presentation skills. Designed and developed participant guide(Course material) for JP Morgan&Chase Technology Division. Consultant Trainer to Oracle Hyderabad.

Student Feedback

4.0

Average Rating

89%

11%

0%

0%

0%

Reviews

T

Tushar Arora

Talking about Srinivasa I would not say one of the best trainers, but rather the best in the industry. The best part I have never seen him in hurry to finish the classes/course and he would go beyond his schedule to answer all your queries. Speaking about my personal experience, I only did SQL training but as per my job requirements I had queries regarding Development/DBA issues and not only a single time Srinivas Denied or even felt frustrated in answering my queries and on the top of that he offered me his personal Notes/PPT’s on that topic. The content of the course and the examples he provides is more than enough to make you understand about that particular topic. To wind up, taking professionally Srinivas has abundant knowledge on SQL/PLSQL and personally he is very polite and patient person.

S

Saud Qureshi

Srinivasa is very nice, courteous, and professional. He understand very well and is willing to help with whatever to help you succeed and make sure you understand. Definitely give him a chance and I am sure he won't disappoint you.

R

Ravi

I was very satisfied with his teaching skills. Srinivas has abundant knowledge on SQL/PLSQL. Classes are very interactive,really helpful in clarifying the doubts and uploading the respective class videos and documents. He is an expert in teaching concepts on PLSQL. I am grateful to attend his classes. Thank you very much Srinivas.

A

ASD

He has excellent command over the the subject and his classes includes brief examples on the topics and exercises. He is very patience in answering all the questions and if required he will go beyond your & his schedule to answer the questions and make you understand. He is not in hurry to finish his classes within schedule unlike other trainers who are quite a commercial these days. He personally care about the individual student, which is much appreciable.

H

Hussein

I was fortunate enough to be trained by Srinivasa on PL/SQL. I considered him to be a very talented, brave and a wise man. He knows the material and always on time. I'm an electrical engineer and had no software background but he was able to help me to understand the basics on Oracle software. He always provided videos and PDF documents of the lecture which is very helpful to understand the material. I absolutely recommend this instructor to anyone who needs help on this course. He deserved 5 star.

S

Swetha

Incredible Teaching,Sessions was very interactive, helped with lots of examples . Srinivasa has abundant knowledge on SQL/PLSQL. Classes are very interactive,really helpful in clarifying the doubts and uploading the respective class videos and documents. I strongly recommend him. He is an expert in teaching concepts on PLSQL from scratch to latest technologies.I am grateful to attend his classes. Thank you very much.

S

Swetha

Incredible Teaching,Sessions was very interactive, helped with lots of examples . Srinivasa has abundant knowledge on SQL/PLSQL. Classes are very interactive,really helpful in clarifying the doubts and uploading the respective class videos and documents. I strongly recommend him. He is an expert in teaching concepts on PLSQL from scratch to latest technologies.I am grateful to attend his classes. Thank you very much.

M

Manisha Adhikari

I was highly satisfied with the training, training materials and the way of teaching. I liked Srinivasa Sir as a very humbled, well experienced , motivate, guide in a proper way, giving more examples,assignments makes us more comfortable to ask questions freely, very patiently answer the questions even if i ask a some question for more than five times, he will not go for next topics until i understand about topics. I feel i was lucky to have such a wonderful trainer. I strongly commend everyone to join any of the above courses. I am always grate to you Srinivasa Sir. Thank You

M

Manisha Adhikari

I was highly satisfied with the training , training materials and the way of teaching. I like Srinivasa sir as a very humble, motivate, guide in a proper way, giving more examples,assignments,makes me more comfortable to ask questions freely,very patiently ,answer the questions even if i ask a same question for more than three times, he will not go for next unit or topic until i understands that unit. I feel I was lucky to have such a wonderful trainer. I strongly recommend everyone to join any of the above courses. I am always grate to you Srinivasa Sir. Thank You

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you.Read more