SQL=>20 hours

  • Retriving data using the SQL select statement
  • Restricting and sorting data
  • Using single row function to customize output
  • Reporting aggregated data using the grout function.
  • Displaying data from multiple tables –I
  • Displaying data from multiple tables-II
  • Using sub queries to solve problems
  • Using set operators
  • Manipulating data
  • Using DDL statements to create and manage tables
  • Creating other schema objects
  • Managing objects with data dictionary
  • Controlling User access
  • Managing schema objects
  • Manipulating large data sets
  • Generating report by grouping related data
  • Managing data in different time zones
  • Retrieving data using sub queries
  • Hierarchical retrieval
  • Regular expression support

Admin I=>60 hours

  • Introduction
  • Installing the Oracle Database Structure
  • Creating an Oracle Instance
  • Managing the Oracle Instance
  • Managing Database Storage Structure
  • Oracle managed file(OMF)
  • Creating a table space
  • Administering security
  • Managing Schema Objects
  • Types of Indexes
  • Managing Data and Concurrency
  • Locking Mechanism
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network environment
  • Proactive Maintenance
  • ADDM
  • Performance Management
  • Backup and Recovery Concept
  • Hot Backup
  • Cold Backup
  • Hands on practice
  • Performing Database Backups
  • Performing Flashback
  • Hands on practice
  • Flashback version query
  • Moving Data
  • Oracle Data pump

Admin II=>60 hours

  • Introduction
  • Oracle managed files
  • Configuring recovery manager
  • Using recovery manager
  • RMAN backup types
  • Hands on practice
  • Recovering from non critical loses
  • Database recovery
  • Types of incomplete recovery
  • Flashback
  • Dealing with database corruption
  • Hands on practice
  • Monitoring and managing memory
  • Automatic shared memory management
  • Automatic performance management
  • Automatic workload repository
  • Managed schema objects
  • Hands on practice
  • Clusters
  • Managing storage
  • Automatic storage management
  • ASM disk group
  • Portioning a disk
  • Managing resources
  • Automatic task with scheduler
  • Database security
  • Transparent data encryption
  • Using globalization support
  • Hands on practice