 |
|
|
|
|
|
|
Classifieds: Education / Training | | Oracle PL/SQL Developer Training(Online) | | Posted By: Saber Vish at: 1, Aug 2012 0:07:29 AM IST | The IT Trainers are Online training providers. This course is specially designed for those looking to build an Oracle Development career.
http://theittrainers.com/it-courses/oracle-technologies/3-oracle-technologies/3-oracle-pl-sql-developer
Our PL/SQL Developer batch is starting August 9th 2012.
Batch size =6
Late Evening classes.
Demo class is free.
Placement services available on request.
Part time consulting service opportunities are welcome.
Contents
========
Section 1:
] Categories of SQL Statements
] Data Types
] Operators
] Basic Selects
] Single Row Functions
] Joins and Subqueries
] DMLs
] DDLs
] Examples
Section 2:
] Views
] Sequences
] Synonyms
Section 3: Code Tuning and optimization
] Query Tracing
] EXPLAIN PLAN
] INDEXES
] HINTS
] MATERIALIZED VIEWS
] PARTITIONS
] External Tables
] BULK COLLECT
Section 4:
] User Defined (Collection / Record )Types
] DBLINK
] User and Security
] Analytical Functions Overview
Section 5: Advanced Topics
] TESTING
] DATA DICTIONARY
] BIND VARIABLES
] Data Anomaly & Data Mapping
] Mutating Trigger Tables, PRAGMA_EXCEPTION_INIT & Autonomous Transactions
Section 6: UNIX and Tools
] SHELL SCRIPTING
] SQL*LOADER
] ORACLE DOWNLOADS
] ORACLE SUPPORT
] XML Overview
] Miscellaneous Knowledge.
Section 7 : PL/SQL Blocks
] IF..THEN..ELSIF..ELSE..END IF
] Loops
] Cursors
] Cursor Loops
Implicit and Explicit Cursors
Cursor Attributes (NOT FOUND, FOUND, ROWCOUNT)
] Advanced Datatype Declaration
%TYPE
%ROWTYPE
] Exceptions
System Defined
User Defined
Exception Scope
] Nested Blocks
] Variable (Local and Global) scope
Section 8 : Procedures & Functions
Procedures
] Create, Alter, Drop
] Invoking Procedures
Executing Procedure from a block
Executing procedure from command line
] Parameters
Syntax
Datatypes and Default Values
Types (IN, OUT, IN OUT)
Positional and Named notation
Functions
] Functions Vs Procedures
] Create, Alter and Drop
] Invoking Functions
] Executing Procedure from a block
] Executing procedure from command line
] Parameters
] Positional and Named notation
] RETURN
Seciton 9 : Packages
] Uses
] Create, Alter and Drop
] Referencing/Using Package objects
] Global Vs Local
Section 10 :
Triggers
] Create, Alter and Drop
] :old and :new
] Enable/Disable Triggers
] INSTEAD OF triggers
Difference between Oracle 9i and 10g and 11g
Section 11:
Miscellaneous
] Dynamic SQL
] UTL_FILE
] REF CURSORS
] Sending Email from PL/SQL
Section 12: Basic Overview
] BOXI (CMC, Infoview, Crystal Reports, Webi Reports)
] BODI/BODS ETL: Star Schema, ETL tool and methodology.
] Oracle Reports, Forms, Discoverer
] Erwin Data Modeler Overview.
] Oracle Apps (AP, AR, GL, etc)
] OAF, ADF, APEX, SOA, BPEL, ESB
] Pro * C |
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
