A Practical and Hands-On Introduction to Oracle Database 10g (R1 and R2) New Features

Spiral Bound 446 pages, currently priced at $35.00(US)

The essential step-by-step Oracle10g new features course for experienced Developers and Database Administrators.

This course book presents - in a succinct and practical fashion - an introduction to more than 120 new features introduced with Oracle Database 10g. Release 1 and Release 2 features are covered.

If you are an experienced DBA or Developer working with Oracle9i, you will learn the concepts behind the feature and provide - via more than 180 working examples - an introduction to the implementation and use of the feature. Scripts are available free on the Publisher's web site.

The book's design lends itself to classroom use or self-study. Most pages contain a "slide" at the top of the page that contains a working example or critical points about a feature. Below each slide are descriptive notes that expand on the points or provide insight into the example. (Look inside this book)

The book is spiral bound and will lay down flat making it easy to use when working at your computer.

Topics include:

• Flashback Enhancements - Flashback Version Query, Flashback Transaction Query, LOB Handling with Flashback, Setting up for Flashback, Flashback Table, Flashback Drop Table and Recycle Bin management.
• Backup and Recovery Enhancements - Flash Recovery Area, Flashback Database (setup, flashback logs and use), Restore Points, Simplified Recovery through RESETLOGS, Compressed Backups, Change Tracking, Incrementally Updated Image Copies, SWITCH DATABASE, New V$ Views, Encrypted Backups, DROP DATABASE, CATALOG, Oracle Secure Backup and more.
• Automatic Storage Management - An introduction to Oracle's new integrated file system and volume manager. Examples illustrate the basic use of ASM, including creating disk groups, fail groups, and using ASMCMD.
• Job Scheduler - Use the new DBMS_SCHEDULER package to schedule jobs, including OS scripts. Examples illustrate creating and scheduling jobs in both a Linux and a Windows environment.
• SQL Enhancements - Regular expressions, DML error logging, case-insensitive sort and search, MERGE enhancements, MODEL queries, XQUERY and much more.
• PL/SQL Enhancements - The new optimizing compiler, compiler warning messages, debugging improvements, native compilation enhancements, UTL_MAIL and more.
• Performance and Tuning Features - Automatic SGA Management, Automatic Workload Repository (AWR), Advisors (ADDM, SQL Tuning Advisor, etc), Active Session History data, new performance statistics (e.g. metrics and database time), Thresholds and Server-Generated Alerts, CBO Enhancements and much more.
• Security and Auditing Enhancements - Changes to the CONNECT Role, FGAC Review, FGAC / VPD Enhancements, FGA Review, Fine Grained Auditing Enhancements, Encryption Enhancements, DBMS_CRYPTO Package (R1) and Transparent Data Encryption (R2).
• Tablespace, Table and Segment Management - SYSAUX tablespace, BIGFILE and SMALLFILE tablespaces, database-level default tablespace, database-level default temp tablespace, temp tablespace groups, multi-platform transportable tablespace, renaming tablespaces, predicting object growth, online table redefinition enhancements and online segment shrink.
• Utilities (Data Pump) - An example-based introduction to Data Pump, the next generation export / import utility. Also covered: External Table and Logminer enhancements.
• SQL*Plus Enhancements - New predefined variables, SPOOL command enhancements, AUTOTRACE enhancements and more.
• Miscellaneous Enhancements - Guaranteed UNDO retention, ROLLBACK monitoring, Easy Connect (EZCONNECT) connections, database high watermark recording, database feature usage tracking and new and deprecated initialization parameters.

What this course book is not:

This book is not an exhaustive treatment of each and every feature in Oracle 10g. Readers should expect to come away with a solid understanding of the features covered and their purpose. The material will provide, in most cases, the knowledge required to get started with use of or implementation of the feature or enhancement.

This book is not a rehashing of Oracle documentation or Oracle command syntax.

Oracle Instructors Take Note: Instructor kits are available for purchase from the publisher's web site.

About the Author

Dave Anderson has been working in the Information Technology industry as a developer, database administrator, author and teacher since 1980. He has developed and managed applications and databases for banks, retailers, a defense contractor and an oil company, to name a few. He is a frequent and highly rated speaker at Oracle industry events. Dave founded and is still employed by SkillBuilders, an IT training and consulting firm, located in Rhode Island , USA !

Product Details

Spiral Bound Paperback: 446 pages

Publisher: SkillBuilders, Inc. 2nd Edition July 2006

Language: English

Shipping Weight: 3 pounds.

Spiral Bound Paperback: 2 Volumes / 726 pages

This training course has been completely updated for Oracle10g. This includes training on Data Pump, Server-Generated Alerts, Advisors, Automatic Storage Management (optional lesson), Automatic Statistics Col lection and Auditing Enhancements.

Working examples are included throughout the course book. Students have access to electronic versions of all examples, sample scripts and lab solutions.

Approximately 50% of class time is spent on hands-on exercises.

Audience:

Database and System Administrators.

Duration*:

This training course contains a lot of information, sometimes too much for 5 days. The pre-existing knowledge of the student(s) will dictate how many days of in-class instructor-led training are required. For example, if the students have no prior administration experience with a relational database, we recommend either allocating 8 days, or deleting some lessons from the lesson plan. However, if the students are veteran DB2 or Sybase administrator's, it is quite possible that all topics can be covered in 5 days.

Prerequisites:

You must have experience working with Oracle to successfully master the information in this course. Specifically, you must have solid Oracle SQL experience and familiarity with SQL*Plus and PL/SQL. You can obtain this training in SkillBuilders' classes Introduction to Oracle10g and SQL and Introduction to Oracle10g PL/SQL Programming

Next Courses:

Suggested next training: Oracle10g SQL Tuning for Developers and DBAs, Oracle10g Database Performance and Tuning, Backup and Recovery with Oracle10g RMAN, Backup and Recovery in Oracle10g.

Objectives:

After successfully completing this course, you will be able to:

• Describe the major architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database.
• Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views.
• Create administrative users, including granting and using the SYSDBA privilege. Understand the purpose of Oracle supplied users SYS and SYSTEM.
• Connect to the Oracle database as SYSDBA, both from a host server or - via the use of password files - over a network.
• Start and stop an Oracle database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
• View and alter initialization parameter values, create and startup with secondary parameter files. This includes training on the use of the Server Parameter File, introduced with Oracle9i.
• Create new Oracle users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles. Secure the default users provided with database installation.
• Implement the Oracle user password management features such as password expiration, account locking, password reuse prevention and password complexity enforcement.
• Implement Oracle database auditing to track SYSDBA activity and general user activity. Also, code simple triggers to audit table data changes.
• Create and manage locally managed tablespaces including monitoring space usage and adding space.
• Implement Automatic Segment Space Management to efficiently manage free and used space within extents.
• Using the Oracle Managed Files feature to control placement of and name the underlying datafiles.
• Manage storage for Oracle objects with disk striping and buffer pool assignment.
• Use Automatic Storage Management (ASM) to control file allocation, placement, striping and mirroring (this is an optional lesson)
• Describe the different types and typical uses of Oracle tables, including heap, index-organized and clustered tables.
• Create and manage heap-tables, including managing concurrency with the INITTRANS and MAXTRANS parameters, moving tables, using DBMS_STATS to collect statistics and increasing and measuring the performance benefits of NOLOGGING and table compression.
• Describe the different types of Oracle indexes including B-tree, bitmap and reverse key.
• Create simple B-Tree indexes on tables. This includes understanding the fundamental rules for when and where to create and when to avoid using indexes. Also implement index options such as NOLOGGING.
• Create constraints on tables including the use of options such as NOVALIDATE to allow existing legacy data with constraint violations.
• Describe the techniques for managing undo, including the Oracle9i Automatic Undo Management feature.
• Implement Automatic Undo Management including creating and enabling new undo tablespaces and monitoring for space-related problems. Use the Oracle10g Undo Advisor to assist with undo management.
• Manage the database redo logs including archiving, multiplexing and adding additional logs. Also, ensure that the database is recoverable by checking the archive log status of the database. Use the Oracle10g Redo Log Advisor to obtain log size advice.
• Understand the role and importance of control files. Add additional control files. Backup and recreate control files.
• Use the basic features of Recovery Manager to perform simple backup and recovery operations in the event of a lost or corrupted datafile.
• Use the 10g Data Pump utility perform logical backups or move or copy objects.
• Use the SQL*Loader utility to load data into the database.
• Configure Oracle Net (SQL*Net) to connect to and listen for connections. Manage the database listener with the listener control utility.
• Create a new database with the Database Configuration Assistant.
• Optional lessons include: Introduction to Partitioning, Other Table Types and Original Import / Export Utility

Product Details:

Spiral Bound Paperback: 2 Volumes / 726 pages

Publisher: SkillBuilders, Inc. 1st Edition July 2006

Language: English

Shipping Weight: 4 pounds.

This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases.

You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability directly from the database"), Oracle10g regular expressions for pattern matching, using the extended aggregate functions CUBE and ROLLUP, CONNECT BY (hierarchical queries), coding SET operations such as INTERSECT, and more.

An overview Oracle10g SQL-related new features is also provided. (This overview is limited to only those features not included in the primary lessons in the course.)

As with all of our courses, this course is highly customizable to your specific training requirements. Hands-on workshops constitute approximately 50% of the class.

Audience:

Anyone who uses SQL to query Oracle databases including developers, analysts, database administrators and decision support personnel. Persons working in a data warehouse or decision support environment will benefit greatly from the lessons on analytic functions, grouping with CUBE and ROLLUP, modeling (the Oracle10g MODEL clause) and coding queries on partitioned data.

Prerequisites:

Some SQL and SQL*Plus experience is required. For example, you should be comfortable coding basic SQL SELECT statements, including the use of the WHERE clause with basic filters and simple joins. This can be obtained by attending SkillBuilders' Introduction to Oracle class.

Next Courses:

Oracle10g SQL Tuning for Developers and DBAs, Oracle10g Database Administration

Objectives:

After successfully completing this course, you will be able to:

• Design, code and test the most efficient Oracle query for a given business problem

• Code efficient inner and outer joins, including the use of the Oracle ANSI-compatible join syntax

• Use Oracle10g partition outer join to "densify" data (i.e. fill in the gaps)

• Code complex subqueries including correlated subqueries, inline views, subqueries in the column-list, Oracle subquery factoring (the "WITH" clause) and NOT EXISTS queries

• Code partition independent and partition-aware queries.

• Use the set operators UNION , INTERSECT and MINUS to combine the results of two or more queries into a single result set.

• Query and generally handle Oracle date and datetime (i.e. temporal) data.

• Use the Oracle10g MODEL clause to produce spreadsheet-like results (e.g. sales forecasting) from a query result set

• Use Oracle10g regular expressions for text pattern matching (i.e. search and optionally replace data using the POSIX-compatible regular expressions)

• Use Oracle analytic functions to code efficient solutions to complex decision support problems such as ranking (e.g. top earners by department), percentages within a group (e.g. each employees percent of total payroll), cumulative totals (e.g. cumulative salary by department), lag and lead functions (compare to next / previous row - without a self-join), windowing functions and more.

• Use the Oracle CUBE and ROLLUP extensions to create super-aggregate rows of output (i.e. add additional dimensions of data to the result).

• Use the Oracle GROUPING function with CUBE and ROLLUP.

• Use the Oracle GROUPING SETS extension to the GROUP BY clause to control which dimensions are included in the result set.

• Store hierarchical data and display data results in hierarchy order (e.g. employees sorted by management chain) with the Oracle CONNECT BY clause

• Use the Oracle DECODE function and Oracle CASE expression to add IF / THEN / ELSE (conditional) logic to an SQL query.

• Use basic Oracle XML functions to search and extract XML data from the Oracle database

Product Details:

Spiral Bound Paperback: 353 pages

Publisher: SkillBuilders, Inc.

Language: English

Shipping Weight: 2 pounds.