 |
 |
 |
|
 |
 |
 |
 |
 |
 |
 |
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
|
|
|
 |
 |
 |
 |
 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
| |
Oracle Database Administrator
The Oracle Certified Professional (OCP) Program helps the IT industry make the distinction by establishing a standard of competence in specific job roles. An Oracle Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and ability.
There are 2 specific training and certification programs offered by CyberNetworks with respect to Oracle:
- OCP Database Administrator.
- OCP Application Developer.
OCP
Database Administrator tasks:
A database
administrator's responsibilities generally include but are not limited
to the following:
- Installing and upgrading the Oracle server and application tools
- Allocating system storage and planning future storage requirements for the database system.
- Creating primary database storage structures (tablespaces) after application developers have designed an application.
- Creating primary objects (tables, views, indexes) once application developers have designed an application.
- Modifying the database structure, as necessary, from information given by application developers.
- Enrolling users and maintaining system security.
- Ensuring compliance with your Oracle license agreement.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Planning for backup and recovery of database information.
- Maintaining archived data on tape.
- Backing up and restoring the database.
- Contacting Oracle Corporation for technical support.
Courses
delivered:
The courses taught at CyberNetworks that lead to the Oracle OCP
Application Developer Certification include:
Introduction to Oracle: SQL and PL/SQL (35 hours)
What you will learn:
This course offers students an extensive introduction to data server technology. The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts.
Audience:
Technical
Support Professionals
Database Administrators
System Analysts
Applications Developer
Prerequisites:
-
Familiarity with data processing concepts and techniques
-
Ability to use a graphical user interface (GUI)
Course Topics:
1. Introduction
2. Writing a Basic SQL Statement
3. Restricting and Sorting Data
4. Single Row Functions
5. Displaying Data from Multiple Tables
6. Writing Subqueries
7. Producing Readable Output with iSQL*Plus
8. Manipulating Data
9. Creating and Managing Tables
10. Including Constraints
11. Describing Constraints
12. Creating and Maintaining Constraints
13. Creating Views
14. SQL Workshop
15. Using Set Operators
16. Oracle9i Single Row Functions
17. Enhancements to the GROUP BY Clause
18. Advanced Subqueries
19. Hierarchical Retrieval
20. Extensions to DDL and DML Statements
21. Writing Scripts to Generate Scripts
Certification Benefits to the Technical Professional:
- 97% said they have benefited from certification and are technically more competent.
- 89% said they gained more confidence in their Oracle expertise after becoming certified.
- 96% would recommend the program to a professional colleague.
Certification Benefits to the Employer:
The Oracle Certified Professional Program is also valuable to hiring managers who want to distinguish among candidates for critical IT positions. For companies that send employees through annual IT training, certification ensures a return on the training investment by validating the knowledge and understanding gained in training sessions.
Companies can also combine certification with an employee development program to enhance employee loyalty and performance on the job. Hiring certified professionals has a direct impact on a company’s bottom line, as these conclusions from a research study by International Data Corporation suggest:
- Certified professionals handled 40% more support calls per person, per day, than uncertified staff.
- Companies that advocated certification reported 49% less downtime than those that did not.
For the majority of companies surveyed, the savings from increased effectiveness paid the costs of certification in fewer than nine months.
Oracle
9i Database Administration Fundamentals I.
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you'll learn how to design, create, and maintain an Oracle database.
Students will gain a conceptual understanding of the Oracle9i database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner.
The instructor-led lesson topics are reinforced with structured hands-on practices.
Audience:
-
Technical Support Professionals
Database Administrators
System Administrators
Prerequisites:
-
Introduction to Oracle9i: SQL
Course Topics:
1. Oracle
Architectural Components
2. Getting Started with the Oracle Server
3. Defining the Optimal Flexible Architecture
4. Creating a database during installation
5. Creating a new database
6. Identifying database administrative users
7. Managing an Oracle Instance
8. Creating a Database
9. Using the Data Dictionary
10. Maintaining the Control File
11. Maintaining Redo Log Files
12. Managing Tablespaces and Datafiles
13. Describing storage hierarchy
14. Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
15. Storage Structures and Relationships
16. Managing Undo Data
17. Managing Tables
18. Managing Indexes
19. Maintaining Data Integrity
20. Managing Password Security and Resources
21. Managing Users
Oracle 9i Database Administration Fundamentals II.
This class will cover Oracle9i and Oracle9i Release 2 features. Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database. Hands-on workshops give you experience in a realistic technical environment. Develop skills for basic network administration. Simplify your duties with Oracle Recovery Manager.
Audience:
Database Administrators
Prerequisites:
Oracle9i Database Administration Fundamentals 1
Course Topics:
1. Networking
Overview
2. Basic Oracle Net Architecture
3. Basic Oracle Net Services Server-Side Configuration
4. Basic Oracle Net Services Client-Side Configuration
5. Usage and Configuration of the Oracle Shared Server
6. Backup and Recovery Overview
7. Instance and Media Recovery Structures
8. Configuration of the Database Archiving Mode
9. Oracle Recovery Manager (RMAN) Overview and Configuration
10. User-Managed Backups
11. RMAN Backups
12. User-Managed Complete Recovery
13. RMAN Complete Recovery
14. User-Managed Incomplete Recovery
15. RMAN Incomplete Recovery
16. RMAN Repository Maintenance
17. RMAN Catalog Creation and Usage
18. Transporting Data Between Databases
19. Backup and Recovery and Networking Workshop
Oracle 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. This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database.
Audience:
-
Database Administrators
Prerequisites:
-
Oracle9i Database Administration Fundamentals II
-
Oracle9i Database Administration Fundamentals 1
-
Introduction to Oracle9i: SQL
Course Topics:
1. Overview
of Oracle 9i Performance Tuning
2. Diagnostic and Tuning Tools
3. Sizing the Shared Pool
4. Sizing the Buffer Cache
5. Sizing other SGA Structures
6. Database Configuration and I/O Issues
7. Optimize Sort Operations
8. Diagnosing Contention For Latches
9. Tuning Rollback (or UNDO) Segments
10. Monitoring and Detecting Lock Contention
11. Tuning Oracle Shared Server
12. Application Tuning
13. Using Oracle Blocks Efficiently
14. SQL Statement Tuning
15. Tuning the Operating System and Using Resource Manager
16. Workshop
Copyright
© 2006 Cyber Networks (ICT) Ltd. All Rights Reserved.
Cyber Technologies and the Cyber logo are registered trademarks of Cyber
Networks (ICT) Ltd. All brand names mentioned herein are used for identification
purposes only and are trademarks of their respective organizations.