Tips Lulus Ujian Oracle Certified Associate (OCA)

Beberapa materi yang harus dikuasai jika anda ingin ujian OCA, berikut materi nya :

1. Oracle SQL Fundamental 1 :

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
2. Oracle SQL Fundamental 2 :
  • Introduction
  • Controlling User Access
  • Manage Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Retrieving Data Using Subqueries
  • Hierarchical Retrieval
  • Regular Expression Support

3.  Oracle Administration 1 :

  • Introduction
  • Installing Oracle Database 10g Software
  • Creating 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 Servers
  • Performance Monitoring
  • Proactive Maintenance
  • Undo Management
  • Monitoring and Resolving Lock Conflicts
  • Backup and Recovery Concepts
  • Database Backups
  • Database Recovery

4.  Oracle Administration 2 :

  • Introduction
  • Using Globalization Support
  • Controlling Access to the Oracle Listener
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Diagnostic Sources
  • Recovering from Noncritical Losses
  • Database Recovery
  • Flashback Database
  • Recovering from User Errors
  • Dealing with Database Corruption
  • Automatic Management
  • Monitoring and Managing Storage
  • Automatic Storage Management
  • Monitoring and Managing Memory
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Workshop

About Administrator

ok deh
This entry was posted in Komputer. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s