For the International exam IZO-053
Oracle Database 11g: SQL Fundamentals II Training Course Level: Intermediate
Who should do this course?
Qualification leads towards the OCP qualification.
•
Course pre-requisites?
•
Oracle SQL fundamentals I or Oracle Introduction to SQL
•
Anyone who would like to get to grips with Oracle databases Students who like to work in an Oracle environment or become a DBA Students wishing to get Oracle certification
Contact us on:
Frequently Asked Questions
[email protected] or +27 21 418 4874
Where do you train the Oracle course? We train the Oracle course at our Greenpoint training centre in Cape Town, South Africa.
How much does the Oracle course cost? The Oracle course fee is quoted in the currency of your country. Please contact us for the latest prices and special offers. The exam fees are not included in the course fee unless specifically stated. If you are from out of town, we can arrange accommodation close to our centre. Accommodation rates vary depending on the time of year. Included in your course fees: • • • • •
Tuition Breakfast and lunch on course days Teas and coffees Training Material Attendance certificate
What other branches do you have in SA or in the world? We only train in Cape Town. What books do I get with this course? You will receive a course text book which you can take away with you to keep after the course. What are the dates for the course? See our schedule page: http://www.i2ko.com/Schedule_All.html Does the price include the official exam? No, the exam is not included in the price. Exam prices vary from centre to centre. About the Oracle Exam The Oracle exams are done at any authorised testing centre such as 2KO. The exam is a multiple test, on computer at an authorised testy centre. The results are made known immediately. If you fail the test, you must book it again at a future date and will pay again.
Oracle Course Outline Networking Overview [ ] Explain solutions included with Oracle9i for managing complex networks [ ] Describe Oracle networking addon solutions
Configuring the Database Archiving Mode
User-Managed Incomplete Recovery
[ ] Describe the differences between Archivelog and Noarchivelog modes
[ ] Describe the steps of incomplete recovery
[ ] Configure a database for Archivelog mode
Basic Oracle Net Architecture
[ ] Enable automatic archiving
[ ] Explain the key components of the Oracle Net layered architecture
[ ] Perform manual archiving of logs
[ ] Explain Oracle Net Services role in client server connections
[ ] Configure multiple destinations, including remote destinations
[ ] Describe how web client connections are established through Oracle networking products
Oracle Recovery Manager Overview and Configuration
[ ] Configure multiple archive processes
[ ] Identify the features and components of RMAN
[ ] Perform an incomplete database recovery [ ] Identify the loss of current online redo log files RMAN Incomplete Recovery [ ] Perform an incomplete database recovery using UNTIL TIME [ ] Perform an incomplete database recovery using UNTIL SEQUENCE RMAN Maintenance [ ] Perform cross checking of backups
Basic Net Server-Side Configuration
[ ] Describe the RMAN repository and control file usage
[ ] Identify how the listener responds to incoming connections
[ ] Describe channel allocation
[ ] Update the repository when backups have been deleted
[ ] Describe the Media Management Library interface
[ ] Change the availability status of backups and copies
[ ] Connect to RMAN without the recovery catalog
[ ] Make a backup or copy exempt from the retention policy
[ ] Configure the RMAN environment
[ ] Catalog backups made with operating system commands
[ ] Configure the listener using Oracle Net Manager [ ] Control the listener using the Listener Control Utility (lsnrctl)
and copies
[ ] Describe Dynamic Service Registration
User-Managed Backups
[ ] Configure the listener for IIOP and HTTP connections
[ ] Describe user-managed backup and recovery operations
Recovery Catalog Creation and Maintenance
[ ] Discuss backup issues associated with read tablespaces
[ ] Describe the contents of the recovery catalog
[ ] Perform closed database backups
[ ] Create the recovery catalog
[ ] Perform open database backups
[ ] Maintain the recovery catalog by using RMAN commands
Basic Oracle Net Services ClientSide Configuration [ ] Describe the difference between host naming and local service name resolution [ ] Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names [ ] Perform simple connection troubleshooting Usage and Configuration of the Oracle Shared Server [ ] Identify the components of the Oracle Shared Server [ ] Describe the Oracle Shared Server architecture [ ] Configure the Oracle Shared Server [ ] Identify and explain usefulness of related dictionary views Backup and Recovery Overview [ ] Describe the basics of database backup, restore and recovery [ ] List the types of failure that may occur in an Oracle environment [ ] Define a backup and recovery strategy
[ ] Back up the control file [ ] Perform cleanup after a failed online backup
[ ] Use RMAN to register, resynchronize, and reset a database
[ ] Use the DBVERIFY utility to detect corruption
[ ] Query the recovery catalog to generate reports and lists
RMAN Backups [ ] Identify types of RMAN specific backups [ ] Use the RMAN BACKUP command to create sets [ ] Back up the control file [ ] Back up the archived redo log files [ ] Use the RMAN COPY command to create image copies
Transporting Data Between Databases [ ] Describe the uses of the Export and Import utilities [ ] Describe Export and Import concepts and structures [ ] Perform simple Export and Import operations
[ ] Perform recovery in Noarchivelog mode
[ ] List guidelines for using Export and Import
[ ] Perform complete recovery in Archivelog mode
Loading Data into a Database
[ ] Restore datafiles to different locations
[ ] Demonstrate usage of direct- load insert operations
[ ] Relocate and recover a tablespace by using archived redo log files
[ ] Describe the usage of SQL*Loader
Instance and Media Recovery Structures [ ] Describe the Oracle processes, memory structures, and files relating to recovery
RMAN Complete Recovery
[ ] Describe ways to tune instance recovery
[ ] Describe methods for backing up and recovering the recovery catalog
[ ] Describe media recovery
User-Managed Complete Recovery
[ ] Describe read-only tablespace recovery
[ ] Identify the importance of checkpoints, redo log files, and archived log files
[ ] Create, store, and run scripts
[ ] Describe the use of RMAN for restoration and recovery [ ] Perform recovery in Noarchivelog mode [ ] Perform complete recovery in Archivelog mode [ ] Restore data files to different locations [ ] Reloate and recover a tablespace by using archived redo log files
[ ] Perform basic SQL*Loader operations [ ] List guidelines for using SQL*Loader and direct-load insert
