SQL:

• Retrieving 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

PL/SQL:

• Introduction
• Declaring Variables
• Writing Executable Statements
• Interacting with Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Writing Explicit Cursors
• Writing Implicit Cursors
• 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 Dependents

Course II:

5. SQL:
   • 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

5. Admin I:
   • 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 Database Recovery
   • Performing Flashback
   • Hands on practice
   • Flashback version query
   • Moving Data
   • Oracle Data pump

5. Admin II:

• 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 schedule