DataSoft Consultants Inc.

In IT We Trust. In IT We Serve.

Home

Services

Programs & Classes

Employment

Our Vision

Our Focus

Clients

FAQ

Contact Us

ORACLE Developer  

 

Introduction

 

Introduction to RDBMS - Evolution of RDBMS, DB Computing Architectures

 

Writing basic SQL Select statements – using   Where, Order by, distinct clauses

describing the SQL select capabilities, operators etc.

DML Data Manipulations languague

DDL Data Definition Language

 
 

Functions

 

Single Row Functions –

Character, Numeric,

Date,

Conversion

General Functions

 
 

Displaying Data from Multiple Tables using

  • Joins –
  • Equi,  Non-Equi, Outer, Inner, Self, Cross,
  • Left Outer,
  • Right Outer,
  • Full Outer Joins
  • Aggregating Data using Group Functions - Group By & Having clauses
  • Subqueries - Single-Row, Multiple-Row, Correlated Subqueries
 

Formatting output using SQL*Plus – column format, set command, spool and other SQL*Plus commands (save, insert, append, change)

 
 

Manipulating Data using DML

 

Creating and Managing Tables

 
Managing Constraints - Primary Key, Foreign Key, Unique, Not Null, Check
 
Database Objects - Creating Views, Sequences, Synonyms and Indexes
 

Controlling User Access by Grant & Revoke commands

 
 

PL/SQL Architecture

 
 
PL/SQL Architecture, Defining Variables, Anonymous Blocks
 
Control Structures,
 
Cursors
 
Procedures,
 
Functions,
 
Packages
 
Triggers
 
Business Analyst Training:
During the course, students will be

         Provided with instructor notes so that they would not need to buy any books. The notes are complied from several good books and would cover all the topics.

      Exposed to live documents ( real time Use Cases, Use Case Narratives, Use Case Diagrams, Activity Diagrams, State Chart Diagrams, Functional Requirements Document, Business Requirements Document, Software Requirement Specification)  so that they can get familiarized with the real time work situations. Moreover, a hands on experience will be provided to UML tools so that students can learn to create UML diagrams using the tools.

Detailed Course Outline

  • Role of a Business Analyst
  • Structure of Development Team
  • System Development Life Cycle (SDLC)
    • Requirement Gathering
    • Analysis and Design
    • Implementation
    • Testing
    • Deployment
  • Understanding the concept of Business Modeling
  • Importance of Requirement gathering.
  • Different Types of Requirements.
  • Requirement Gathering Techniques
  • JAD Session
  • Role of a BA in JAD Session
  • How to conduct JAD session?
  • Software Construction Methods
    • Waterfall Method
    • Rational Unified Process (RUP)
    • RAD methodology
    • Synchronize & Stabilize Methodology
    • Prototype Model
  • Comparison between Waterfall & RUP
  • Understanding Use Cases
  • Creating Use cases
  • Creating Use Case Narratives
  • Creating Functional Requirement Document
  • UML Methodology
    • Use Case Diagrams
    • Activity and Sequence Diagrams
    • Collaboration Diagrams
    • State Chart Diagrams
    • Class and Component Diagrams
    • Object Diagrams
    • Deployment Diagrams
  • Artifacts Delivered at Each Phase of RUP
  • Change Management & Version Control Using Rational Clear Case
  • Build Management
  • Requirement Gathering Tools
    • Rational Requisite Pro
    • Enterprise Architect
  • Business Modeling, Requirement Analysis & Designing Tools
    • Rational Rose
    • Enterprise Architect
    • MS Visio
  • Introduction to QA Methodology
    • Role of BA in Testing
    • Creating Test Plans
    • Creating Test Cases
    • Creating Test Scripts
  • Different Testing Methods
    • Functional and Regression testing
    • White Box and Black Box Testing
    • Positive and Negative Testing
    • GUI and Unit Testing
    • User Acceptance Testing
  • Review Session
  • Resume Preparation Help
  • Mock-up Interviews
 


 
Oracle DBA
Architecture
 

Defining an Oracle Database, Server, Instance. Understanding Physical Structure, Memory Structure, Process Structure, Logical Structure, Execution of SQL Statements, User Session
 

 
  Creating a New Database
 

Identifying the application and the No. of applications the DB wil support. Adv. of having each application on each DB. Adv. of having common DB for all Applications.

Understanding TS, Changing Initialization parameters - SGA size, Processes, TS Naming, Conventions, Block Sizes, Type of DB, No. of users the DB has to support etc.,
 

 
  Managing an Oracle Database
 

Creating and Managing Initialization files - PFILE and SPFILE, Adv. of SPFILE over PFILE

Identifying the various states/options of Instance Startup/Shutdown, DB Mount/Open states

Monitoring Alert and Trace Files in udump, bdump and cdump for DB Troubleshooting

Configuring System Global Area (SGA) - DB Buffer Cache, Log Buffer and Shared Pool

Understanding Background Processes - Mandatory/Optional and the jobs performed by them using the Data Dictionary to retrieve information about the database - V$, DBA_views
 

 
  Managing Tablespaces and Datafiles
 

Creating and Altering Tablespaces, adding, resizing, renaming and relocating a Datafile

Tablespace - offline, online, readonly, readwrite, temporary, Oracle9i's multiple blocks

Creating and Managing a Tablespace when using OMF and the advantages of OMF feature Extent Management - Dictionary Managed and locally Managed Tablespaces (autoallocate, uniform) and advantages of locally managed over dictionary managed tablespaces, Storage Management

Creating, Maintaining tables using appropriate storage settings - initial, minextents, pctfree etc.,

Obtaining table information like average row length, chained rows etc., after analyzing the tables Managing, Listing different types of Indexes and their uses, Creating B-Tree and Bitmap Indexes, Maintaining Indexes, Identifying unused Indexes, Obtaining Index Information.
 

 
  Managing Rollback and Undo Segments
 

Creating and Maintaining Rollback Segments, Optimal Parameter, Online/Offline, Pending Offline, Deferred Rollback Segments, Snapshot too old scenario

Understanding Oracle9i's Undo Segments, Retention Policy, Switching Undo Tablespaces
 

 
  Networking Overview
 

Explaining solutions included with Oracle 9i for managing complex networks

Oracle Net Architecture - Explaining the key components, Role in Client/Server connections

Oracle Net Services Server-Side Configuration, Oracle Net Services Client-Side Configuration

Configuring and Maintaining Distributed DBs by creating DB Links, Materialized Views

Usage and Configuration of Oracle Shared Server, Components of the Oracle Shared Server, Configuring Shared Servers and Dispatchers, Identifying Useful Data Dictionary Views
 

 
  Maintaining the Control File and Redo Log File
 

Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File

Purpose of and how online redo log files work with their associated Background Processes

Controlling log switches and Checkpoints, Multiplexing and Archiving Online Redo Log Files
 

 
  Backup and Recovery
 

Describing the basics of DB Backup, Restore and Recovery, Listing the types of Failures that may occur in an Oracle Environment, Defining Backup and Recovery Strategies

Instance and Media Recovery Structures – Describing the Oracle Processes, Memory Structures and Files related to Recovery, Identifying the importance of Checkpoints, Redo Log Files and Archived Log Files, Describing the ways to tune Instance Recovery

User Managed Backups and Recoveries – Backup and Recovery Operations, Closed and Open DB Backups (Hot and Cold), Complete Recovery, Identifying the situations which require Incomplete Recovery, Recovery from loss of Online Redo Logs, Creating Clone DBs

Oracle Recovery Manager (RMAN) – Features and Components, Repository, Channel Allocation, Configuring RMAN Environment, Backup Commands and Scripts for Backupsets, image copies, Complete and Incomplete Recovery and Full/Incremental

Transporting Data between DBs using Export, Import, SQL*Loader, Transportable Tablespaces
 

 
  Availability
 

Dataguard - offers maximum protection/performance, centralizing and simplifying management, safeguarding against physical corruptions, provides Fail Over and Switch Over

Logminer - Read and Analyze contents of Redo Log Files, obtain information about DML activities on Standard Tables, provides a means of auditing actions to either specific tables or by users
 

 
  Oracle 9i New Features
 

Memory Management (Dynamic SGA, etc)

Multiple Block Size at TS Level

Automatic Segment Space Management

M View Refresh with Query Re-Write

Oracle Managed Files (OMF)

Resumable Space Allocation

Oracle9i Flashback Query

List Partitioning / Data Guard
 

 
  Performance Tuning
 

Overview of Tuning Phases, Goals, Methodology and Common Performance problems

Tuning O/S, Virtual and Physical Memory, Paging and Swapping, CPU Tuning guidelines

DB Conf. and I/O Issues, File Striping, Optimize/Tuning Sorting Operations, Diagnosing and Tuning Latch and Lock Contention, Partitioning, Redo Log File Configuration

Enabling Oracle’s Parallel Query Option, Multiple DB Writers, Log Writers, Table Caching

Sizing of SGA – Shared Pool (Reuse Stmts., etc.), Buffer Cache, Redo Log Buffer Cache

Tuning Rollback/Undo Segments – Usage, Configuration, Detecting and Resolving problems

Diagnostic and Tuning Tools – Alert Log File, Trace Files, TKPROF, Explain Plan, Dynamic Performance Views, TIMED_STATISTICS parameter to collect statistics, STATSPACK

Application Tuning – SQL Tuning, Optimizer Modes, Plan Stability, Hints, Detecting and Resolving Row Chaining and Migration, Indexes, Data Storage Structures
 

 
  Oracle Enterprise Manager (OEM)
 

Creating OEM Repository, Configuring OEM with Oracle Intelligent Agent and Management Server.

Creating DB Objects (Tablespaces, Rollback Segments, etc., Performing various DBA operations (DB Backup, RMAN Backup), Scheduling Jobs, Events and Event-Notification
 

 
  Oracle Advanced Replication
 

Configuring Master Sites and Materialized View Sites for Multimaster Replication And Materialized View Replication using Oracle Replication Management Tool
 

 
  Oracle Installation
 

Oracle 9i on Linux 9 and Win2K, Oracle 8i on Sun Sparc with Solaris 8 (SUN SPARC)
 

 
  Oracle 10g New Features
 

Automatic Storage Management (ASM)

Oracle Data Pump

Automatic Shared Memory Management using AWR, ASH & ADDM.

Transportable Tablespaces across platforms

Enhanced Flashback features