UrbanPro
true

PL/SQL

LIVE
8 reviews
Ongoing

Course offered by Srinivasa C Thirunagari

31 reviews
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.

Topics Covered

CONTENTS 1 PL/SQL Concepts. 1.1 PL/SQL Client Server Architecture 1.1.1 Use PL/SQL Anonymous Blocks 1.1.2 Understand How PL/SQL gets executed. 1.2 PL/SQL in SQL*Plus 1.2.1 Use Substitution Variables 1.2.2 Use DBMS_OUTPUT.PUT_LINE statement 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 5 Conditional Control: CASE Statements 5.1 CASE statement 5.1.1 Use the CASE statement 5.1.2 Use Searched CASE statement 5.2 CASE Expression 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 7 Iterative Control: Part 2 7.1 The Continue Statement 7.1.1 Use the CONTINUE statement 7.1.2 Use the CONTINUE WHEN condition 7.1.3 Nested Loops 8 Error Handling and Built-In Exceptions 8.1 Handling Errors 8.1.1 Understand the importance of Error Handling 8.2 Built-in Exception 9 Exceptions 9.1 Exception Scope 9.2 User defined Exception 9.3 Exception Propagation 9.3.1 Understand How exception Propagate 9.3.2 Re-raise Exception. 10 Exceptions: Advanced Concepts 10.1 RAISE_APPLICATION_ERROR 10.2 EXCEPTION_INIT Pragma 10.3 SQLCODE and SQLERRM 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 14 Compound Triggers 14.1 Mutating Table Issue 14.2 Compound Trigger 15 Collections. 15.1 PL/SQL Tables 15.1.1 Use Associative Array 15.1.2 Use Nested Tables 15.2 Varray 16 Records 16.1 Record Types 16.1.1 Use Table-Based and Cursor-Based records 16.1.2 Use User-Defined Records 16.2 Nested Records 16.3 Collection Records 17 Native Dynamic SQL 17.1 EXECUTE IMMEDIATE Statement 17.2 OPEN-FOR, FETCH and CLOSE statements 18 Procedures 18.1 Creating Procedures 18.1.1 Create Procedures 18.1.2 Query the Data Dictionary for information on Procedures 18.2 Passing parameters into and out of Procedures 19 Functions 19.1 Creating and Using Functions 19.1.1 Create Stored Functions 19.1.2 Make use of Functions 19.1.3 Invoke Functions in SQL statements 20 Packages 20.1 The Benefits of Using Packages 20.1.1 Create Package Specification 20.1.2 Create Package Bodies 20.1.3 Call Stored Packages 20.1.4 Create Package Variables and Cursors

Who should attend

Fresh grads, Application developers, designers, DBA's and end users should attend this course.

Pre-requisites

Should have the knowledge of SQL.

What you need to bring

Laptop with Internet connection.

Key Takeaways

Student/participant would be able to understand the different block structures. Create Stored procedures, stored functions,packages Create database triggers Use Oracle-supplied packages.

Gallery (1)

About the Trainer

4.8 Avg Rating

31 Reviews

46 Students

6 Courses

Srinivasa C Thirunagari

Master of Engineering (Systems & Information)

20 Years of Experience

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.

Students also enrolled in these courses

LIVE
14 reviews
1 Hours
10,000 Group Class (max 5)
20,000 1-on-1 Class

Course offered by Anupam Thakur

23 reviews
LIVE
27 reviews

Course offered by Surya Narayana Reddy

14 reviews
LIVE

Course offered by Oracle Primavera Trainer Profile

25 reviews
LIVE
6 reviews

Course offered by Mahesh

1 review

Reviews (8)

4 out of 5 8 reviews

Raam Infotech https://www.urbanpro.com/assets/new-ui/institute-100X100.png Vanasthalipuram
4.8058
Raam Infotech
T

PL/SQL

"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. "

Raam Infotech
S

PL/SQL

"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. "

Raam Infotech
A

PL/SQL

"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. "

Raam Infotech
H

PL/SQL

"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. "

View All
Have you attended any class with Mahesh?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

4 out of 5 8 reviews

Raam Infotech https://www.urbanpro.com/assets/new-ui/institute-100X100.png Vanasthalipuram
4.8058
Raam Infotech
T

PL/SQL

"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. "

Raam Infotech
S

PL/SQL

"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. "

Raam Infotech
A

PL/SQL

"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. "

Raam Infotech
H

PL/SQL

"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. "

Raam Infotech
S

PL/SQL

"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. "

Raam Infotech
S

PL/SQL

"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. "

Raam Infotech
M

PL/SQL

"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 "

Raam Infotech
M

PL/SQL

"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 "

Have you attended any class with Mahesh?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

PL/SQL by Srinivasa C Thirunagari

Srinivasa C Thirunagari picture
LIVE
(8 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

PL/SQL by Srinivasa C Thirunagari

Srinivasa C Thirunagari picture
LIVE
(8 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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