Oracle 9i : SQL Course

SEED Infotech
In Pune

Price on request
Students that were interested in this course also looked at...
See all

Important information

  • Course
  • Pune

Important information

Where and when

Starts Location
On request
"Panchasheel", 42/16, Erandawana, Seed Infotech Lane, off Karve Road, 411004, Maharashtra, India
See map

Frequent Asked Questions

¬∑ Requirements

Computer Fundamentals and Windows Operating System knowledge is an advantage. Any Programming Language, DBMS like Dbase or FoxPro are preferred and Oracle 9i SQL and PL/SQL.

Course programme

Introduction to Oracle 9i : SQL
Course Content

Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Single- Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Producing Readable Output with iSQL *Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Other Database Objects
Controlling User Access
SQL Workshop
Using SET Operators
Oracle 9i Datetime Functions
Enhancements to the GROUP BY Clause
Advanced Subqueries
Hierarchical Retrival
Oracle 9i Extensions to DML and DDL Statements

Oracle 9i : Database Administration Fundamentals - I
Course Content

Oracle Architectural Components
Getting Started with Oracle Server
Managing an Oracle Instance
Creating a Database
Using Data Dictionary and Dynamic Performance Views
Maintaining the Control File
Maintaining Online Redo Log File
Managing Tablespaces and Data Files
Storage Structure and Relationships
Managing Undo Data
Managing Tables
Managing Indexes
Maintaining Data Integrity
Managing Password Security and Resources
Managing Users
Managing Privileges
Managing Roles
Loading Data into a Database
Using Globalisation Support

Oracle 9i : Database Administration Fundamentals - II
Course Content

Networking Overview
Oracle Net Architecture
Basic Oracle Net Server Side Configuration
Naming Method Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuring the Database Archiving Mode
Oracle Recovery Manager Overview and Configuration
User - Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery
User - Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Maintenance
Recovery Catalog Creation and Maintenance
Export and Import Utilities

Oracle 9i Database Performance Tuning
Course Content

Overview of Oracle9i Database Performance Tuning
Diagnostic and Tuning Tools
Database Configuration and I/O Issues
Tuning the Shared Pool
Tuning the Buffer Cache
Dynamic Instance Resizing
Sizing Other SGA Structures
Tuning the Oracle Shared Server
Optimizing Sort Options
Using Resource Manager
SQL Statement Tuning
Managing Statistics
Using Oracle Blocks Efficiently
Using Oracle Data Storage Structures Efficiently
Application Tuning
Using Materialised Views
Monitoring and Detecting Lock Contention
Tuning the Operating System
Workshop Overview

Students that were interested in this course also looked at...
See all