Oracle 10g Database Administrator
Oracle 10g is recommended by Information Technology (IT) analysts and experts as a powerful tool for the complex data management tasks faced by today's IT professional. Oracle Database Administrator (DBA) leads the field in IT certifications. Certified DBAs are in high demand in the industry. Oracle DBAs work with the industry's most advanced information systems and command some of the highest salaries in IT.
This program consists of four parts. Lecture material is reinforced with hands-on practice. Hands-on workshops give you experience in a realistic technical environment.
Introduction to Oracle 10g: SQL
Both relational and object relational databases and Specific Query Language (SQL) are covered. You will learn how to create and maintain database objects and how to store, retrieve, and manipulate data. You will also learn how to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Also included: how to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output.
Preparation for Oracle Certified Associate Exam #1Z0-007.
Oracle 10g Database Administration: Fundamentals I
This unit is your first step towards success as an Oracle DBA. Designed to give you a firm foundation in basic database tasks, you will learn how to design, create, and maintain an Oracle database.
You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner.
Preparation for Oracle Certified Associate Exam #1Z0-031.
Oracle 10g Database Administration Fundamentals II
This unit covers several methods to backup and to recover an Oracle database. This material helps you develop skills for basic network administration and learn to simplify your duties using Oracle Recovery Manager.
This unit gives you a firm foundation in Oracle Net administration and backup and recovery operations. You will learn about transporting data between databases and the utilities used to perform these activities. You will also be introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, you will configure network parameters so that database clients and tools can communicate with the Oracle database server.
This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. You will also examine backup methodologies based on business requirements in a mission critical enterprise. You use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.
Preparation for Oracle Certified Professional Exam #1Z0-032.
Oracle 10g Database: Performance Tuning
Database performance tuning is critical to any effective information system. Reducing wait times, increasing users' productivity and maximizing the performance of your Oracle database are critical to success. You will learn the value of intelligent database design and methods for tuning an Oracle database for maximum performance. This course will introduce you to the importance of good initial database design, and the method used to tune a production Oracle database. The focus is on Database and Instance tuning rather than specific operating system performance issues. You will gain practical experience tuning an Oracle database. Using available Oracle tools, such as Oracle Enterprise Manager, you will also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.
Preparation for Oracle Certified Professional Exam #1Z0-033.
Oracle 10g DBA program consists of 81 hours of instructor-led and hands-on classes.
Who can attend this course?
This course is recommended for individuals who want to work as Database Administrators, Support and Implementation Specialists, Consultants and Network/ Systems Engineers.Some functional knowledge in Operating Systems is expected. Some programming skills can be beneficial, but is not necessary.
Oracle Certification begins with Associate level. To become Oracle Certified Associate, you must pass two tests, Introduction to Oracle 10g: SQL Exam 1Z0-007 and Oracle 10g Database Administration: Fundamentals I Exam 1Z0-031. Oracle Certified Professional is the next step and for this you must pass two tests, Oracle 10g Database Administration Fundamentals II Exam 1Z0-032 and Oracle 10g Database: Performance Tuning Exam 1Z0-033.
This certification qualifies one to take jobs such as Database Administrators, Support and Implementation Specialists, Consultants and Network/ Systems Engineers.