Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Introduction to Oracle PL/SQL

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 27582

Course type: Online Instructor led Course

Platform: Skype

Students Interested 0 (Seats Left 0)

No Reviews Yet

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

Date and Time

Not decided yet.

Students also enrolled in these Courses

About the Trainer

Shivangi Sharma picture

Avg Rating

Reviews

Students

Courses

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.

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now

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