Oracle Stuff: 2008

Sunday 1 June 2008

We move to the Blue Library

To see more and new oracle stuffs please visit

www.technolib.net

Thursday 21 February 2008

Oracle Database 11g Analytic SQL for Data Warehousing

D52496GC10
Production 1.0
December 2007

In this course students use Analytic SQL to aggregate, analyze and report, and model data. Students learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure. Students also learn to use regular expressions and subexpressions to search for, match, and replace strings.

Before attending this course, students should be familiar with relational database concepts, data warehouse theory and implementation, Oracle server concepts including application and server tuning, and the operating system environment on which the Oracle Database Server is running. Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This course is intended for data warehouse builders and implementers, database administrators, system administrators, and database application developers who design, maintain, and use data warehouses.

D50325GC11
Edition 1.1
September 2007
D52495

The adage that "Change is constant" holds true especially in the information technology world. While change can bring improvements, it also brings disruptions. This one day seminar focuses on the Oracle Database 11g Release 1 innovations which enable you to mitigate the chaos that database and application upgrades can wrought. In this course, you will learn about the features you can use to record production workloads then play them back in a test environment so that you can determine and eliminate potential issues before you deploy these changes to your production environment. The instructor lecture is supported by recorded product demonstrations. By attending this course, you can more effectively realize the positive benefits of database and application upgrades, while minimizing the negative side effects.

D50081GC11

This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

D50079GC10
Edition 1.0
November 2007

What you will learn

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.

Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

D49996GC10
Edition 1.0
August 2007
D52128

What you will learn:This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

D49994GC10
Edition 1.0
August 2007

What you will learn:This course is designed for application developers with basic SQL language skills. In this course, students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.

Students learn to use the dictionary views to retrieve metadata and create reports about their schema objects. Students learn some of the date time functions available in the Oracle 11g Database and use the regular expression support in SQL.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

D49990GC10
Edition 1.0
August 2007

What you will learn

This course introduces students to PL/SQL and explains the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

D50000GC10
Edition 1.0
August 2007

What you will learn:
In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.

Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features are also discussed in this course. Students also learn about the reengineered LOB data type that offers advanced, next-generation functionality such as intelligent compression and transparent encryption. Additionally, students explore the data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators.

D50102GC10
Edition 1.0
September 2007

What you will learn

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Your Must-Have Guide to Everything New in Oracle Database 11g

Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

Book Description

One of the only Oracle books to focus exclusively on database programming rather than administration
Oracle owns sixty percent of the commercial database market
Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i
The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials
Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL

Security in a relational database management system is complex, and too few DBAs, system administrators, managers, and developers understand how Oracle implements system and database security. This book gives you the guidance you need to protect your databases.
Oracle security has many facets:

Establishing an organization's security policy and plan
Protecting system files and passwords
Controlling access to database objects (tables, views, rows, columns, etc.)
Building appropriate user profiles, roles, and privileges
Monitoring system access via audit trails
Oracle Security describes how these basic database security features are implemented and provides many practical strategies for securing Oracle systems and databases. It explains how to use the Oracle Enterprise Manager and Oracle Security Server to enhance your site's security, and it touches on such advanced security features as encryption, Trusted Oracle, and various Internet and World Wide Web protection strategies.

Protect Your Mission-Critical Data with Tips and Tricks from an Oracle Security Insider

Oracle expert David Knox has written the most practical, up-to-date book on Oracle Database 10g security available. With an emphasis on real-world problems and detailed solutions, Effective Oracle Database 10g Security by Design provides all the information you need to develop and deploy secure database applications. The entire security cycle is covered--from identification and authentication to fine-grained access control and encryption to effective auditing techniques. The material is presented with comprehensive yet easy-to-understand examples that show how to use all the security technologies in a complementary way.

The Oracle Hacker's Handbook: Hacking and Defending Oracle

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

1-Introduction
2: Preparing Linux for Oracle
3: Installing Oracle on Linux
4: Managing Storage
5: Automatic Storage Management
6: Creating the Database
7: Customizing Oracle on Linux
8: Managing Memory
9: Using Linux Measurement Tools
10: Tuning Performance
11: Debugging Oracle on Linux

D17090GC30
Edition 3.0
November 2005
D22683

Oracle Database 10g: Administration Workshop I is an instructor-led course featuring lecture and hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts and skills introduced.

D17092GC30
Edition 3.0
January 2006
D44163

Oracle Database 10g: Administration Workshop II is an instructor-led course featuring lecture and hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts and skills introduced.

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

The fast, practical Oracle 9i/10g automation reference for every DBA!

Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use. Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now!

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management

Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in feature set for working with location-based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address

* The special nature of spatial data and its role in professional and consumer applications
* Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data
* The Oracle Spatial solution and the integration of spatial data into enterprise databases
* How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users

When you read Pro Oracle Spatial for Oracle Database 11g, you're learning from the very best. Ravi Kothuri is a key member of Oracle's Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.
What you'll learn

D46592GC11
Edition 1.1
October 2007

What you will learn

This course prepares a Linux system administrator for managing a system on which Oracle Database has been installed. Elements of how Oracle works on Enterprise Linux and specific steps for preparing Linux for a database installation are covered. This course provides the system administrator, who already has some Linux experience, with the skills needed to diagnose an Oracle Database using system administration tools. The Oracle Database architecture is covered, which will help the system administrator understand what affect database activity and configuration can have on the process list, disk space, memory use, and CPU utilization.

D44810GC10
Edition 1.0
January 2007

What you will learn

This hands-on course addresses specific administration features available in Oracle Warehouse builder 10g Release 2 (OWB). The course covers the administration tasks that may be performed during a data warehouse development process and also the administration tasks that are performed to maintain a fast and efficient Warehouse Builder system.

D17276GC20
Edition 2.0

What you will learn:This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

Oracle Database 10g: Develop Applications Using HTML DB Ed2

D17171GC20
Edition 2.0

What you will learn:This course is designed to introduce the participants to Oracle HTML DB 1.6. It provides an overview of the architecture. During the course, the student builds an Order-Entry application. And while building this, the course discusses the various steps involved in building a database-centric Web application. The student learns how to quickly build the application. They add reports, forms, items and buttons to the application and include page processing in it. The student is also exposed to workspace administration and security implementation through authorization and authentication schemes. In addition, an appendix is provided that covers the new features in Oracle HTML DB 1.6 with respect to Oracle HTML DB 1.5.

D18957GC10
Edition 1.0

This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. Before attending this course, you should be familiar with relational database concepts, basic data warehouse theory, Oracle server concepts including application and server tuning, and the operating system environment under which you are running the Oracle Database Server.

Exam Number: 1Z0-042
Associated Certifications: Oracle Database 10g DBA OCA

Exam Number: 1Z0-043
Associated Certifications: Oracle Database 10g DBA OCP

What you will learn

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 10g Database on Enterprise Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle database. Then they will install and create an Oracle 10g database on Linux. In addition, the students will also learn how to tune the database to take advantage of the Linux operating system and the Enterprise level features of the OS.

Learn To:
Optimally configure Linux for an Oracle Database installation
Customize the database to take advantage of Linux features
Monitor memory, CPU, and I/O activity and performance
Identify the different kernels and memory models available for Linux

What you will learn
The goal of this course is to teach Database Administrators how to install the Oracle Database 10g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required tasks. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.

Audience
Database Administrators

Course Objectives
Monitor the database and use the Advisors
Install Oracle Database software and create a database
Use Enterprise Manager Database Control to manage the database
Configure and manage the Oracle Network environment
Manage database storage structures
Administer users and security
Manage schema objects
Back up and recover the Oracle Database

D22057GC10
Production 1.0

What you will learn
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error.

This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.

Learn To:
Develop an effective backup and recovery strategy
Perform backup and recovery operations using RMAN
Install and configure Oracle Secure Backup for tape backup
Use Oracle Secure Backup to back up database and file system files

Fully Integrated Book/QuickTime Video Package-Expert Training.

CD-ROM contains 3 1/2 hours of QuickTime video instruction PLUS the Oracle DBA Interactive Workbook e-Book!

Master the basics of Oracle database administrationâ€”now! Managing the database and its physical layout, ensuring security and data integrity, providing for backups, PLUS the History of Oracle Networking.

Includes 3 1/2 hours of expert QuickTime video instruction by Columbia University instructors Melanie Caffrey & Douglas Scherer.

The Oracle by Example series provides step-by-step instructions on how to perform a variety of tasks using Oracle Database 10g. The Oracle by Example series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

D44422GC10

What you will learn

This one day seminar introduces the most important concepts of Oracle Database 10g Real Application Clusters. Learn about the architecture that supports Grid Computing in a RAC environment including the Oracle Clusterware and RAC database.

These concepts are illustrated with demos that allow for better understanding of Oracle Clusterware and RAC database capabilities.

This seminar is a vital for people interested in the functionality of RAC technology, and does not require any previous experience with RAC. Beginners with minimal single-instance Oracle experience are introduced to RAC Curriculum and Grid Technology.

D47045GC10

In this class, students will learn how to install and maintain Oracle database 10g (10.2.0). Students will gain a conceptual understanding of the Oracle Database architecture and how its components work and interact with one another. Participants will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including database security, user management, and moving data techniques. The lesson topics are reinforced with structured hands-on practices.

D17333GC20

What you will learn

This course introduces students to Oracle Streams, a powerful and flexible information-sharing feature of Oracle Database 10g. This course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. The lessons are designed to give students practical experience in configuring and managing a Streams environment. The course covers enqueue and dequeue messages using Oracle Streams. Also included are best practice guidelines and troubleshooting practices.

D17316GC20

What you will learn

Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips.

Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills.

D17265GC20

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Identify and Resolve System Bottlenecks Quickly

Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views, their applications, and the extended SQL trace file. This invaluable resource will help you maximize the most advanced diagnostics tool available and minimize processing time.

D17108GC21

This course offers students an introduction to Oracle Database 10g Database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
This course also introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Demonstrations and hands-on practices reinforce the fundamental concepts.

Learn To:
Use SQL Statements to retrieve data from tables and employ SQL functions to generate and retrieve customized data
Declare PL/SQL Variables and Work with Composite data types
Run data manipulation statements (DML) to update data in the Oracle Database 10g
Write Control Structures and work with Explicit Cursors
Create and Manage Tables
Handle Exceptions

In this course, students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail.

Students learn about manipulating large data sets and storing and retrieving dates according to different time zones. They are also taught the concepts of controlling access and privileges for schema objects.

Learn to:
Control privileges at the object and system level
Use grouping operations to create reports
Manage Schema Objects
Search data using Advanced Sub-queries, and retrieve hierarchical data
Manipulate data in the Oracle database by using sub-queries
Use Regular Expression support

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Learn To:
Declaring PL/SQL Variables
Working with Composite Data Types
Creating the Executable Section
Using Explicit Cursors
Writing Control Structures
Including Exception Handling

D17169GC21

This course is designed for developers with basic PL/SQL and SQL language skills who want to develop stored procedures, functions, packages and database triggers. Students will also learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. JDeveloper is introduced as an optional tool.

Course Objectives:
Write dynamic SQL for more coding flexibilityDesign PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptionsUse the compiler warnings infrastructureManipulate large objectsCreate triggers to solve business challengesManage dependencies between PL/SQL subprogramsSchedule PL/SQL jobs to run independentlyCreate stored procedures and functionsDesign PL/SQL packages to group and contain related constructsCreate overloaded package subprograms for more flexibilityCategorize the Oracle supplied PL/SQL packagesUse the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output

Download:
http://rapidshare.com/files/81143269/d17169gc21_ppt.rar

Password: www.bluelibrary.org

Sunday 1 June 2008

Thursday 21 February 2008

Wednesday 20 February 2008

Tuesday 29 January 2008