Oracle Database Documentation: Advanced Group

The advanced group manuals are intended for expert users who require more detailed information about a particular topic than can be provided by the 2 Day + manuals.

oracle siebel crm training courses malaysia

The following table lists essential reference manuals in the advanced group.

oracle peoplesoft training courses malaysia

Table 1-2 Essential Reference Manuals

ManualDescription
Oracle Database SQL Language ReferenceThis manual is the definitive source of information about Oracle SQL.
Oracle Database ReferenceThe manual is the definitive source of information about initialization parameters, data dictionary views, dynamic performance views, wait events, and background processes.

The advanced guides are too numerous to list in this section. The following table lists guides that the majority of expert Oracle DBAs use.

oracle linux administration training courses malaysia

Table 1-3 Advanced Group for DBAs

ManualDescription
Oracle Database Administrator’s GuideThis manual explains how to perform tasks such as creating and configuring databases, maintaining and monitoring databases, creating schema objects, scheduling jobs, and diagnosing problems.
Oracle Database Performance Tuning GuideThis manual describes how to use Oracle Database tools to optimize database performance. This guide also describes performance best practices for creating a database and includes performance-related reference information.
Oracle Database SQL Tuning GuideThis manual describes SQL processing, the optimizer, execution plans, SQL operators, optimizer statistics, application tracing, and SQL advisors.
Oracle Database Backup and Recovery User’s GuideThis manual explains how to back up, restore, and recover Oracle databases, perform maintenance on backups of database files, and transfer data between storage systems.
Oracle Real Application Clusters Administration and Deployment GuideThis manual explains how to install, configure, manage, and troubleshoot an Oracle RAC database.

The following table lists guides that the majority of expert Oracle developers use.

oracle e business suite training courses malaysia

Table 1-4 Advanced Group for Developers

ManualDescription
Oracle Database Development GuideThis manual explains how to develop applications or converting existing applications to run in the Oracle Database environment. The manual explains fundamentals of application design, and describes essential concepts for developing in SQL and PL/SQL.
Oracle Database PL/SQL Language ReferenceThis manual describes all aspects of the PL/SQL language, including data types, control statements, collections, triggers, packages, and error handling.
Oracle Database PL/SQL Packages and Types ReferenceThis manual is an API reference for the PL/SQL packages and types supplied with the Oracle database. Packages supplied with other products, such as Oracle Developer or the Oracle Application Server, are not covered.

Other advanced guides required by a particular user depend on the area of responsibility of this user.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *