Signup as a Tutor

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

"ORACLE SQL/PLSQL Training in Bangalore" is no longer available

No Reviews Yet

Koramangala 6th Block, Bangalore

Course ID: 18330

Koramangala 6th Block, Bangalore

No Reviews Yet

About the Course

SQL/PLSQL is a good database technology in the IT Market

Topics Covered

Course Title : Oracle PL/SQL
Duration : 4 weeks / Approx. 45 hours of training
Course Content:
1) Introduction to SQL
o DDL commands
o DML commands
o DCL commands
o TCL Commands
o Data types in oracle
o Detail understanding on Select statement
2) Restricting and Sorting Data
o Where clause
o Between, In and Like operators
o And, OR and Not operators
o Order by clause
o Defining and Assigning values to variables
3) Single Row functions
o Character Manipulation functions
o Case conversion functions
o Number functions
o Date functions
o Round and Trunc with date functions
4) Conversion Functions
o Data type conversion
o To_char, to_date and to_number functions
o Replacing null values (NVL2), Decode function
o Conditional expressions ( Case)
5) Group functions
o Group by clause
o Sum, Avg, Min and Max functions
o Group by clause on multiple columns
o Restricting group results ( Having)
6) Oracle Joins
o Type of joins
o Join using On and Using clauses
o Natural, self and equi joins
o Outer joins (left, right and full)
o Cross join ( Cartesian product)
7) Sub queries
o Types of sub-queries
o Single and multiple row sub-queries
o Group functions on sub-queries
o Using All and Any operators
8) Set operators
o Union and union-all operators
o Intersect and minus operators
o Order by clause in set operators
9) More on DML statements and Data integrity
o Inserting data from other table
o Conditional insert (Merge)
o Select for update statement
o Delete vs truncate
o Data integrity (Commit & Rollback)
10) More on DDL and Constraints
o Creating tables and inserting default values
o Primary and foreign key constraints
o Unique and check constraints
o Adding and dropping columns from a table
11) Creating other Schema objects
o Simple and Complex views
o B-tree and Bitmap indexes
o Working with sequences
o Creating synonyms
12) Controlling User Access
o Creating users
o Granting system & object privileges
o Granting and revoking privileges to and from a role
13) Managing other Schema Objects
o Setting and Dropping UNUSED columns
o Deleting data from Child Tables (on Delete)
o Disable & Enable constraints
o Drop Table…Purge
o Flashback Table
o Temporary Table
o External Table
14) Miscellaneous
o Multi Table Insert
o Merge statement in detail
o Flashback Versions Query
o Interval data types
o Exists & not exists operators
o With Clause
o Rollup and Cube operators
113, 6th Cross, Koramangala Club Road, 6th Block, Koramangala, Bangalore – 95.
Phone: +91 8792118724/08065471669
Basics of PL/SQL
• PL/SQL architecture
• PL/SQL and SQL*Plus
• PL/SQL Basics, Variables, Constants, data types & error handling
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
• Defining exceptions
• Using the when others clause
• Ensuring complete error checking
• Passing error messages to calling routine
Boolean logic in PL/SQL
• Identifying the Uses and Types of Control Structures
• Constructing an IF Statement
• Constructing and Identifying Different Loop Statements
• Controlling Block Flow Using Nested Loops and Labels
• Using Logic Tables
• If-then-else structure
• Testing for numbers characters and Booleans
Cursors in PL/SQL
• Cursor basics
• Using a cursor for a multi-row SQL query
Iteration in PL/SQL
• For loop
• While loop
PL/SQL tables
• Defining PL/SQL tables
• Reasons to use PL/SQL tables
• Populating a PL/SQL table
• Retrieving from a PL/SQL table
Triggers in PL/SQL
• Triggers and database events
• Defining a trigger
• Timing a trigger
• Enabling and disabling a trigger
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
• Package forward declaration
• Package dependency
• Package overloading
Bulking in PL/SQL
• Bulk queries
• Bulk DML (for all statement)
• Using cursor attributes
• Analyzing impact of bulk operations

Who should attend

All IT and Non IT Employees can attend for this Training


Good Knowledge on Database

What you need to bring

Pen, Laptop and Book

Key Takeaways

Gain some knowledge and experience on SQL/PLSQL

Date and Time

Not decided yet.

About the Trainer

Avg Rating






More than 10 years experience into teaching field


No reviews currently Be the First to Review


Post your requirement and let us connect you with best possible matches for Corporate Training Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, 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 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