Oracle 10g OCA/SQL/OCP & 11g Upgrade Certification Boot Camp

Class Schedule 10/02/10 - 10/18/10 Info/Enroll

The Oracle10g™ DBA Certified Associate is the stepping-stone for a candidate to build a successful career as an Oracle Professional. The OCA credential enables database professionals to prove competency in basic skills required to manage the industry's most advanced database technology, using cutting edge tools.

• 1Z0-042 Oracle10g™ Database : Administration I ™

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

• 1Z0-047 Oracle SQL Expert

The Oracle10g™ DBA Certified Professional is a credential for true database professionals who have the skills to set up and manage critical Oracle10g™ Database functions and the know-how to keep it running at maximum efficiency. Acquiring an OCP credential is a real professional accomplishment. The OCP credential is proof to employers, peers and the technical community that you are a skilled professional and have taken a critical step in building your career.

• 1Z0-043 Oracle10g™ Database: Administration II ™

The Oracle Database 11g Upgrade gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g.

• 1Z0-050 Oracle Database 11g: New Features for Administrators

The Oracle OCP Hands on Requirement at Oracle University is included in the cost of this class.

Oracle10g™ OCA

Course Outline

1Z0-042 Oracle10g™ Database: Administration I ™

Installing Oracle10g™ Database Software

• Identify system requirements
• Use Optimal Flexible Architecture
• Install software with Oracle Universal Installer
• Identify and configure commonly used environment variables

Creating an Oracle Database

• Explain the Oracle database architecture
• Explain the instance architecture
• Use the management framework
• Use DBCA to Create a database
• Use DBCA to Configure a database
• Use DBCA to Drop a database
• Use DBCA to Manage templates

Managing Schema Objects

• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views
• Name database objects
• Select appropriate data types
• Create and use sequences

Managing Data

• Manipulate data through SQL using INSERT, UPDATE, and DELETE
• Use Data Pump to export data
• Use Data Pump to import data
• Load data with SQL Loader
• Create directory objects

PL/SQL

• Identify PL/SQL objects
• Describe triggers and triggering events
• Identify configuration options that affect PL/SQL performance

Undo Management

• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the Undo Advisor
• Describe the relationship between undo and transactions
• Size the undo tablespace

Monitoring and Resolving Lock Conflicts

• Detect and resolve lock conflicts
• Manage deadlocks
• Describe the relationship between transactions and locks
• Explain lock modes within the Oracle10g™ Database

Database Interfaces

• Use SQL*Plus and iSQL*Plus to access the Oracle10g™ Database
• Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
• Use SQL to query, manipulate, and define data using SELECT, UPDATE/INSERT/DELETE and CREATE/ALTER/DROP statements
• Identify common database interfaces
• Describe a database transaction

Controlling the Database

• Start and stop iSQL*Plus
• Start and stop Enterprise Manager Database Control
• Start and stop the Oracle Listener
• Start up and shut down Oracle10g™ Database
• Describe startup and shutdown options for the Oracle Database
• Handle Parameter files
• Locate and view the Database alert log

Oracle Database Security

• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features
• Audit database activity
• Register for security updates

Oracle Net Services

• Use Database Control to Create additional listeners
• Use Database Control to Create Oracle Net service aliases
• Use Database Control to Configure connect time failover
• Use Listener features
• Use the Oracle Net Manager to configure client and middle-tier connections
• Use TNSPING to test Oracle Net connectivity
• Describe Oracle Net Services
• Describe Oracle Net names resolution methods

Backup and Recovery Concepts

• Describe the basics of database backup, restore and recovery
• Describe the types of failure that may occur in an Oracle Database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Configure ARCHIVELOG mode
• Configure a database for recoverability

Storage Structures

• Define the purpose of tablespaces and data files
• Create tablespaces
• Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write)
• Obtain tablespace information from EM and the data dictionary
• Drop tablespaces
• Describe the default tablespaces

Administering Users

• Create and manage database user accounts
• Create and manage roles
• Grant and revoke privileges
• Control resource usage by users

Oracle Shared Servers

• Identify when to use Oracle Shared Servers
• Configure Oracle Shared Servers
• Monitor Shared Servers
• Describe the shared server architecture

Performance Monitoring

• Troubleshoot invalid and unusable objects
• Gather optimizer statistics
• View performance metrics
• React to performance issues

Proactive Maintenance

• Set warning and critical alert thresholds
• Collect and use baseline metrics
• Use tuning and diagnostic advisors
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Manage the Automatic Workload Repository
• Describe server generated alerts

Database Backups

• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area
• Describe the difference between image copies and backup sets
• Describe the different types of database backups
• Backup a control file to trace
• Manage backups

Database Recovery

• Recover from loss of a Control file
• Recover from loss of a Redo log file
• Recover from loss of a system-critical data file
• Recover from loss of a non system-critical data file

[ back to top ]

Oracle SQL Expert

Course Outline

SELECT Statements

• Define projection, selection, and join terminology
• Select all columns using a wildcard notation from a table
• Write a query containing the arithmetic operators
• Create a character expression with the concatenation operator
• Using the iSQL*Plus Environment
• SQL statements versus iSQL*Plus commands

Restricting and Sorting Data

• Limit rows using a selection
• Using the WHERE clause to retrieve specific rows
• Using the comparison conditions in the WHERE clause
• Use the LIKE condition to compare literal values
• List the logical conditions AND, OR, NOT
• Describe the rules of precedence for the conditions
• Sort rows with the ORDER BY clause

Single-Row Functions

• Show the differences between single row and multiple row SQL functions
• Categorize the character functions into case manipulation and character manipulation types
• Use the character manipulation functions in the SELECT and WHERE clauses
• Explain and use the DATE and numeric functions

Aggregate Functions

• Describe and categorize the group functions
• Use the group functions
• Utilize the DISTINCT keyword with the group functions
• Describe how nulls are handled with the group functions
• Create groups of data with the GROUP BY clause
• Group data by more than one column
• Avoid illegal queries with the group functions
• Exclude groups of data with the HAVING clause

Joining Tables

• Identify Types of Joins
• Retrieve Records with Natural Joins
• Use Table Aliases to write shorter code and explicitly identify columns from multiple tables
• Create a Join with the USING clause to identify specific columns between tables
• Use the ON clause to specify arbitrary conditions or specify columns to Join
• List the Types of Outer Joins LEFT, RIGHT, and FULL
• Generating a Cartesian Product

Using Sub queries

• List the syntax for sub queries in a SELECT statements WHERE clause
• List the guidelines for using sub queries
• Describe the types of sub queries
• Execute single row sub queries and use the group functions in a sub query
• Identify illegal statements with sub queries
• Execute multiple row sub queries

Manipulating Data

• Write INSERT statements to add rows to a table
• Copy rows from another table
• Create UPDATE statements to change data in a table
• Generate DELETE statements to remove rows from a table
• Use a script to manipulate data
• Save and discard changes to a table through transaction processing
• Show how read consistency works
• Describe the TRUNCATE statement

Creating Tables

• List the main database objects and describe the naming rules for database objects
• Explain the different types of constraints
• Show resulting exceptions when constraints are violated with DML statements
• Create a table with a sub query
• Describe the ALTER TABLE functionality
• Remove a table with the DROP statement and Rename a table

Creating Objects

• Categorize simple and complex views and compare them
• Create a view
• Retrieve data from a view
• Explain a read-only view
• List the rules for performing DML on complex views
• Create a sequence
• List the basic rules for when to create and not create an index
• Create a synonym

Security

• Controlling User Access
• System versus Objects Privileges
• Using Roles to define user groups
• Changing Your Password
• Granting Object Privileges
• Confirming Privileges Granted
• Revoking Object Privileges

Schema Objects

• Using the ALTER TABLE statement
• Adding a Column
• Modifying a Column
• Dropping a Column, Set Column UNUSED
• Adding, Enabling and Disabling Constraints
• Creating Function-Based Indexes
• Performing FLASHBACK operations
• External Tables

Advanced DML Operations

• Using the MERGE Statement
• Performing DML with Sub queries
• Performing DML with a RETURNING Clause
• Tracking Changes in DML

Time Zone Changes

• Using date and time functions
• Identifying TIMESTAMP Data Types
• Differentiating between DATE and TIMESTAMP
• Performing Conversion Operations

Advanced Sub queries

• Sub query Overview
• Using a Sub query
• Comparing several columns using Multiple-Column Sub queries
• Defining a Data source Using a Sub query in the FROM Clause
• Returning one Value using Scalar Sub query Expressions
• Performing ROW by-row processing with Correlated Sub queries
• Reusing query blocks using the WITH Clause

Regular Expression

• Describing simple and complex patterns for searching and manipulating data

[ back to top ]

Oracle10g™ OCP

Course Outline

1Z0-043 Oracle10g™ Database: Administration II ™

Using Globalization Support Objectives

• Customize language-dependent behavior for the database and individual sessions
• Specify different linguistic sorts for queries
• Use datatime datatypes
• Query data using case insensitive and accent insensitive searches
• Obtain Globalization support configuration information

Securing the Oracle Listener

• Secure the listener
• Remove default EXTPROC entry and add a separate listener to handle external procedure calls

Configuring Recovery Manager

• Configure database parameters that affect RMAN operations
• Change RMAN default settings with CONFIGURE
• Manage RMAN's persistent settings
• Start RMAN utility and allocate channels

Recovering from User Errors

• Recover a dropped table using Flashback technology
• Perform Flashback table operation
• Manage the recycle bin
• Recover from user errors using Flashback versions query
• Perform transaction level recovery using Flashback Transaction query

Dealing with Database Corruption

• Define block corruption and list its causes and symptoms
• Detect database corruptions using the following utilities: ANALYZE DBVERIFY
• Detect database corruptions using the dbms_repair package
• Implement the DB_BLOCK_CHECKING parameter to detect corruptions
• Repair corruptions using RMAN

Automatic Database Management

• Use the Database Advisors to gather information about your database
• Use the SQL Tuning Advisor to improve database performance
• Use automatic undo retention tuning

Using Recovery Manager

• Use the RMAN BACKUP command to create backup sets and image copies
• Enable block change tracking
• Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

Diagnostic Sources

• Use the alert log and database trace files for diagnostic purposes
• View alerts using Enterprise Manager
• Adjust thresholds for tracked metrics
• Control the size and location of trace files

Recovering from Non-Critical Losses

• Recover temporary tablespaces
• Recover a redo log group member
• Recover index tablespaces
• Recover read-only tablespaces
• Recreate the password file

Monitoring and Managing Storage

• Tune redo writing and archiving operations
• Issue statements that can be suspended upon encountering space condition errors
• Reduce space-related error conditions by proactively managing tablespace usage
• Reclaim wasted space from tables and indexes using the segment shrink functionality
• Estimate the size of new table and indexes
• Use different storage options to improve the performance of queries
• Rebuild indexes online

Automatic Storage Management

• Set up initialization parameter files for ASM and database instances
• Execute SQL commands with ASM file names
• Start up and shut down ASM instances
• Administer ASM disk groups
• Use RMAN to migrate your database to ASM

Monitoring and Managing Memory

• Implement Automatic Shared Memory Management
• Manually configure SGA parameters for various memory components in the SGA
• Use Automatic PGA Memory Management

Database Recovery

• Recover the control file
• Explain reasons for incomplete recovery
• Perform incomplete recovery using EM
• Perform incomplete recovery using RMAN
• Perform incomplete recovery using SQL
• Perform database recovery following a RESETLOGS operation

Flashback Database

• Determine which flashback technology to use for each recovery situation
• Configure and sue Flashback Database
• Monitor the Flashback Database
• Use the Enterprise Manager Recovery Wizard to flashback database
• Manage (or maintain) the Flash Recovery Area

Managing Resources

• Configure the Resource Manager
• Assign users to Resource Manager groups
• Create resource plans within groups
• Specify directives for allocating resources to consumer groups

Automating Tasks with the Scheduler

• Simplify management tasks by using the Scheduler
• Create a job, program, schedule, and window
• Reuse Scheduler components for similar tasks
• View information about job executions and job instances

[ back to top ]

Oracle Database 11g Upgrade

Course Outline

1Z0-050 Oracle Database 11g: New Features for Administrators

Oracle 11g Grid Infrastructure

• ASM File System
• ASM File System Snapshot
• ASM DiskGroups

Oracle 11g Installation

• Install Oracle 11g R2
• Upgrade Enhancements
• Online Patching

ASM Modifications

• ASM Fastmirror resync
• ASM Disk Group Compatibility
• ASM Performance Enhancements

Storage Enhancements

• Table Compressions
• SQL Access Advisor
• Segment Creation

Partitioning Enhancements

• Degree of Parallelism
• In Memory Parallel Query
• System Managed Indexes

Oracle SecureFiles

• Creating SecureFiles
• SecureFile Compression
• SecureFile Metadata
• Migrating SecureFiles

Security Changes

• SecurePassword
• Default Auditing
• Database Administrator Authentication
• Tablespace Encryption

Sql Performance Analyzer

• Sql Performance Analyzer Overview
• Using SQL Performance Analyzer
• Database Replay

Automatic Diagnostic Repositoty

• Using ADR
• SQL Health Checks
• SQL Monitoring
• Virtual Private Catalogs
• New Backup Compression
• Data Recovery Advisor

[ back to top ]

CED Solutions is not associated with or authorized by Oracle Corporation. Oracle is a registered trademark, and Oracle9i and Oracle10g are trademarks or registered trademarks of Oracle Corporation. The content of this website is the copyrighted property of CED Solutions, LLC.

MCSEClasses.com is your best choice for Oracle OCA, Oracle OCA training, Oracle OCA certification, Oracle OCA certification boot camp, Oracle OCA boot camp, Oracle OCA certification training, Oracle OCA boot camp training, Oracle OCA boot camp certification, Oracle OCA certification course, Oracle OCA course, training Oracle OCA, certification Oracle OCA, boot camp Oracle OCA, certification Oracle OCA boot camp, certification Oracle OCA training, boot camp Oracle OCA training, certification Oracle OCA course.

home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | alabama training solutions oracle® certification training | linux, unix | comptia certification | web development | pricing | locations | financing | instructors needed | e-mail us