SQL STATEMENTS

• Introduction
• Writing Sql statements
• Restricting and sorting data
• Single row functions
• Displaying data from multible data
• Aggregating data using group functions
• Subqueries
• Producing readable o/p with isql*plus
• Manipulating data
• Creating and managing tables
• Including constraints
• Creating views
• Other database objects
• Controlling user access
• SQL workshop
• Using set operators
• Datetime functions
• Enhancements to the groupby clause
• Hierarchial Retrival
• Extension of DML & DDL statements

FUNDAMENTAL-1

• 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 online redolog files
• Managing tablespaces and datafiles
• Storage structures 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 the database
• Using globalization support

FUNDAMENTAL-2

• Networking overview
• Oracle net architecture
• Basic oracle net server slide 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
• User managed incomplete recovery
• RMAN incomplete recovery
• RMAN maintainancce
• Recovery catalog creation and maintanence
• Export and Import utilities
• Workshop

PERFORMANCE AND TUNING

• Database performance tuning
• Diagnostic and tuning tools
• Database configuration and I/O issues
• Tuning and Shared pool
• Tuning the buffer cache
• Dynamic instance resizing
• Sizing other SGA structures
• Tuning oracle shared server
• Optimizing SORT operations
• Using resource manager
• SQL statement tuning
• Managing statistics
• Using oracle blocks efficiently
• Using oracle data storage structures efficiently
• Application tuning
• Using materialized views
• Monitoring and detecting lock ciontention
• Tuning the operating system
• Workshop overview