NetWeb Technologies
2nd Floor, R.S. Tower, Hall Bazar
+91-921-679-2175 +91-902-338-7555

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