Oracle 10g DBA Upgrade Certification for an Oracle 9i DBA
| Course Length: |
11 days |
| Certifications: |
OCA
Oracle 10g SQL Expert
OCP |
| Number of Exams: |
3 |
|
|
- Includes roundtrip airfare from the UK and lodging!
- Hands-on instruction by a certified instructor
- Includes all course materials and practice exams
- Includes all certification exams (with extra test vouchers, if needed)
- Onsite Testing
- Breakfast and Lunch provided each day
If airfare and lodging are not required, the price is £575 less for 2-week courses, and £285 less for one week courses.
|
To qualify for this course, students must have completed the Oracle 9i OCP requirement at Oracle University.
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.
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.
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.
To qualify for OCP Certification, students must complete the Oracle OCP Hands on Requirement at Oracle University. This is not required for any student currently holding a DBA certification at the 9i or 10g level.
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 ]
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 Upgrade,
Oracle Upgrade training,
Oracle Upgrade certification,
Oracle Upgrade certification boot camp,
Oracle Upgrade boot camp,
Oracle Upgrade certification training,
Oracle Upgrade boot camp training,
Oracle Upgrade boot camp certification,
Oracle Upgrade certification course,
Oracle Upgrade course,
training Oracle Upgrade,
certification Oracle Upgrade,
boot camp Oracle Upgrade,
certification Oracle Upgrade boot camp,
certification Oracle Upgrade training,
boot camp Oracle Upgrade training,
certification Oracle Upgrade course.
|
