Training          Order SOA Suite

Order SOA Suite


Prerequisties

Basics in Computer Science
Good Problem Solving Skills

Target Job Roles

Oracle Data Modeller
Oracle DataBase Developer

Target Proffesional Accrediations

Oracle Certified Associate (9i, 10g, 11g)
Oracle PL/SQL Developer Certified Associate
Oracle Database SQL Certified Expert

Format

Classroom
Online(Web & Audio Conference)
On-Site at your facility**
  

Course Outline

Module 1:FUNDAMENTALS OF DATABASE, DATA MODELING, UNIX AND BEGINNING ORACLE

This module starts with basic concepts of database, data modeling and walks you through the fundamentals of Oracle database.

Duration :  8 Hours
Hands On :
Project on Database Normalization
Hands on Oracle Installation, Users and Roles management
Exercise on SQL*PLUS Commands
Project using TOAD Data Modeler

Module 2:ORACLE OBJECTS, SQL, SQL TUNING BEST PRACTICES

This module starts with fundamentals of Database Objects and talks deeper into Oracle SQL and SQL Tuning.

Duration :  10 Hours
Hands On :
Comprehensive exercise on SQL & Database Objects
Hands on SQL Tuning

Module 3:PLSQL, SQL*LOADER, EXTERNAL TABLES

This module covers deeper into PLSQL, SQL*Loader and external tables.

Duration :  11 Hours
Hands On :
Comprehensive exercise in PLSQL
Full cycle project using SQL*Loader, External Tables & PLSQL (ETL Application)

Module 4:XML PROCESSING, HTTP ACCESS, CONSUMING WEB SERVICES

This module discusses about XML Processing in ORACLE, HTTP Access and webservices.

Duration :  4 Hours
Hands On :
Comprehensive exercise in XML Parsing


Training        Order SOA Suite

Back to Training Home!