Project Gallery

 Request Quote

 Our Partners and Associates

 Customer Speak

 White Papers

Oracle Database Administration, Oracle WebLogic Administration, Golden Gate, Performance Tuning, IBM AIX, Linux, UNIX, Solaris, IBM-TSM, Tivoli Backup, Staffing Solution,

You can send your enquiry to training@cympac.com mentioning course name in the subject line.

Contact Us to know about our course

UNIX Training At Cympac Software Solutions

• Delegate and trainer introductions, Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION TO THE HP-UX OPERATING SYSTEM

• 1. A brief history of UNIX
• 2. The UNIX kernel
• 3. The UNIX file system
• 4. Getting started navigating the file system
• 5. The file system structure
• 6. Directories and files
• 7. Pathnames
• 8. Navigating the file system

Exercise: Logging on to the system
Exercise: Navigating the file system
Session 2: BASIC COMMANDS

• 1. Command line syntax
• 2. Basic file handling commands
• 3. Basic Directory handling commands
• 4. Filename wildcard characters

Exercise: Manipulating files and directories
Session 3: REDIRECTION AND PIPES

• 1. Input redirection
• 2. Output redirection
• 3. Pipes

Exercise: Using redirection and pipe facilities
Session 4: INTRODUCTION TO THE vi EDITOR

• 1. Overview of the vi editor
• 2. Basic functions
• 3. Switching to input mode
• 4. Other useful commands

Exercise: Using the vi editor
Exercise: Using more advanced vi features
Session 5: SEARCHING AND REPLACING TEXT

• 1. Replacing text
• 2. Using the vi editor
• 3. Using sed for search and replace
• 4. Searching for text with grep
• 5. Linking files

Exercise: Searching and Replacing Text
Session 6: RECALLING AND EDITING COMMANDS

• 1. Overview
• 2. The bash shell
• 3. The korn shell

Exercises: Recall and Edit Commands
Session 7: FILE PERMISSIONS AND ACCESS CONTROL

• 1. Users and user groups
• 2. File access permissions
• 3. Changing file attributes
• 4. Switching users and user groups
• 5. Linking files

Exercise: Setting and access permissions
Session 8: PROCESSES

• 1. What is a process?
• 2. Monitoring processes
• 3. Killing processes
• 4. Background processes
• 5. Job Control
• 6. Grouping commands

Exercise: Monitoring and controlling processes
Session 9: MORE BASIC COMMANDS

• 1. The wc (word count) command
• 2. The find command
• 3. The cut command
• 4. The sort command
• 5. The finger command

Exercise: Using file handling commands
Session 10: THE USER ENVIRONMENT

• 1. Customising the .profile or .bash_profile
• 2. Customising the .kshrc or .bashrc

Exercise: Setting up an environment
Course Introduction . Administration and course materials . Course structure and agenda
Session 1: HP-UX COMMAND REVIEW

• 1. Basic Unix commands
• 2. General commands
• 3. File and directory handling commands
• 4. Filename generation characters
• 5. I/O Redirection features
• 6. Other commands

Session 2: GETTING STARTED

• 1. What is a shell script?
• 2. Development guidelines
• 3. Creating and editing shell scripts
• 4. Naming and storing shell scripts
• 5. Executing shell scripts

Exercise: Write a simple shell script
Session 3: USING VARIABLES

• 1. Environment variables
• 2. Local variables
• 3. Assigning values to variables
• 4. Assessing variable values
• 5. Using quotes
• 6. Delimiting variable names
• 7. Echo control sequences

Exercise: Add variables to a script
Session 4: INTEGER ARITHMETIC

• 1. Using the expr command
• 2. Using the (( )) notation

Exercise: Add integer arithmetic to a shell script
Session 5: HANDLING RUN TIME DATA

• 1. The read command
• 2. Command line arguments

Exercise: Writing a generic shell script
Exercise: Writing an interactive shell script
Session 6: CONDITION EXECUTION

• 1. The if statement
• 2. The test command
• 3. Other test notations
• 4. Default and substitute variables
• 5. Exit status codes

Exercise: Adding validation to previous scripts
Session 7: LOOP CONSTRUCTS

• 1. The while loop
• 2. The until loop
• 3. The for loop
• 4. The while true and until false loops
• 5. Loop control commands

Exercise: Enhancing the previously written scripts
Exercise: Writing a guess-the-number game
Session 8: MULTI-BRANCH DECISIONS

• 1. The case statement
• 2. Menu driven applications

Exercise: Developing and writing a menu system
Session 9: FUNCTIONS

• 1. What is a function?
• 2. Syntax
• 3. Examples

Exercise: Add a function to a script
Session 10: INTERRUPT HANDLING

• 1. Interrupt signals
• 2. Trapping interrupts

Exercise: Adding traps to the menu script
Session 11: ADDITIONAL FEATURES AND FACILITIES

• 1. The exec commands
• 2. The includes notation
• 3. More about loops
• 4. Arrays
• 5. Here Documents

Exercise: Create a here script

PL/SQL

{ Top }

Oracle 11g Administrator Workshop I

Installing the Oracle Database Software

• Installation: System Requirements
• Checking the System Requirements
• Optimal Flexible Architecture (OFA)
• Setting Environment Variables
• Installing the Oracle Software

Creating an Oracle Database

• Database Configuration Assistant (DBCA)
• Using the DBCA to Create a Database

Managing the Oracle Instance

• Starting and Stopping Database Control
• Oracle Enterprise Manager

Managing Database Storage Structures

• How Table Data Is Stored
• Tablespaces and Data Files
• Space Management in Tablespaces
• What Is Automatic Storage Management?
• ASM: Key Features and Benefits
• ASM: Concepts

Administering User Security

• Database User Accounts
• Authenticating Users
• Administrator Authentication
• Unlocking a User Account and Resetting the Password
• Creating a Password Profile

Managing Schema Objects

• What Is a Schema?
• Accessing Schema Objects
• Naming Database Objects
• Types of Indexes
• B-Tree Index
• Bitmap Indexes
• What Is a View?
• Creating Views
• Sequences
• Creating a Sequence
• Data Dictionary:
• Data Dictionary Views

Managing Data and Concurrency

• Manipulating Data Through SQL

Managing Undo Data

• Data Manipulation
• Undo Data
• Undo Data Versus Redo Data
• Configuring Undo Retention
• Guaranteeing Undo Retention

Implementing Oracle Database Security

• Database Security
• Standard Database Auditing
• Uniform Audit Trails
• Value-Based Auditing
• Fine-Grained Auditing
• DBA Auditing

Configuring the Oracle Network Environment

• Oracle Net Services
• Oracle Net Listener
• Establishing Net Connections
• Establishing a Connection
• Naming Methods

Proactive Maintenance

• Optimizer Statistics
• Using the Manage Optimizer Statistics
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)
• Enterprise Manager and Advisors

Performance Management

• Performance Monitoring
• SQL Tuning Advisor:
• Enabling Automatic Shared Memory Management (ASMM)
• Using the Memory Advisor

Oracle 11g Administrator Workshop II

Backup and Recovery Concepts

Performing Database Backups

• Oracle Secure Backup
• User-Managed Backup
• Recovery Manager (RMAN)
• Managing Backups

Performing Database Recovery

Performing Flashback

• When to Use the Flashback Technology

Moving Data

• Loading Methods
• Data Pump:
• Data Pump Export and Import:
• Data Pump Utility
• External Table Population with ORACLE_DATAPUMP
• External Table Population with ORACLE_LOADER

Configuring Recovery Manager

Using Recovery Manager

Database Recovery

Flashback

Dealing With Database Curruption

Monitoring and Managing Memory

• Memory Management
• How ASMM Works and how to Configure

Autumatic Performance Management

• Tuening Activity
• Performance Planning
• Statics collection
• Troubleshooting and Tuening
• Database Control and Advisor

Managing Storage

• Space Management
• Extends Typs
• Row Chaning and Migretion
• Monitoring Tablespace
• Transporting Tablespace
• Transporting Database

Automatic Storage Management

• ASM Architecture
• Creating ASM Instance
• ASM Storage
• Disk Group Mirroring
• ASM files
• Migreting Database to ASM instance

{ Top }

Real Application Cluster (RAC)

{ Top}