loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for ORACLE SQL/PLSQL Training in Bangalore

Please enter valid question or comment

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 Xchangetechslearning

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

course photo

ORACLE SQL/PLSQL Training in Bangalore

Koramangala 6th Block, Bangalore

8,000

No Reviews Yet
0 Interested

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:
SQL
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. www.XchangeTechsLearning.in
Phone: +91 8792118724/08065471669
PL/SQL
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

Pre-requisites

Good Knowledge on Database

What you need to bring

Pen, Laptop and Book

Key Takeaways

Gain some knowledge and experience on SQL/PLSQL
Reviews
There are no Reviews yet. Be the First to Review
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


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Rajesh

MTech


More than 10 years experience into teaching field
Seats Left-

Students Interested 0

Course Id: 18330