"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

Date and Time

Not decided yet.

Rajesh

MTech

About Rajesh

More than 10 years experience into teaching field
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Corporate Training 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