QUICK TECHNOLOGY SERVICES

The Oracle Database 11g: New Features for Administrators (1Z0-050) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Database Specialization. This is an upgrade exam. Certification can only be achieved with this exam if the candidate already holds the 10g DBA OCP.

Recommended Training

Oracle Database 11g: New Features for Administrators - Exam Study Guide

Practice Exams

• Oracle authorized practice exam from Self Test Software: 1Z0-050 Oracle Database 11g New Features.

• Oracle authorized practice exam from Transcender Cert-1Z0-050 DBCert: Oracle 11g Database New Features.

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0

We know that the Oracle 1Z0-051 certification exam is challenging. Feel confident, hone your test-taking skills, and calm your exam fears with the 11g: SQL Fundamentals I practice exam. With three unique learning modes you can study the way that works best for you. Focus on specific objectives, take a timed exam, or drill flashcards on your way to certification success.

Candidates for the Oracle Database: 11g SQL Fundamentals I are expected to demonstrate proficiency in concepts of relational databases and the powerful SQL programming language.

Candidates will be tested on the following objectives:

• Retrieving data using the SQL SELECT statement

• Restricting and sorting data

• Using single-row functions to customize output

• Using conversion functions and conditional expressions

• Reporting aggregated data using the gropu functions

• Displaying data from multiple tables

• Using subqueries to solve queries

• Using the set operators

• Manipulating data

• Using DDL statements to create and manage tables

• Creating other schema objects

The Oracle 1Z0-052 practice exam is a simulation that mimics the format, content, and difficulty of the actual 10g: Administration I certification exam. Not only will this practice exam develop your test-taking skills and identify your weak areas, but it will significantly increase your chances of passing the actual certification exam.

Candidates for the Oracle Database: 11g: Administration I are expected to demonstrate proficiency in basic administration of Oracle Database 11g.

Candidates will be tested on the following objectives:

• Exploring the Oracle Database Architecture

• Preparing the Database Environment

• Creating an Oracle Database

• Managing the Oracle Instance

• Configuring the Oracle Network Environment

• Managing Database Storage Structures

• Administering User Security

• Managing Schema Objects

• Managing Data and Concurrency

• Managing Undo Data

• Implementing Oracle Database Security

• Database Maintenance

• Performance Management

• Intelligent Infrastructure Enhancements

• Backup and Recovery Concepts

• Performing Database Backups

• Performing Database Recovery

• Moving Data

The Oracle Database 11g Administrator II (1Z0-053) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Database Specialization.

Recommended Training

Oracle Database 11g Administrator II - Exam Study Guide

Practice Exams

Oracle authorized practice exam from Self Test Software: 1Z0-053 Oracle Database 11g: Administration II

Oracle authorized practice exam : Cert-1Z0-053 DBCert: Oracle Database 11g: Administration II

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0

Candidates will be tested on the following objectives:

•Database Architecture and ASM

•Configuring for Recoverability

•Using the RMAN Recovery Catalog

•Configuring Backup Specifications

•Using RMAN to Create Backups

•Performing User-Managed Backup and Recovery

•Using RMAN to Perform Recovery

•Using RMAN to Duplicate a Database

•Performing Tablespace Point-in-Time Recovery

•Monitoring and Tuning RMAN

•Using Flashback Technology

•Additional Flashback Operations

•Diagnosing the Database

•Managing Memory

•Managing Database Performance

•Space Management

•Managing Resources

•Automating Tasks with the Scheduler

•Administering the Scheduler

•Globalization

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

Learn To:

• Describe Oracle tuning methodology.

• Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.

• Use database advisors to correct performance problems proactively.

• Identify problem SQL statements & tune SQL performance problems.

• Monitor the Instance Performance using Enterprise Manager.

• Tune instance components, primarily using Instance parameters.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Course Methodology

The methodology used in the practices is primarily reactive. After configuring monitoring tools and reviewing the available reports, you'll be presented with the Oracle architecture based on the SQL statement processing of SELECT and DML.

SQL Tuning

The SQL tuning section assumes that the DBA has little or no ability to change the code. The DBA will influence the SQL performance with available tools, and will be introduced to various methods of identifying the SQL statements that require tuning (as well as the diagnostic tools needed to find ways to change the performance).

This will include the use of statistics, outlines and profiles to influence the optimizer, adding and rebuilding indexes and using the SQL Advisors. This course introduces the DB Replay and SQL Performance Analyzer tools to help you test and minimize the impact of change.

Instance Tuning

Instance tuning uses the same general method of observing a problem, diagnosing the problem and implementing a solution. The instance tuning lessons cover the details of major tunable components and describe how you can influence the instance behavior. For each lesson, we will examine the relevant components of the architecture.

The class only discusses the architecture to the level required to understand the symptoms and solutions. More detailed explanations are left to other courses, reference material and Oracle documentation.

Final Lessons

The last lesson of this course is a recap of the best practices discovered in the previous lessons, along with miscellaneous recommendations. The goal is to finish the course with a best practices list for students to take away.

The Oracle Database 11g: New Features for 9i OCPs (1Z0-055) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Database Specialization. This is an upgrade exam. Certification can only be achieved with this exam if the candidate already holds the 9i DBA OCP.

Recommended Training

Oracle Database 11g New Features for 9i OCPs - Exam Study Guide

Practice Exams

• Oracle authorized practice exam from Self Test Software: 1Z0-055 Oracle Database 11g: New Features for 9i OCPs

• Oracle authorized practice exam from Transcender: Cert-1Z0-055 DBCert: Oracle Database 11g: New Features for 9i OCPs

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.

The Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration (1Z0-058) exam is primarily intended for professionals who are skilled in Oracle Grid Infrastructure and RAC Administration. The successful candidate must be able to install and configure Grid Infrastructure. They will have proven skills in administering Oracle Clusterware, making applications highly available, using Automatic Storage Management (ASM) and ASM Cluster File System (ACFS). They will also be skilled in Real Application Cluster database installation, configuration, performance management, backup and recovery, and database services configuration.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Real Application Clusters Specialization.

Mandatory Training

Candidates who are not already certified as 11g DBA OCP must complete one of the online or in class instructor led courses below to obtain this certification. Candidates who already hold an 11g DBA OCP do not need to complete the training requirement.

Oracle Database 11g: RAC Administration (Release 2) OR

Oracle Database 11g: RAC Administration OR

Oracle 11g: RAC and Grid Foundation Administration OR

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2 OR

Oracle Grid Infrastructure 11g: Manage Clusterware and ASM OR

Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

Recommended Training

Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration - Exam Study Guide

No exam information for the specified page

The Oracle Certified Associate, Oracle WebLogic Server 11g System Administrator should have a firm grasp on the administrative tasks performed by a WebLogic Server 11g System Administrator, including installing and configuring Oracle WebLogic Server 11g, deploying Java EE applications to Oracle WebLogic Server 11g, and configuring Oracle HTTP Server as a Web proxy for Oracle WebLogic Server. OCAs certified as a WebLogic Server 11g System Administrator should also be able to configure Oracle WebLogic Server cluster to support failover and load balancing for applications.

Certification is obtained by passing the certification exam: 1Z0-102, Oracle WebLogic Server 11g: System Administration I.

Learn To:

• Describe the architecture of WebLogic Server including domains, servers and machines.

• Install, configure and use WebLogic Server.

• Perform routine Oracle WebLogic Server administration functions.

• Set up a cluster of servers and distribute applications and resources to the cluster.

• Configure Oracle HTTP Server as the Web-tier front end for Oracle WebLogic Server instances and clusters.

• Deploy different types of Java EE applications to Oracle WebLogic Server.

Benefits to You

Increase the performance and scalability of your organization’s applications and services with the #1 application server. Simplify deployment and significantly improve time-to-market.

Configure Oracle HTTP Server

You'll also learn to configure Oracle HTTP Server as the Web interface for Oracle WebLogic Server, along with supporting failover and load balancing for applications.

Overview of Administrative Tasks

This course provides an overview of the administrative tasks performed by a WebLogic Server administrator. At the end of the course, you will have gained knowledge at an associate level of competency.

Appendix

An appendix is included covering the differences between the 11g (10.3.3) and 12c (12.1.1) product versions with regard to Oracle WebLogic Server administration topics.

The follow up Oracle WebLogic Server 11g: Advanced Administration course provides a more in depth coverage of administration tasks.This course is an upgrade of Oracle WebLogic Server 10g R3: System Administration.

The 1Z0-144 exam is a part of Oracle's PL/SQL Developer Certified Associate certification which comprises of two exams. It is optional part to the certification.

The certification is targeted at entry-level developers who are involved in database-centric applications. The exam covers PL/SQL fundamentals, Declaration of Variables, Creating Functions, Procedures, Triggers, Working with Packages and more etc.

Step 1 - Pass this exam.

Pass one SQL Exam:

• Oracle Database 12c: SQL Fundamentals 1Z0-061 or

• Oracle Database 11g: SQL Fundamentals I 1Z0-051 or

• Oracle Database SQL Expert 1Z0-047

Step 2 - Pass this exam.

Pass One 'Program With PL/SQL' Exam:

• Oracle Database 11g: Program with PL/SQL 1Z0-144 or

• Program with PL/SQL 1Z0-147

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You'll learn how it interfaces with the database and other applications in the most efficient manner.

Learn To:

• PL/SQL designing best practices.

• Create PL/SQL applications that use collections.

• Implement a virtual private database with fine-grained access control.

• Write code to interface with external C and Java applications.

• Write code to interface with large objects and use SecureFile LOBs.

• Write and tune PL/SQL code effectively to maximize performance.

Benefits to You

Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

Virtual Private Database

You'll also be introduced to Virtual Private Database (VPD) to implement security policies. Learn techniques and tools to strengthen applications against SQL injection attacks. Explore programming efficiency, use of external C and Java routines, PL/SQL server pages and fine-grained access.

The audience for the Oracle IT Architecture Release 3 certification consists of enterprise architects, solution architects, and IT architects who guide the strategy, planning, and execution of architecture-centric transformations, programs, or projects.

The certification is best suited to architects with 2-5 years of relevant experience and an appropriate architect role in 3-5 implementations.

To assist Oracle customers with architecture-centric transformations/programs/projects Oracle has defined the Oracle Reference Architecture (ORA). ORA defines a reference architecture for building and integrating solutions based on Oracle technology. The reference architecture offers architecture principles and guidance based on recommendations from Oracle Product Development architects and field experts. It covers a broad spectrum of technology from virtualization to user interaction, security, and management. The Oracle Reference Architecture provides guidance on how to design solutions that best leverage the capabilities of the Oracle environment.

The Oracle Reference Architecture does not define an architecture development process and is intended to add value when used with any architecture development method. The appropriate application of the Oracle Reference Architecture should enable experienced architects to define their specific architectures more quickly, particularly when they have significant investment in Oracle technology.

This certification tests understanding of the core aspects of the Oracle Reference Architecture. (Oracle Reference Architecture Overview, Application Infrastructure, Security, Engineering, Integration, Management and Monitoring, Service Orientation, and User Interaction).

This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork.

OPN Members earning this certification will be recognized as OPN Certified Specialists, which helps their companies qualify for the Oracle IT Architecture Release 3 Specialization.