Oracle PL SQL Online Training and Placement

  Oracle PL SQL Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Oracle E-Business Suite Online Training PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course
More    


Oracle PL SQL Online Training 

Oracle PL SQL Course Content:

SQL

1.The Oracle database environment
2.Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g

Basic SELECT Statement
1.Writing the statement in sqlplus, Running the SELECT statement

Ordering the output
 1.Single Column, Descending order, Multiple column sort

Conditional retrieval of data
1.Working with complex conditions, AND OR NOT LIKE BETWEEN

 Pseudo columns and functions
1.Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table

Working with character functions
• 1.UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(),

Working with date functions
1.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function
1.ROUND(), TRUNC(), SIGN(), Working with multiple tables,
2.Different type of Joins, Writing Outer Joins

Using the SET operators
1.Union, Intersect, Minus

Aggregating data using group functions
1.GROUP BY, HAVING

Creating Subqueries
1.Single Row subqueries, Multiple row Subqueries

Enhancing groups function
1.ROLLUP, CUBE

Transaction Control Language
1.Rollback, Commit, Savepoint

Processing hierarchies
1.Creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language
1.INSERT, UPDATE, DELETE

Data Definition Language
1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints
1.Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References 

Constraint, On Delete Cascade, On Delete Set Null

Other Database Objects
1.Views, Sequences, Synonyms, Indexes
2.USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS

Database Security
1.Object Privileges, Granting access to objects

PL -SQL

Blocks
1.Structure, Writing Anoyomous Blocks

Variables
1.Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments

Control structures
1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors
1.Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

Error Handling
1.Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions

 Procedures
1.Creating and Calling Procedures

 Functions
1.Creating and Calling Functions

Packages
1.Package Header, Package Body

Design Tips and Techniques
1.Format of standard packages in an application, Spec and Body, NOCOPY hint theory

Triggers
1.Database triggers, CALLing procedures from triggers

Dynamic SQL
1.EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages
1.DBMS_OUTPUT, UTL_FILE

Collection datatypes
1.Associative Arrays, Nested tables, VARRAYs



Signup


Name: 

Phone No: 

Email:  

Password: 

Need Resume Preparation:     

 
Select Skills:
select skills and click ok to confirm
 
Select Sub Skills:    
select sub skills and click ok to confirm

Available Time:     (hold Ctrl to select multiple)

Register Now!

Free Demo Class
Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.






Which course is right for me?


Speak to an IT online learning consultant today


on 844-OPTGHAR for FREE Tailored Advice.

get free advice
course