Oracle(DBA/Developer)

Course Contents :

Oracle Database 10g: Introduction to sql(Exam # IZO-007)

• Introduction to sql
• Writing SQL select statement
• Restricting and sorting Data
• Using single row functions to Customize Output
• Reporting Aggregated Data Using the group Function
• Displaying Data from Multiple Tables
• Using sub Queries to sole queries
• Using the set operators
• Manipulating Data
• Using DDL Statement to Create and Manage Tables
• Creating Other Scheme Oblects
• Managing Opbjects With Data Dictionary
• Controlling User Access
• Manage Schema Objects
• Manipulating Large Data Access
• Generating Report by Grouping Related Data
• Managing Data in Diffrent Time Zones
• Searchin Data Using Advacned Sub Queries
• Hierarchical Retrieval
• Regular Expression Support

Oracle Database 10g: Administration Workshop (Exam # IZO-042)

• Introduction (Database Architecture)
• Installing The Oracle Database Software
• Creating an Oracle database
• Managing the Oracle Database
• Managing Database Storage Structure
• Administering User Security
• Manage Shema Objects
• Managin Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive maintenance
• Backup Recovery Concepts
• Performing Database Backups
• Performing Database Recovery

Oracle Database 10g: Administration Workshop (Exam # IZO-043)

• Introduction to 10g Administration WorkshopII
• Configuring Recover Manager
• Using Recovery Manager
• Oracle Secure Backup
• Recovery from Non-Creitical Loss
• Incomplete Recovery
• Flashback
• Dealing With Database Corruption
• Monitoring and Managing Memory
• Monitoring and Managing StorageI
• Monitoring and Managing SotrageII
• Automatic Performance Management
• Automatic Storage Management
• VLDB Support
• Managng Resources
• Database Security
• Data Movement
• Using Globalization Support