Training in ORACLE 11i SQL & PL/SQL

I-PAD Technologies Promises the future of education in Information Technology by dedicating it self towards sharpening your technical and soft skills to improve your chances in this competitive world. Silent Features are...

Ø I-PAD Technologies assures robust, practical and industry-worth guidance and training to the student.

Ø I-PAD Technologies offers the student community a complete exposure to all application/firmware development activities carried at our offshore research center

Ø Faculties with rich teaching experience and considerable practical experience will be involved in the training program.

Ø The required infrastructure for conducting the program will be available in totally.

Ø It is assured that the program will be conducted, strictly based on agreed curriculum and time schedules with the at most professionalism.

Ø Heavy emphasis will be laid on practical issues to make the students worthy of the industry at the conclusion of the training program.

Ø Communication skills and Confidence building will be an integral part of the program.


OUR EXPERTISE

We are proud to be the pioneers in "Hardware and Networking". Just when everyone was bent upon Software, we foresaw the tremendous potential in Hardware and Networking, and successfully emerged as one of the best IT Company for Hardware and Networking Solutions and the best institute for Hardware and Networking Training. Today the two sides of its business are equally balanced. The expertise of its training is coupled with a strong commitment to provide the best Hardware and Networking solutions. This has put I-PAD Technologies in the unique position of deriving synergies between Network Solutions and IT Training. At I-PAD Technologies, we have versatile, highly qualified and certified Hardware and Networking Engineers with varied academic backgrounds and is headed by Mr.Srinivasa Rao.K. The teaching staff are in the field with the complete understanding of the IT industry, its prospects and are provident enough to see to it that you are equipped with the latest knowledge in the ever changing world of IT industry. After extensive learning, we subject our students to some Real Time situations (which is often created by our staff) and student left alone, to handle the situation, to overcome the problem, with his own solutions. In this way, he is getting experienced, even before the completion of course and is very much ready to seek the job with tremendous confidence.

In keeping view of the student's requirements, the I-PAD Technologies are providing 24-hour lab facility. The lab is also open on all Sundays / Holidays Our labs are enormous and equipped with the latest systems available in the industry today. We also have product maintenance engineers who see to it that our systems are fully functional at all times. We have a good library, shelving books with latest versions and editions covering various topics on Real Time situations and Trouble shooting, etc.




Part I. Programming in PL/SQL

1. Introduction to PL/SQL
What Is PL/SQL?
The Origins of PL/SQL
So This Is PL/SQL
About PL/SQL Versions
Resources for PL/SQL Developers
Some Words of Advice

2. Creating and Running PL/SQL Code
SQL*Plus
Performing Essential PL/SQL Tasks
Oracle's PL/SQL-Based Developer Tools
Calling PL/SQL from Other Languages
And What Else?

3. Language Fundamentals
PL/SQL Block Structure
The PL/SQL Character Set
Identifiers
Literals
The Semicolon Delimiter
Comments
The PRAGMA Keyword
Labels

Part II. PL/SQL Program Structure

4. Conditional and Sequential Control
IF Statements
CASE Statements
The GOTO Statement
The NULL Statement

5. Iterative Processing with Loops
Loop Basics
The Simple Loop
The WHILE Loop
The Numeric FOR Loop
The Cursor FOR Loop
Loop Labels
Tips for Iterative Processing

6. Exception Handlers
How PL/SQL Deals with Errors
Defining Exceptions
Raising Exceptions
Handling Exceptions

Part III. PL/SQL Program Data

7. Working with Program Data
Naming Your Program Data
Overview of PL/SQL Datatypes
Declaring Program Data
Programmer-Defined Subtypes
Conversion Between Datatypes

8. Strings
The Impact of Character Sets
String Datatypes
String Issues
String Functions
NLS Functions

9. Numbers
Numeric Datatypes
Number Conversions
Numeric Functions

10. Dates and Timestamps
Date and Time Datatypes
Date and Timestamp Conversions
Date/Time Arithmetic
Date/Time Functions

11. Records and Collections
Records in PL/SQL
Collections in PL/SQL
Declaring Collection Types and Collections
Where Collections Can Be Used
Collection Built-Ins (Methods)
Working with Collections
Collection Pseudo-Functions
Maintaining Collections
Choosing a Collection Type

12. Miscellaneous Datatypes
The BOOLEAN Datatype
The RAW Datatype
The UROWID and ROWID Datatypes
The LOB Datatypes
Working with LOBs
Predefined Object Types

Part IV. SQL in PL/SQL

13. DML and Transaction Management
DML in PL/SQL
Bulk DML with the FORALL Statement
Transaction Management
Autonomous Transactions

14. Data Retrieval
Cursor Basics
Working with Implicit Cursors
Working with Explicit Cursors
BULK COLLECT
SELECT...FOR UPDATE
Cursor Variables
Cursor Expressions (Oracle9i)

15. Dynamic SQL and Dynamic PL/SQL
NDS Statements
Multirow Queries with Cursor Variables
Binding Variables
Working with Objects and Collections
Building Applications with NDS
NDS Utility Package
Comparing NDS and DBMS_SQL

Part V. PL/SQL Application Construction

16. Procedures, Functions, and Parameters
Modular Code
Procedures
Functions
Parameters
Local Modules
Module Overloading
Forward Declarations
Advanced Topics
Go Forth and Modularize!

17. Packages
Why Packages?
Rules for Building Packages
Rules for Calling Packaged Elements
Working with Package Data
When to Use Packages
Packages and Object Types

18. Triggers
DML Triggers
DDL Triggers
Database Event Triggers
INSTEAD OF Triggers
AFTER SUSPEND Triggers
Maintaining Triggers

19. Managing PL/SQL Applications
Managing and Analyzing Code in the Database
Protecting Stored Code
Using Native Compilation
Testing PL/SQL Programs
Debugging PL/SQL Programs
Tuning PL/SQL Programs
Improving Application Performance

Part VI. Advanced PL/SQL Topics

20. PL/SQL's Runtime Architecture
Looking Under the Hood
Dependency Management
PL/SQL's Use of Memory in the Oracle Server
The Processing of Server-Side PL/SQL
PL/SQL Code on the Client
Execution Authority Models
Hardware for PL/SQL: Bigger = Better?
What You Need to Know

21. Object-Oriented Aspects of PL/SQL
Introduction to Oracle's Object Features
An Extended Example
Object Views
Maintaining Object Types and Object Views
Pontifications

22. Calling Java from PL/SQL
Oracle and Java
Getting Ready to Use Java in Oracle
A Simple Demonstration