Oracle10g OCP Completion Certification Boot Camp

CED Solutions
Marietta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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
...''

Phone:(770) 937-0140

School Address:

CED Solutions
1640 Powers Ferry Road
Building 5, Suite 100
Marietta, GA 30067


Jobs & Resumes: Marietta
Houses & Roommates: Marietta

Computer Hacking Forensic Investigator
BizTalk Server 2006
Vista/Exchange Server 2007 Certification Boot Camp
Excel 2007
Microsoft Office Specialist 2003 Certification Boot Camp
PowerPoint 2007
Project 2003
Word 2007
Oracle10g DBA Certification Boot Camp
Oracle10g OCA Certification Boot Camp
PMP Certification Boot Camp
Project Management
Crystal Reports
Cisco CCSP Certification Boot Camp
SCNA Certification Bootcamp
SCNP Certification Bootcamp
SCNS Certification Boot Camp
ASP
Cascading Style Sheets

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.