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.

Oracle Database 11g: Change Management Overview Seminer

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.

Oracle Database 11g: New Features for Administrators

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.

Oracle Database 11g: Administration Workshop II

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.

Oracle Database 11g: SQL Fundamentals I

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.

Oracle Database 11g: SQL Fundamentals II

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.

Oracle Database 11g: PL/SQL Fundamentals

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.

Oracle Database 11g: SQL and PL/SQL New Features

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.

Oracle Database 11g: Administration Workshop I

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.

Oracle Database 11g New Features

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:

Oracle Performance Tuning for 10gR2, Second Edition

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.

Professional Oracle Programming (Programmer to Programmer)

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

Oracle Security

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.

Effective Oracle Database 10g Security by Design

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.

Oracle Database 10g Managing Oracle on Linux for DBAs

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

Oracle Database 10g Administration Workshop I for Oracle 10g R2 ( OCA )

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.

Oracle Database 10g Administration Workshop II for Oracle 10g R2 ( OCP )

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.

Syngress Practical Oracle Security: Your Unauthorized Guide to Relational Database Security

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.

Oracle DBA Scripting Quick Reference

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!

Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide

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 (Expert's Voice in Oracle)

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

Oracle Database 10g: Managing Oracle on Linux for System Admins

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.

Oracle Warehouse Builder 10g: Administration

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.

Oracle Database 10g: RAC for Administrators R2

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.