loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Introduction to Oracle PL/SQL

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Shivangi

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

Introduction to Oracle PL/SQL

Introduction to Oracle PL/SQL

Online Instructor led Course

Platform: Skype

6,000

1 Reviews
0 Interested

About the Course


This tutorial is designed for Software Professionals/students, who are willing to learn PL/SQL Programming Language in simple and
easy steps. This course will give you great understanding on PL/SQL Programming concepts, and after completing this
course, you will be at intermediate level of expertise from where you can take yourself to higher level of expertise.

Topics Covered

1.Basics of PL/SQL
PL/SQL architecture
PL/SQL and SQL*Plus
PL/SQL Basics, Variables, Constants, data types & error handling
PL/SQL wrapper utility
2.PL/SQL structures
Simple blocks
Control structures
PL/SQL records
Recognizing the Basic PL/SQL Block and Its Sections
Describing the Significance of Variables in PL/SQL
Distinguishing Between PL/SQL and Non-PL/SQL Variables
Declaring Variables and Constants
Executing a PL/SQL Block
3.Stored procedures, functions and packages
Basics of stored procedures
Basics of functions
Basics of packages
Defining stored procedures & functions
Function and stored procedures prototypes
Passing arguments to functions and stored procedures
Recompiling functions and stored procedures
Pinning packages in the SGA with dbms_shared_pool.keep
Package forward declaration
Package dependency
Package overloading
Listing package information
4.Error checking – exception handling
Defining exceptions
Using the when others clause
Ensuring complete error checking
Passing error messages to calling routine
Boolean logic in PL/SQL
5.Control Structures
Constructing an IF Statement
Constructing and Identifying Different Loop Statements
Controlling Block Flow Using Nested Loops and Labels
If-then-else structure
Testing for numbers characters and Booleans
For loop
While loop
6.Nested blocks in PL/SQL
Creating nested blocks
Understanding scope in nested blocks
7.Cursors in PL/SQL
Cursor basics
Using a cursor for a multi-row SQL query
8.Triggers in PL/SQL
Triggers and database events
Defining a trigger
Timing a trigger
Enabling and disabling a trigger
9.Dynamic SQL in PL/SQL
Introduction to the dbms_sql package
Creating a dynamic SQL statement
10.PL/SQL tables:
Defining PL/SQL tables
Reasons to use PL/SQL tables
Populating a PL/SQL table
Retrieving from a PL/SQL table
11.Bulking in PL/SQL:
Bulk queries
Bulk DML (forall statement)
Using cursor attributes
Analyzing impact of bulk operations

Who should attend

-Students willing to upgrade their skill set.
-Developers
-DBA's

Pre-requisites

Basic understanding of database concepts and SQL.

What you need to bring

Inclination to learn new concepts."

Key Takeaways

Write a PL/SQL block using all elements of block structure.
Write PL/SQL statements using lexical units, declared variables, and assignment statements.
Use control structures to loop, branch, and jump.
Use PL/SQL named exceptions and user-defined exceptions.
Use explicit cursors,triggers,packages,procedures,functions
Bulk Processing
Reviews

Recommendations & reviews from previous Customers:

Harshita

"I am working in an MNC and needed to learn PL/SQL basics. Shivangi has taught all basic concepts with project based scenarios and helped me in my work as well. She has provided proper guidance for OCA preparation. "

attended Introduction to Oracle 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:

Harshita

"I am working in an MNC and needed to learn PL/SQL basics. Shivangi has taught all basic concepts with project based scenarios and helped me in my work as well. She has provided proper guidance for OCA preparation. "

attended Introduction to Oracle PL/SQL


Date and Time

Not decided yet.

About the Trainer

Shivangi Sharma picture

Shivangi Sharma

B.Tech from NIT having 7 yrs of IT experience


I have more than 7 years of IT experience on UNIX and Oracle SQL and PL/SQL programming. I have been teaching UNIX and Oracle for past one year as a full time trainer.
Seats Left-

Students Interested 0

Course Id: 27582