PranasLu's Blog

2010-02-09

Oracle certification

Filed under: Programming — Tags: , — pranaslu @ 11:47

Bendras vaizdas:

image

Pradziai reiketu:

  • 1Z0-047 Oracle Database SQL Expert
  • Oracle Database 11g: Administration I

Exam topics – 1Z0-047 Oracle Database SQL Expert

  • 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
  • Controlling User Access
  • Managing 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

Exam topics – Oracle Database 11g: Administration I

  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Create a free website or blog at WordPress.com.

%d bloggers like this: