loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for PL/SQL

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Srinivasa Thirunagari

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

PL/SQL

PL/SQL

Online Instructor led Course

Platform: Gotomeeting

15,000

7 Reviews
1 Interested

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.

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.

Reviews

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

attended PL/SQL


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

attended PL/SQL


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

attended PL/SQL


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

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

attended PL/SQL


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

attended PL/SQL


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

attended PL/SQL


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

attended PL/SQL


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

attended PL/SQL


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 "

attended PL/SQL


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 "

attended PL/SQL


Date and Time

Not decided yet.

About the Trainer

Srinivasa C Thirunagari

Master of Engineering (Systems & Information)


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.
Seats Left-

Students Interested 1

Course Id: 28536