COURSES OFFERED
 
 
UNIX Duration : 2 Weeks
  Pre Requisite : Fundamentals of Computers
 
Introduction to UNIX OS Origin, History, Versions, Features.
Structure of UNIX Commands - Architecture, File System, Logging In
Working with UNIX Commands - Password, Directory, File etc.
File Access Permissions - chmod (absolute, symbolic), umask
Wildcard Characters and Redirections - (*,?,[]), (stdin, stdout, stderr)
Editors-vi (advance) - 3 modes: escape, insert, coion
Simple Filters - displaying lines, word count, translate characters, sort lines, etc.
Searching files using find command by using various options
Communication Tools - using write, mesg, talk, mail and wall commands
Linking Files using hard and soft (symbolic links)
Advanced Filters - pattern matching, filtering text files, field processing
Shell Scripting
Process Scheduling - background processes, killing a process
 
ORACLE Duration : 2 Weeks
  Pre Requisite : Basic Programming Skills
 
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.
Single Row Functions - Character, Numeric, Date, Conversion and 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, Defining Variables, Anonymous Blocks
Control Structures, Cursors, Procedures, Functions, Packages and Triggers
 
UNIX ADMINISTRATION Duration : 6 Weeks
 
Solaris 9 on SUN SPARC
AIX on IBM RS/6000
HP-UX on HP9000
Red Hat Linux 9.0
  Pre Requisite : Unix & Win2000 Hardware Concepts
 
  Hardware Infrastructure
SUN Enterprise 250 Server
SUN Ultra
HP-9000 (HP-J5000, HP-B2000)
SAN – Vixel 2100 FC Hub, Atto 2200 Bridge, JNI FCHBA
Network Print
Thin Clients
Dumb Terminals
SUN Store Edge L9 Autoloader DLT Tape Library
IBM RS/6000 43P Model 150
HP SCSI Tape Drive
NAS – Quantum Snap Server
Server SCSI Disk Array
Terminal Server
   
 
  Installation
Installing Solaris 9 on SUN SPARC, Intel using Webstart, Interactive & Custom Jumpstart
Package Administration - pkgadd, pkgrm, pkginfo, pkgchk, pkgrm commands
 
  File System
Understanding different file systems like ufs, pcfs, hsfs, udfs and lofs
Create a new file system using newfs command and Monitoring using mount command
Maintenance - checking consistency with fsck, monitoring disk usage with df, du
 
  Startup and Shutdown
The Boot Process - PROM, Boot Program, Kernel and Init phases
Understanding and Customizing the different Run Levels - shutdown, init 0, etc.
Run Control Scripts - Adding and Modifying Run Control Scripts
 
  Accounts Management
Creating, Modifying and Deleting Groups and Users using CLI and GUI (Admin Tool)
Modifying the Initialization files to customize a user's work environment
Assigning Administrator Roles to Users using Role Based Access Control (RBAC)
Implementing Disk Quotas for users at FS Level - with soft and hard limits
 
  Networking
Configuring Solaris in the networked mode with IP Address, Subnet, DHCP
Working with TCP/IP applications like ping, telnet, ftp, rlogin, rcp, rsh and rup
Implementing trust relationship at user and server levels
Understanding and Implementing Dynamic Host Configuration Protocol (DHCP)
Establishing a PPP link between Solaris and Windows using SLIP
Installing Cute-FTP, X-Windows Emulation Software (Reflections) on Windows Client
 
  Networking File Systems
Setting Up NFS Server and NFS Client - configuration files, daemons, sharing, mounting file system and Troubleshooting - shareall, nfsstat, dfsstab
Implementing Auto-mount with NFS - advantages, automount maps
Configuring Cache File System over NFS- collect statistics, perform consistency checks
Installing PC-NFS - Sharing and Accessing Resources from Unix to Windows
 
  Fault Tolerance
Exploring diff. I/O Technologies, understanding different RAID Levels(0,1 and 5)
Implementing RAID Levels using Hardware (PCI SCSI RAID Controller) and Software(Veritas Volume Manager and SUN's Solstice Disk Suite) at O/S Level
 
  Backup and Recovery
Understanding various Backup Strategies, Configuring SCSI DAT/DLT Tape Drives
Working with tar, cpio, pax, jar, dd, ufsdump and ufsrestore - Generic/Platform Specific
Performing Local/Remote Backup and Restore, Performing full/incremental Backups
 
  Naming Services
Understanding Domain Name Service(DNS)- Domains, Root Domain, Domain Tree
Setting Up DNS for Solaris and WinNT - Pri./Sec. and Sub-Domain Servers/Clients
Exploring NIS Environment - Diff. between NIS and NIS+, Domains, Directory Objects
Configuring NIS+ - Master/Replica Servers and Configuring NIS+ Clients
 
  Printers
Configuring Local, Remote and Network Printers - lpsched, lpadmin, lpstat, lpshut
 
  Installation of 3rd Party Software
Web Servers - Installing and Configuring Apache, iPlanet Web Server
File Servers - Implementing SAMBA for accessing shared resources for Windows
 
  Performance Tuning
Hardware Analysis (CPU/Memory)
Operating System Tuning
Kernel Tunable Parameters
I/O Tuning at File System level
Application Tuning
Different Perf. Monitoring tools
 

ADVANCED UNIX ADMINISTRATION
Installing Solaris Management Console - A GUI Based System Administration Tool
Managing SYSLOG messages - Exploring different facilities & error messages
Implementing TCP/IP wrappers and Configuring Anonymous FTP Server
Installing WEBMIN - Web Based Admin. Tool for Solaris on SUN Enterprise 250 Server
Mail Server Configuration using Sendmail (SMTP) and Fetchmail (POP3) over the Internet
Secure Shell (SSH)
 
  Storage Technologies
Direct Attached Storage - (DAS) Storage attached directly to the Server - SCSI/EIDE
Network Attached Storage - (NAS)Platform Independent IP Based Storage unit on the LAN
Storage Area Network - (SAN)Storage units attached to Fibre-Channel Network
 
  Veritas
Exploring Veritas Volume Manager, Implementing VxFS and RAID Levels using VxVM
Veritas Clusters on SUN Nodes over SAN(shared I/O) with Fail-Over for High-Availability
Veritas NetBackup on SUN L9 Autoloader DLT-Tape Library for heterogeneous-networks
 
IBM - AIX HP - UX Red Hat - Linux
Installing AIX 5L on IBM RS/6000 43P Model 150
Overview of SMIT - A Complete GUI tool for Administration
Implementing RAID Levels using AIX's Logical Volume Manager
Boot Logical Volume (BLV) and Config Dev. (cfgmgr)
TCP/IP Applications - telnet, ftp, rlogin, rsh etc.
Installing HP-UX 11i on HP-9000 Model HP-J5000
Overview of SAM - A Complete GUI tool for Administration
Implementing RAID Levels using HP's Logical Volume Manager and VxFS
Boot Console Handler (BCH), Initial System Loader, SSL
TCP/IP Applications - telnet, ftp, rcp, rlogin, etc.
Installing Redhat Linux 9.0 with a Dual Boot Option
Exploring GUI Tools, Services, Enable/Disable Services
Networking Administration BIND utilities, SAMBA, NIS, NFS, APACHE, FTP
Configuring PPP Client and Proxy/Squid
Implementing Firewall using IPtables
 
ORACLE 10g DBA Duration : 6 Weeks
  Pre Requisite : Unix, Oracle & Unix Administration
 
  Architecture
Defining an Oracle Server, Database, 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 will 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, Dropping a Database, ASM Database.
 
  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 stages
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, Renaming Tablespace.
Tablespace – offline, online, readonly, readwrite, Temporary tablespace groups, 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 avg. row length, chained rows, etc after analyzing the tables
Managing, Listing diff. 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 Managing Rollback Segments, Optimal Parameter, Online/Offline, Pending Offline, Deferred Rollback Segments, Snapshot too old scenario
Understanding Oracle Undo Segments, Retention Policy, Retention Gurantee/Nogurantee, Switching Undo Tablespaces
 
  Networking Overview
Explaining solutions included with Oracle 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 Backup sets, Image copies, Complete and Incomplete Recovery and Full/Incremental Compressed backups, Incremental baclups with block change tracking
Transporting Data between DBs using Export, Import, Data Pump, Transportable TS across platform, SQL*Loader
 
  Availability
Dataguard - offers Maximum Protection/Performance, centralizing and simplifying mgmt., safeguarding against physical corruptions, provides Fail Over and Switch Over
Logminer – Read and Analyze the contents of redo log files, obtain info. about DML activities on standard tables, provides a means of auditing actions to either specific tables or by users
Flashback Technology – Intro to Flash Recovery Area, Flashback Version Query, Flashback Transaction Query Oracle10g’s New Features
 
  Oracle 10g New Features
ASM Database
RMAN Compressed backups
Temporary TS groups
TTS across Platforms
ADDM, AWR, ASH
Flashback Features
Data Pump
Resumable Space Mgmt at Inst level Performance Tuning
 
  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, Online Segment Shrinking
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, trcsess, 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, Resumable Space Allocation, Composite partitioning 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, Undo Advisor.
 
  Oracle Advanced Replication
Configuring Master Sites and Materialized View Sites for Multimaster Replication and Materialized View Replication using Oracle Replication Management Tool
 
  Oracle Installation
Oracle10g on Red Hat Enterprise Linux 4, Win2K & Solaris 9 (Sun SPARC)
 
 
DATA WAREHOUSING Duration : 5 Weeks
  Pre Requisite : Oracle
 
  Data Warehousing Concepts
OLTP & OLAP Databases
Decision Support Systems
ROLAP, MOLAP, HOLAP
Characteristics of a Data Warehouse
Life Cycle-Architecture
Data Cleansing, ETL, Meta Data
Data Marts, Cubes and B.I
Data Mining - Knowledge Discovery in Database
 
  Data Warehouse Modeling (Logical)
Dimension Tables & Facts
Dimensions, Details & Measures
Critical Columns, Surrogate Key
Star Schema, Snowflake Schema
Galaxy / Multi-Star Schema
 
  Data Warehouse Modeling (Physical)
Materailised Views
Indexes
Partitioning
RAID Levels
 
  Computer Associates ERWin 4.1
Working with Models
Basic Data Model Objects
Nations, Model
Domain Dictionary
Display Levels, Stored Displays
Subject Area
Explorer Forward & Reverse Engineering
Complete Compare
 
  Informatica Power Center 7.1
Informatica Suite Components
Understanding the Repository
Repository Architecture
Informatica Architecture
Informatica Server Architecture
Reader, DTM, Loader, Temp Server
Installation and Configuration
Transforming the Data
 
  Advanced Informatica
Repository Security
Users, Groups & Privileges
Folder Permissions
Backup & Recovery
Mapplets
Advanced Workflow Management
Event based workflows
Scheduling the workflows
Troubleshooting & Performance Tuning
 
  COGNOS EP Series 7
Impromptu : Catalogs
Types of Catalogs
Weightages & Qualifications, Catalog
Transformer : Query definition files, Models Dimension Map, Diagrams
Cube Creation
Power Play : Drilling, Slicing, Charts, Graphs & Other operations on cube
 
  Business Objects 6.5
Supervisor : Repository, Users & Group Mgmt., Security Management
Designer : Universes, Joins, Loops, Classes, Objects
Business Objects : Query Panel, Formatting, Drilling, Slice & Dice
 
  DATASTAGE 7.5
Overview of Datastage
Datastage Administrator
Datastage Designer
Datastage Director
Datastage Manager
 
 
  Highlights
Two Case studies, Viewlets
Informatica on Network
OLTP Sources : Oracle, SQL Server, Access, Excel, XML, Flat File
Analysis Services
Informatica Performance Tuning
 
  Pre Requisite : Oracle DBA & Unix Administration
 
  Cluster Database Processing Fundamentals
Introduction - RAC Concepts, Benefits of RAC, Oracle9i Release 2 New Features in RAC, Introducing Cluster File System
Architecture - RAC Systems Architecture, RAC Software Architecture, Resource Coordination in RAC
 
  Resource Coordination in RAC
RAC Resource Coordination - Contents of Global Resource Directory, RAC Synchronization Processes
Cache Fusion and the Global Cache Service - Resource Control, Cache-to-Cache Transfer and Cache Coherency, Cache Fusion Scenarios, RAC Recovery and Cache Fusion
Resource Coordination by the Global Enqueue Service - Global Enqueue Service Processing, Global Enqueue Concurrency Control, Resources Managed by the Global Enqueue Service
 
  Administering RAC
Parameter Management in RAC Environments - Server Parameter File, Client-Side Parameter Files, Parameter Settings
Administering Storage Components in RAC - Adding Datafiles, Automatic Undo Management, Using Redo Log Files, Sequence Number Generator
Administering RAC Databases with the Server Control Utility (SRVCTL), SQL*Plus & OEM
 
  Backup & Recovery in RAC
Archiving in a RAC Database
Archive Log File Destinations
Using Recovery Manager in RAC Environment
Performing Backup and Recovery in RAC Environment
 
  RAC Scalability
Adding Nodes and Instances and Deleting Instances in RAC
 
  Deployment and Performance in RAC
Introduction to Application Deployment for RAC
Database Deployment Techniques in RAC
Monitoring RAC Performance
Monitoring Performance in RAC with Oracle Performance Manager
 
  High Availability & Real Application Clusters
High Availability Concepts and Best Practices in RAC - Cluster Components (Cluster Nodes, Cluster Interconnects, Database Software)
Configuring High Availability Features for RAC - Transparent Application Failover, Primary/Secondary Instances
 
  Installing and Configuring the RAC Database
Introduction to RAC Installation and Configuration
Configuring the Shared Disks
Using the Oracle Universal Installer for RAC
Creating Databases with the Database Configuration Assistant
Manually Creating RAC Databases