Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help
Search Results for: ((PUBLID = 199))

Show:


1. 

Oracle Database & Data Warehouse 11g R2: Performance Assessment

Oracle Database & Data Warehouse 11g R2: Performance Assessment

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 01-NOV-2012

Insert Date: 01-APR-2013

Slots: 1.0

Table of Contents • Start Reading

This textbook is the first volume of a two-volume set devoted to the subject of Oracle database server and Oracle data warehouse performance tuning. This first volume provides crucial background information about database performance statistics, metrics and baselines. An enormous amount of performance data is generated and presented by the self-monitoring Oracle database, but the meaning and usefulness of the data is not always obvious. Common questions are: What exactly should I be looking for in amongst all this data? What is the meaning of the performance statistics presented? What...

2. 

Oracle BI 11g: Create Analyses & Dashboards

Oracle BI 11g: Create Analyses & Dashboards

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 26-JUN-2012

Insert Date: 12-SEP-2012

Slots: 1.0

Table of Contents • Start Reading

This textbook offers an exhaustive, step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. One will learn the concepts, methods and techniques for building sophisticated data analytic modules. Analytic results are then organized into interactive dashboards. A solid foundation is laid for one to progress onto the latest and most advanced data analytic capabilities. The following specific topics are included in this guide book: Background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that...

3. 

Oracle Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation

Oracle Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 19-JUN-2012

Insert Date: 09-SEP-2012

Slots: 1.0

Table of Contents • Start Reading

This textbook will assist you in learning and using one of the most exciting software environments available today, namely the Oracle BI Enterprise Edition data analytics suite and the Oracle Fusion Middleware WebLogic Server. Within this textbook you will learn: About the architecture and internal components of the Oracle Business Intelligence (BI) Enterprise Edition (EE) data analytics suite (OBIEE); Important concepts regarding the Oracle WebLogic Server application server middleware platform, the platform to which the Oracle BI suite is deployed; This textbook will guide you through...

4. 

Data Modeling: Logical Database Design

Data Modeling: Logical Database Design

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 15-JUL-2011

Insert Date: 05-APR-2012

Slots: 1.0

Table of Contents • Start Reading

This guidebook, and its companion volume which follows, provide a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and...

5. 

Oracle Database 11g R2: Step-By-Step Installation Guide

Oracle Database 11g R2: Step-By-Step Installation Guide

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 08-JUN-2011

Insert Date: 05-APR-2012

Slots: 1.0

Table of Contents • Start Reading

A major prerequisite for the usage and deployment of Oracle database technology is a successful installation. The purpose of this Oracle 11g training course module is to offer a step-by-step guide for the configuration of a Linux or Microsoft Windows server to host an Oracle database Enterprise Edition installation. Especially in a Linux environment installation of the database requires careful preparation, configuration and sometimes troubleshooting in order to succeed. This course includes practical tips learned from many real-world installations which can assist you to achieve a...

6. 

Oracle Database 11g R2: Administration I

Oracle Database 11g R2: Administration I

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 01-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are: Startup and shutdown of database services and related software components; Super administrator authentication options; Management of database files; Specialized facilities intended to maximize performance of enterprise-scale...

7. 

Oracle Database 11g R2: Architecture & Internals

Oracle Database 11g R2: Architecture & Internals

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

Success in database administration and tuning, or in the development of database applications, depends upon having a sufficient understanding of the architecture and internal mechanisms which operate within the database. Without such an understanding, one could implement such things as structural changes, performance tuning adjustments and other modifications to the environment which could actually be counterproductive. The purpose of this unique and popular Oracle 11g training course is to reveal the underlying architecture of the Oracle database environment. This course is also intended...

8. 

Oracle Database 11g R2: Grid Infrastructure & ASM

Oracle Database 11g R2: Grid Infrastructure & ASM

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

This Oracle 11g training course provides a step-by-step guide for configuring and using the Oracle Grid Infrastructure in a single server environment, and it forms the basis for expanding this infrastructure to a clustered server configuration. Advanced database and storage administration tasks are considered, including Oracle Restart and Automatic Storage Management (ASM). With this course you will learn about: Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations; Preparing a host system for ASM storage management;...

9. 

Oracle Database 11g R2: Encryption & Advanced Data Security

Oracle Database 11g R2: Encryption & Advanced Data Security

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

Threats to data security abound and are increasing in sophistication and frequency. Organizations have both an ethical and oftentimes a legal responsibility to understand the countermeasures available, to compare these against those threats to which they are exposed, and to properly apply such countermeasures. This Oracle 11g training course module considers how encryption technology should, and should not, be employed within an Oracle database environment in response to known threats and risks. It will also discuss other best security practices which pertain to application security, host...

10. 

Oracle Database 11g R2: Resource Manager & Scheduler

Oracle Database 11g R2: Resource Manager & Scheduler

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented. The objective of this Oracle 11g training module is to introduce advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration...

11. 

Oracle Database 11g R2: Advanced Administration

Oracle Database 11g R2: Advanced Administration

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

The overall objective of this Oracle 11g training module is to bring database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Among the topics covered are: Automatic database management, monitoring and tuning facilities. Included are automatic...

12. 

Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

The PL/SQL programming language is at the core of most Oracle database applications. This training course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. First, we will explore the advanced features of the language which allow powerful and adaptable database applications to be built. Next, we will discuss performance tuning techniques which allows these applications to run efficiently. Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats. Among the specific...

13. 

Oracle Database 11g R2: PL/SQL Fundamentals II – Develop Program Units

Oracle Database 11g R2: PL/SQL Fundamentals II – Develop Program Units

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

The objective of this Oracle 11g course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Major subject areas to be explored and secondary objectives are: Understanding application partitioning within a multi-tiered web-based systems architecture; Understanding the basic form and structure of program units stored within the database; Building and maintaining database-resident program units; Encapsulating program units within packages; Taking advantage of advanced programming techniques such as cursor variables and cursor expressions for...

14. 

Oracle Database 11g R2: New & Advanced Features For Developers

Oracle Database 11g R2: New & Advanced Features For Developers

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 09-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

The purpose of this Oracle 11g course is to present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle 11g R1 or R2 release or have been substantially improved in these new versions. Such advanced features include online application redefinition using Editions, employing the full range of index types to achieve maximum performance, and advanced SQL query techniques. Among the specific subjects presented in this course are: Perform online redefinition of database-resident applications using Edition-based...

15. 

Oracle Database 11g R2: PL/SQL Fundamentals I

Oracle Database 11g R2: PL/SQL Fundamentals I

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 02-MAY-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. Major subject areas to be explored within this course book are: Understand the environment and context in which PL/SQL operates; Consider the advantages and benefits of PL/SQL within a database environment; Declaring program variables and complex data types; Developing logic...

16. 

Oracle Database 11g R2: SQL Fundamentals I

Oracle Database 11g R2: SQL Fundamentals I

By: Sideris Courseware Corp.

Publisher: Sideris Courseware Corp.

Publication Date: 02-MAY-2011

Insert Date: 23-JUN-2011

Slots: 1.0

Table of Contents • Start Reading

The SQL database language is the foundation of all relational database activities. This training course is intended to provide an introduction to SQL within the context of an Oracle database. Since the language is an industry standard, much of the course contents are also applicable to other databases, such as MS SQL Server, IBM DB2, MySQL, PostgreSQL, and others. This guide takes a unique approach to learning the language, in that it combines the data modeling theory, graphical illustrations of the logical concepts and many examples of actual syntax to help one truly grasp the power of...

17. 

Oracle Database 11g R2: SQL Fundamentals II

Oracle Database 11g R2: SQL Fundamentals II

By: Sideris Courseware Corp.

Publisher: Sideris Courseware Corp.

Publication Date: 02-MAY-2011

Insert Date: 10-JUN-2011

Slots: 1.0

Table of Contents • Start Reading

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and expanded revision includes many new and expanded conceptual subjects, including: Learn to use the SQL99 join syntax and learn about the full range of join operations available, such as natural...

18. 

Oracle Database 11g R2: SQL Tuning

Oracle Database 11g R2: SQL Tuning

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 15-APR-2011

Insert Date: 07-APR-2012

Slots: 1.0

Table of Contents • Start Reading

This Oracle 11g learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behavior of the database to achieve performance gains. This textbook is a mandatory reference for any database administrator or SQL...

19. 

Oracle Database 11g R2: RMAN Backup & Recovery

Oracle Database 11g R2: RMAN Backup & Recovery

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 01-APR-2011

Insert Date: 28-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this Oracle 11g training module is to assist you in doing just that. Furthermore, when a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The focus of this course is the Oracle Recovery Manager (RMAN) tool. Additional facilities covered include the Data Recovery Advisor, Redo Log File Size Advisor and MTTR Advisor. It is tempting to short-cut appropriate backup procedures if they perform...

20. 

Oracle Database 11g R1 & R2: New Features for Administrators – Volume B

Oracle Database 11g R1 & R2: New Features for Administrators – Volume B

By: 

Publisher: Sideris Courseware Corp.

Publication Date: 01-DEC-2010

Insert Date: 03-DEC-2012

Slots: 1.0

Table of Contents • Start Reading

The objective of this training course is to assist experienced Oracle database administrators to understand the concepts and implement the new features and associated with the R1 and R2 releases of the Oracle 11g database. Based upon this knowledge one will be able to utilize these features and realize the benefits they offer. Among the specific subjects we will consider are: Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators; The Fault Diagnosability Infrastructure now included...