Oracle KnowledgeCenter Certification Training Course for OCA OCP 10G and 11G Database Administrators
What is Oracle KnowledgeCenter
Our Oracle KnowledgeCenter is a pre-packaged, user-friendly learning portal that allows learners instant access to trusted,
targeted content. Each KnowledgeCenter includes material specifically chosen to help learners build knowledge around a topic
as quickly and efficiently as possible. Assets include Books24x7 Referenceware; access to our courseware organized into
Learning Roadmaps that make it easy for learners to locate and use the most appropriate courses for their needs, simulations
(through SkillSims, practice labs, or the Project Center), expert mentoring services (for IT KnowledgeCenters and the PMI
KnowledgeCenter); and featured topic spotlights, refreshed regularly, to provide an in-depth focus on particular topical areas.
KnowledgeCenters make it fast and easy for learners to locate and take advantage of essential topic-oriented content. The more
efficiently learners can access the information they need, the faster they can apply that knowledge to their jobs
Oracle Certification Training KnowledgeCenter Includes
.
|
Oracle KnowledgeCenter Online Training
One Year Access
|
skorackn
|
$825.00
|
|
|
Oracle Courses Include
Oracle 10G Courses
New Features for Administrators Oracle 10G
New Installation and Configuration Features
New Data Loading Features
New Automatic Management and Management Infrastructure Features
New Resource, Scheduling, and Task-Management Features
New Space Management Features
New Storage Features
New Tuning, Performance-monitoring, and Analysis Features
New Backup and Recovery Features
Using Flashback
New Features in Security and Software Maintenance
New Features in VLDB Support
Miscellaneous New Features
Administration Workshop I Release 2 Oracle 10G
Installing Oracle Database 10g Release 2
Creating Databases Release 2
Database Interfaces Release 2
Database Control and Storage Structures Release 2
Users and Security Release 2
Managing Schema Objects and Data Release 2
The SQL*Loader and PL/SQL Release 2
Oracle Net Services and Shared Servers Release 2
Monitoring and Maintenance Release 2
Managing Undo Data and Lock Conflicts Release 2
Managing Backup and Recovery Release 2
Administration Workshop II Oracle 10G
Using Flashback Technology
Performing and Managing Backups
Advanced Database Recovery and Repair
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
Using Globalization Support in Oracle 10g
Optimizing Database Performance
Managing Storage and System Resources in Oracle 10g
Using the Scheduler to Automate Tasks in Oracle 10g
Using Advanced Features in Oracle 10g
SQL Fundamentals I and II
Introduction to Oracle and SQL
SQL Functions
Displaying Multiple Table Data and Using Set Operators
Group and Datetime Functions
Subqueries and Hierarchical Queries
Regular Expressions and User Access
Creating and Managing Tables and Constraints
Database Objects
Managing Database Objects
Manipulating Data
PL/SQL Fundamentals
Introduction to PL/SQL
Using PL/SQL with an Oracle Server
Using Control Structures
Using Composite Data Types
Explicit Cursors and Exception Errors
Creating Stored Procedures and Functions
Developing PL/SQL Program Units
PL/SQL Packages
Oracle-Supplied Packages and DBMS_SCHEDULER
Managing Dependencies
Manipulating Large Objects in PL/SQL
PL/SQL Triggers
Dynamic SQL and Metadata
Oracle Application Server 10g: Administration I
Introduction
Infrastructure and Middle Tier Installation
Management Tools and Oracle Internet Directory
General Management and Directives for the HTTP Server
OracleAS Web Cache
OracleAS Portal
mod_plsql, CGI Scripts, and Database Providers
Application Management and Deployment
Component Administration in Oracle Internet Directory
DAS and SSO
Component Security with SSL
Oracle Certificate Authority Management
Oracle Application Server 10g: Administration II
Managing Customized Topologies and Distributing Infrastructure Components
OracleAS 10g: High Availability
Managing and Configuring Clusters
Business Intelligence Component Management
XML Applications, Web Services, and Monitoring
Tuning and Reconfiguring the Middle Tier
Backup and Recovery
Oracle 11g and 11i Training Courses Online
Oracle Database 11g: SQL Fundamentals I
Using SQL to Query Your Database
Conversion Functions, Group Functions, and Joins
Subqueries, Set Operators, and Data Manipulation
Using DDL, Views, Sequences, Indexes, and Synonyms
Oracle Database 11g: SQL Fundamentals II
Controlling User Access and Managing Schema Objects
Data Dictionary view and Large Data Sets
Managing Data in Different Time Zones
Using Subqueries and Regular Expressions
Oracle Database 11g: PL/SQL Fundamentals
PL/SQL Variables, Attributes, and Executable Statements
Using DML, DDL, Cursors, Control Structures, and Loops
Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
Developing Program Units
Subprograms, Packages, and Exception Handling in PL/SQL
Packages, Dynamic SQL, and Coding Considerations in PL/SQL
Using Triggers, the PL/SQL Compiler, and Managing Code
Managing PL/SQL Code and Dependencies
Oracle Database 11g: Program with PL/SQL
Getting Started With PL/SQL
Using DML, DDL, Cursors, Loops, and Control Structures
Using Data Types, INDEX BY Tables, and Cursors
Using Exceptions, Subprograms, JDeveloper, and REF Cursors
Subprograms, Packages, and Exception Handling
Packages, Dynamic SQL, and Coding Considerations
Using Triggers and the PL/SQL Compiler
PL/SQL Code and Dependency Management
1Z0-001 Oracle Database 11g: SQL and PL/SQL New Features
Getting Started with SQL and PL/SQL New Features
Using Trigger, Data Warehousing, and Pivoting Enhancements
Using the PL/SQL Debugger, Collections and Data Warehousing
Introduction to SQL
Querying a Database with SQL
Conversion Functions, Conditional Expressions, Group Functions, and Joins
Manipulating Queries and Data
Using DDL, Views, and Schema Objects
Controlling User Access and Managing Objects
Managing Data Dictionary Views and Large Data Sets
Managing Time Zones and Datetime Functions
Subqueries and Regular Expressions
Oracle Database 11g: Performance Tuning
Performance Tuning Methodology and Tools
Using AWR and Defining Problems
SQL Performance Management and Database Replay
Metrics, Alerts, Baselines, AWR Tools and Services
Problem SQL Statements and Oracle Optimizer
Shared Pool and Buffer Cache Tuning
Tuning PGA, Temporary Space, and Automatic Memory Management
Segment Space, I/O and Performance Tuning
Oracle Database 11g: SQL Tuning
Architecture, SQL Tuning, and Optimization
Indexes, Access Paths, and Join Operations
Execution Plans and Star Transformations
Optimizer Statistics, Hints, and Cursor Sharing
Application Tracing and Automatic SQL Tuning
Oracle Database 11g: RAC Administration
Installation of Clusterware and RAC
RAC Database and Oracle Clusterware Administration
RAC Performance Tuning
Configure, Manage, and Use Services in RAC
Diagnosing Oracle Clusterware and Node Management
High Availability in RAC
Oracle Database 11g: Secure Backup
Configuring OSB and Security
Securing Domain and Data in Oracle Secure Backup
RMAN and Oracle Secure Backup
Managing Backups and Infrastructure
Tape Vaulting, Duplication, and Tuning
Oracle Database 11g: Security
Introduction to Database Security and Solutions
Database Security
Database Auditing
Basic User and Strong Authentication
Enterprise User Security and Proxy Authentication
Privileges, Roles, and Application Contexts
Virtual Private Database
Oracle Label Security and the Data Masking Pack
Encryption Concepts
Transparent Data Encryption
Oracle Net Services and Listener Security
Firewalls, Oracle Connection Manager, and SQL*Plus
Oracle 11i Training Courses Online
Oracle 11i E-Business Suite: Essentials for Implementers
Introduction
Multi-Org
Flexfields
System Administration
Workflow, Alerts, and Daily Business Intelligence
Oracle 11i E-Business Suite: System Administrator Fundamentals
Function Security and Data Security
Roles, Delegated Administration, Registration, and Auditing
Concurrent Elements
Profile Options, DBA Duties, and Printer Management
Personalization of Forms and OA Framework Pages
Oracle Workflow
System Monitoring and Troubleshooting in OAM
Oracle 11i: Project Foundation Fundamentals
Project Management and Projects Integration
Organization, Period, and Calendar Definitions in Oracle Projects
Resource and Role Management
Oracle Projects Security Model and Page Layouts
Oracle Projects and Task Definition I
Oracle Projects and Task Definition II
User-Defined Attributes, Implementation Options, and Utilization
Organization Forecasting and Integration
Oracle 11g Certification Tracks Training Courses
1Z0-052 Oracle Database 11g: Administration Workshop I
Database Architecture and Installation
Database Creation, Instance Management, and Connectivity
Storage Structures and User Security
Managing the Schema, Data, and Concurrency
Managing Undo Data, Database Security, and Maintenance
Performance Monitoring, Recovery Concepts and Backup
Recovering, Moving, and Enhancing the Oracle Database
1Z0-053 Oracle Database 11g: Administration Workshop II
Database Architecture and ASM
Configuring for Recovery
Configuring for Backups
Using RMAN for Recovery
Supporting RMAN and Using Flashback Technology
Diagnosing the Database and Managing Memory
Database Performance and Space Management
Managing Resources and Task Automation
Globalization
1Z0-050 Oracle Database 11g: New Features For Administrators
Installation and Upgrade Enhancements
Storage Enhancements
Change Management Overview and SQL Plan Management
Database Replay and Automatic SQL Tuning
Intelligent Infrastructure Enhancements
Performance Enhancements
Partitioning and Storage-Related Enhancements
Using RMAN Enhancements, Flashback and LogMiner
Diagnostic Enhancements and Using the Data Recovery Advisor
New Security Features
SecureFiles and Miscellaneous New Features
1Z0-051 ORACLE DATABASE 11G: SQL FUNDAMENTALS I
Querying a Database with SQL
Conversion Functions, Conditional Expressions, Group Functions, and Joins
Manipulating Queries and Data
Using DDL, Views, and Schema Objects
Controlling User Access and Managing Objects
Managing Data Dictionary Views and Large Data Sets
Managing Time Zones and Datetime Functions
1Z0-047 Oracle Database 11g: SQL Expert I
Using SQL to Query Your Database
Conversion Functions, Group Functions, and Joins
Subqueries, Set Operators, and Data Manipulation
Using DDL, Views, Sequences, Indexes, and Synonyms
Controlling User Access and Managing Schema Objects
Data Dictionary view and Large Data Sets
Managing Data in Different Time Zones
Using Subqueries and Regular Expressions
1Z0-040 New Features for Administrators
New Installation and Configuration Features
New Data Loading Features
New Automatic Management and Management Infrastructure Features
New Resource, Scheduling, and Task-Management Features
New Space Management Features
New Storage Features
New Tuning, Performance-monitoring, and Analysis Features
New Backup and Recovery Features
Using Flashback
New Features in Security and Software Maintenance
New Features in VLDB Support
Miscellaneous New Features
1Z0-042 Administration I
Installing Oracle Database 10g Release 2
Creating Databases Release 2
Database Interfaces Release 2
Database Control and Storage Structures Release 2
Users and Security Release 2
Managing Schema Objects and Data Release 2
The SQL*Loader and PL/SQL Release 2
Oracle Net Services and Shared Servers Release 2
Monitoring and Maintenance Release 2
Managing Undo Data and Lock Conflicts Release 2
Managing Backup and Recovery Release 2
1Z0-043 Administration II
Using Flashback Technology in Oracle 10g
Performing and Managing Backups in Oracle 10g
Advanced Database Recovery and Repair in Oracle 10g
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
Using Globalization Support in Oracle 10g
Optimizing Database Performance in Oracle 10g
Managing Storage and System Resources in Oracle 10g
Using the Scheduler to Automate Tasks in Oracle 10g
Using Advanced Features in Oracle 10g
1Z0-101 Introduction to PL/SQL
Using PL/SQL with an Oracle Server
Using Control Structures
Using Composite Data Types
Explicit Cursors and Exception Errors
Creating Stored Procedures and Functions
PL/SQL Packages
Oracle-Supplied Packages and DBMS_SCHEDULER
Dynamic SQL and Metadata
Managing Dependencies
Manipulating Large Objects in PL/SQL
PL/SQL Triggers
1Z0-311 Oracle Application Server 10G
Introduction
Infrastructure and Middle Tier Installation
Management Tools and Oracle Internet Directory
General Management and Directives for the HTTP Server
OracleAS Web Cache
OracleAS Portal
mod_plsql, CGI Scripts, and Database Providers
Application Management and Deployment
Component Administration in Oracle Internet Directory
DAS and SSO
Component Security with SSL
Oracle Certificate Authority Management
1Z0-007 Introduction to Oracle and SQL in Oracle 9i
SQL Functions in Oracle 9i
Subqueries, Reporting, and User-Access Control in Oracle 9i
Defining and Manipulating Data in Oracle 9i
Online Books
Apress Expert Oracle Database 10g Administration
Apress Mastering Oracle PL/SQL: Practical Solutions
Apress Oracle Application Server 10g: J2EE Deployment and Administration
Auerbach Publications Oracle 11i E-Business Suite From the Front Lines
Digital Press Oracle High Performance Tuning for 9i and 10g
John Wiley & Sons Oracle9i Administration and Management
John Wiley & Sons Project Management Methodologies: Selecting. Implementing. and Supporting Methodologies and
Processes for Projects
John Wiley & Sons SQL Bible
Oracle Press Oracle Database 11g DBA Handbook
Oracle Press Oracle Database 11g New Features
Oracle Press Oracle Database 11g SQL
Sybex OCA/OCP: Introduction to Oracle9i SQL Study Guide
Sybex OCA/OCP: Oracle9i DBA Fundamentals I Study Guide
Sybex OCA: Oracle 10g Administration I Study Guide (Exam 1Z0-042)
Sybex OCP: Oracle 10g Administration II Study Guide (1Z0-043)
Sybex OCP: Oracle 10g New Features for Administrators Study Guide (Exam 1Z0-040)
Sybex OCP: Oracle9i DBA Fundamentals II Study Guide
Sybex OCP: Oracle9i Performance Tuning Study Guide
Wordware Publishing Advanced SQL Functions in Oracle 10g
Wrox Press SQL Functions Programmer's Reference
|
Full Library of Oracle Certification courses for both 10G, 11g and 11i. Over 30 courses
Online Labs
Printable transcripts of all lessons for easy review
Online Mentoring to Instructors 24 x 7 to answer all questions
Test Preps to test your readiness for the certification exam
Complete library of Oracle Books online and searchable.
