UrbanPro
true

Introduction to Oracle PL/SQL

LIVE
1 review
Ongoing

Course offered by Shivangi Sharma

6 reviews
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

About the Trainer

Shivangi Sharma picture

5 Avg Rating

6 Reviews

8 Students

5 Courses

Shivangi Sharma

B.Tech from NIT having 7 yrs of IT experience

1 Years of 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.

Students also enrolled in these courses

LIVE
6 reviews

Course offered by Mahesh

1 review
LIVE
2 reviews

Course offered by Harsh vardhan Tiwari

76 reviews
LIVE

Course offered by Venkat

0 review

Reviews (1)

5 out of 5 1 review

Shivangi S. https://p.urbanpro.com/tv-prod/member/photo/705434-small.jpg Kundalahalli
5.0051
Shivangi S.
H

Introduction to Oracle PL/SQL

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

View All
Have you attended any class with Prashanth?

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

Different batches available for this Course

5 out of 5 1 review

Shivangi S. https://p.urbanpro.com/tv-prod/member/photo/705434-small.jpg Kundalahalli
5.0051
Shivangi S.
H

Introduction to Oracle PL/SQL

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

Have you attended any class with Prashanth?

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

Introduction to Oracle PL/SQL by Shivangi Sharma

Shivangi Sharma picture
LIVE
(1 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

Introduction to Oracle PL/SQL by Shivangi Sharma

Shivangi Sharma picture
LIVE
(1 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