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.

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.

ADMIN

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 - Performance Management - Backup and Recovery Concept.