AISE
All India Society of Education
AISE
 
AISE

About AISE

 


Profile

ORACLE
DCMT is a single solution resource you need for all of database services and training needs. Whether your needs include management of your entire data platform, best database training, quality remote or onsite assistance, We scope our services to help conclude your search with DCMT one stop solution for database. DCMT is a global leader in providing hands-on training and meeting the database requirements for industries.

DCMT Oracle training provides Corporate Oracle training and is a leader in Oracle Training courses.

Our Staff taught more then hundred of Oracle Training classes and excels at developing Oracle training that examples complex computer topics in plain English. We developed customized Oracle Training for some of the India’s largest corporations.

Our typically instructor has more than 7 years of real-world IT experience, who provides their services on the weekends basis some of them provide the training on the call basis with DCMT.

DCMT also provides on-site Corporate Oracle Training anywhere in India ORACLE...
»  Oracle 9 i DBA
Introduction to Oracle9i: SQL
  • Introduction
  • Writing Basic SQL SELECT Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data Using Group Functions
  • Sub queries
  • Producting 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 Retrieval
  • Oracle 9i Extensions to DML and DDL Statements
Oracle 9i Database Administration Fundamentals I
  • Introduction
  • Oracle Architectural Components
  • Getting Started with the Oracle Server
  • Managing an Oracle Instance
  • Creating a Database
  • Using Data Dictionary and Dynamic Performance Views
  • Maintaining the Control File
  • Maintaining Redo Log Files
  • Managing Tablespaces and Datafiles
  • 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
  • Auditing
  • Loading Data into a Database
  • Using Globalization Support
Oracle 9i Database Administration Fundamentals II
  • 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
  • RMAN Complete Recovery
  • RMAN Incomplete Recovery
  • RMAN Maintenance
  • Recovery Catalog Creation and Maintenance
  • Transporting Data Between Databases
  • Workshop
Oracle 9i Performance Tuning
  • Overview of Oracle9i Performance Tuning
  • Diagnostic and Tuning Tools
  • Sizing the Shared Pool
  • Sizing the Buffer Cache
  • Sizing Other SGA Structures
  • Database Configuration and I/O Issues
  • Optimizing Sort Operations
  • Diagnosing Contention for Latches
  • Tuning Undo Segments
  • Monitoring and Detecting Lock Contention
  • Tuning the Oracle Shared Server
  • SQL Statement Tuning
  • Using Oracle Blocks Efficiently
  • Application Tuning
  • Tuning the Operating System and Using Resource Manager
  • Workshop
  • Recovery Catalog Creation and Maintenance
  • Transporting Data Between Databases
  • Workshop
»  Oracle 9i Application Developer
Introducation to Oracle9i: SQL 40 hrs (exam 1z0-007)
  • Introduction
  • Writing Basic SQL SELECT Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data Using Group Functions
  • Sub queries
  • Producting 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 Retrieval
  • Oracle 9i Extensions to DML and DDL Statements
Oracle 9i Program with PL/SQL- (exam 1z0-147)
(Prerequisites : knowledge of SQL / SQL*PLUS
or Introduction to Oracle 9i SQL)


Duration : 40 Hours
  • Introduction
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structure
  • Working with Composite Data Types
  • Writing Explicit Cursors
  • Configuring the Database Archiving Mode
  • Advanced Explicit Cursors and Concepts
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Managing Subprograms
  • Creating Packages
  • More Package Concepts
  • Oracle Supplied Packages
  • Manipulating Large Objects
  • Creating Database Triggers
  • More Trigger Concepts
  • Managing Dependencies
Oracle 9i Forms Developer : Build Internet Applications (exam 1z0-141)
(Prerequisites : Introduction to Oracle 9i SQL & Oracle 9i Program with PL/SQL)

Duration : 40 Hours
  • Introduction to Oracle Developer and Oracle Services
  • Running a Forms Developer Application
  • Working in the Forms Developer Application
  • Creating a Basic Form Module
  • Working with Data Blocks and Frames
  • Working with Text Items
  • Creating LOVs and Editors
  • Creating Additional Input Items
  • Creating Non Input Items
  • Creating Windows and Content Canvases
  • Working with other Canvas Types
  • Introducing to Triggers
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Runtime Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation
  • Transaction Processing
  • Writing Flexible Code
  • Sharing Objects and Code
  • Introducing Multiple Form Applications
Oracle 9i Reports Developer Build Reports
(Prerequisites : Introduction to Oracle 9i SQL, Introduction to Oracle 9i PL/SQL)

Duration : 40 Hours
  • Introducing to Oracle 9i Reports Developer
  • Designing and Running Reports
  • Working in Oracle 9i Reports Developer
  • Creating Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Creating a Web Report
  • Enhancing Reports Using the Data Model : Queries and Groups
  • Enhancing Reports Using the Data Model : Data Sources
  • Enhancing Reports Using the Data Model : Creating Columns
  • Enhancing Reports Using the Paper Layout
  • Controlling the Paper Layout : Common Properties
  • Controlling the Paper Layout : Specific Properties
  • Web Reporting
  • Extending Functionality Using XML
  • Creating and Using Reports Parameter
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers
  • Extending Functionality Using the SRW Package
  • Maximizing Performance using Oracle 9i as Reports Services
  • Building Reports : Efficiency Guideline
The following assistance will be given to the student while training
  • Intensive group instruction
  • One-on-one instruction attention given by Real Time Trainer
  • Hands-on labs with no hours condition
  • Lab partner and group exercises
  • Question and answer drills.
  • Friendly competitions between concurrently running classes
  • Self-testing /Mock Test
»  Oracle DBA 10g for OCA
Oracle Database 10g is Oracle’s largest introduction of new functionality and is Oracle’s most innovative release, leading the database industry into new ground in clustering, automation, high availability and more.

Oracle Database 10g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Exam Topics for Oracle 10g: Administration I
  • Architecture
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backup
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data
The following assistance will be given to the student while training
  • Intensive group instruction
  • One-on-one instruction attention given by Real Time Trainer
  • Hands-on labs with no hours condition
  • Lab partner and group exercises
  • Question and answer drills.
  • Friendly competitions between concurrently running classes
  • Self-testing /Mock Test
»  Oracle DBA 10g for OCP
Oracle Database 10g is Oracle’s largest introduction of new functionality and is Oracle’s most innovative release, leading the database industry into new ground in clustering, automation, high availability and more.

Oracle Database 10g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Exam Topics for Oracle 10g: Administration II
  • Using Globalization Support Objectives
  • Configuring Recovery Manager
  • Recovering from User Errors
  • Managing the Oracle Instance
  • Dealing with Database Corruption
  • Automatic Database Management
  • Using Recovery Manager
  • Recovering from Non-Critical Losses
  • Monitoring and Managing Storage
  • Automatic Storage Management
  • Monitoring and Managing Memory
  • Database Recovery
  • Flashback Database
  • Managing Resources
  • Automating Tasks with the Scheduler
The following assistance will be given to the student while training
  • Intensive group instruction
  • One-on-one instruction attention given by Real Time Trainer
  • Hands-on labs with no hours condition
  • Lab partner and group exercises
  • Question and answer drills.
  • Friendly competitions between concurrently running classes
  • Self-testing /Mock Test
»  Oracle DBA 11g for OCA
Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.

Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Exam Topics for Oracle 11g: Administration I
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
The following assistance will be given to the student while training
  • Intensive group instruction
  • One-on-one instruction attention given by Real Time Trainer
  • Hands-on labs with no hours condition
  • Lab partner and group exercises
  • Question and answer drills.
  • Friendly competitions between concurrently running classes
  • Self-testing /Mock Test
»  Oracle DBA 11g for OCP
Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.

Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Exam Topics for Oracle 11g: Administration II
  • Database Architecture and ASM
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Using RMAN to Create Backups
  • Performing User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • Using RMAN to Duplicate a Database
  • Performing Tablespace Point-in-Time Recovery
  • Monitoring and Tuning RMAN
  • Using Flashback Technology
  • Additional Flashback Operations
  • Diagnosing the Database
  • Managing Memory
  • Managing Database Performance
  • Space Management
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Administering the Scheduler
  • Globalization