DUCAT is the only training institute giving technical training with a difference. The institute not only provides training but takes proper care that the training is meaningful. DUCAT provides training on Oracle 11g DBA in the most technical way. Oracle 11g DBA is an Oracle revolution which is a boom for database administrators. It deals with self and storage management having clustering features. It releases data administrators from doing low value work and to gives them an opportunity to increase their value. It also helps them to technically more sound in their respective field. DUCAT provides a training which teaches this new technique in a focused manner. The motive of the training is that it teaches you the new technology in a way that you can put it into your work field quickly. You learn directly from the source so the knowledge gained is perfect. DUCAT training staff are the most experienced in this new Oracle technology. They give lessons, shows and explain practical examples, creates work environment where this technology can be used. So, after taking the training one becomes an expert of this technology which is in demand all over in every industry. The training makes one expert in a field which helps to earn a comfortable salary.

ORACLE 11G DBA

  • Introducing SQL Basic Commands
  • Writing basic select statements
  • Restricting and sorting of data
  • Introducing sql function
  • Single row function and group function
  • Conditional Expression
  • Using substitution on variable
  • Introducing sql commands
  • Using DDL Statements
  • Managing Tables
  • Data manipulation operation
  • Understanding transaction
  • Using transaction control statements
  • Overview of locks
  • Using flashback and purge command
  • Granting and revoking system and object privileges
  • Designing tables by using key constraints
  • Deferred constraints
  • Retrieving data from more than one tables using join operation
  • Aggregating Data Using Group Functions
  • Introducing With View
  • Introducing With Indexes
  • Introducing With Synonyms
  • Introducing With Sequence And Use With Database
  • Introducing Sub queries
  • Single row sub query ,Multiple row sub query
  • Introduction
  • Correlated sub query
  • Top - n analysis
  • Using the Set Operators
  • Inserting and Updating Data
  • Deleting Data
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Date and Time Function
  • Rollup and Cube Operator Using Group by Function
  • Multiple Insertion and Types
  • Hierarchical Tree
  • Sql loader

ADVANCED SQL

  • Overview of analytical function
  • Introducing inline view
  • Introduction of With clause
  • Materialize view
  • Overview of restore
  • Overview of semi join and anti join
  • Embedding sub query with Dml operation

ORACLE DATABASE 11G : ADMINISTRATION WORKSHOP 1 RELEASE 1

  • Introduction (database architecture)
  • Describe course objectives
  • Explore the oracle 11g database architecture
  • Installing the oracle database software on windows and linux
  • Creating on oracle database
  • Managing the oracle instance
  • Managing database strong structure
  • Administering user security
  • Managing the oracle instance
  • Managing database storage structures
  • Administering user security
  • Managing schema 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 recovery
  • Performing flashbacks
  • Moving data

ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP 2 RELEASE 2

  • Introduction
  • Configuring Recovery Manager
  • RMAN Backup
  • Recovering from Non-critical Losses
  • Database recovery
  • flashback
  • Dealing with Database Corruption
  • Monitoring and Managing Memory
  • Monitoring and Managing Memory
  • Managing Schema objects
  • Managing Storage
  • Automatic Storage Management
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Database Security
  • Using Globalization Support

ORACLE-PL/SQL

  • Declaring PL/SQL identifiers
  • Writing executable statements
  • Writing control structures
  • Using explicit cursors
  • Creating stored procedures
  • Creating stored functions
  • Creating packages
  • Creating triggers

REDHAT LINUX

  • Linux ideas and History
  • Installation
  • Linux Basic COMMANDS
  • Users, Groups and Permissions
  • VIM: Text Editor
  • YUM server configuraton
  • System configuration tools
  • Investigating and managing process
  • Configuring the BASH shell
  • Finding and processing files
  • Linux file system
  • Package management
  • File system management
COMMENCING NEW BATCHES
ENQUIRY FORM
FOLLOW US ON
SUBSCRIBE TO OUR NEWSLETTER

WE ACCEPT ONLINE PAYMENTS
PAY ONLINE