Oracle Programming

Introduction

• Retrieving data using the SQL select statement
• Restricting and sorting data
• Using single row functions to customize reports
• Reporting aggregated data using the group functions
• Displaying data from multiple tables
• Using sub queries to solve queries
• Using the set operators
• Manipulating data
• Using DDI statements to create and manage tables
• Creating other schema objects
• Managing objects with data dictionary views
• Controlling user access
• Generating reports by grouping related data
• Managing data in different time zones
• Searching data using advanced sub queries
• Hierarchical data retrieval

Introduction to PL/SQL objects

• Procedural language
• PL/SQL blocks, anonymous blocks and named blocks
• Creating PL/SQL procedures and functions
• Understanding triggers
• Packages

Oracle 10g-administration workshop I

Introduction

• Installing oracle database 10g software
• Create an oracle database
• Database interfaces
• Controlling the database
• Storage structures
• Administering users
• Managing schema objects
• Managing data

PL/SQL

• Oracle database security
• Oracle net services
• Oracle shared server
• Performance monitoring

Proactive maintenance

Objectives undo management

• Monitoring and resolving lock conflicts
• Backup and recovery concepts
• Database backups
• Database recovery

Oracle 10g-administration workshop II

• Using globalization support
• Securing the oracle listener
• Configuring recovery manager
• Using recovery manager
• Diagnostic sources
• Recovering from non-critical losses
• Database recovery
• Flashback database
• Recovering from user errors
• Dealing with database corruption
• Automatic database management
• Monitoring and managing storage
• Automatic storage management
• Monitoring and managing memory
• Managing resources
• Automating tasks with the scheduler