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.

Oracle Database 10g: Implement and Administer a Data Warehouse

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.

TestKing Oracle10g 1Z0-042 V2.1 & 1Z0-043 V2

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

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

Oracle Database 10g: Managing Oracle on Linux for DBAs

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

Oracle Database 10g: 2 Day DBA for Windows

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

Oracle Database 10g: Backup and Recovery

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

CBT Oracel DBA The Complete Video Course

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.

Oracle by Example - Oracle Database 10g on a Single Instance

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.

Oracle Database 10g: RAC Basic Concepts & Architecture

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.

Oracle Database 10g: Quickstart for DBAs

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.

Oracle Database 10g: Implement Streams Release 2

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.

Oracle Database 10g: Data Guard Administration Release 2

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.

Oracle Database 10g: SQL Tuning Ed 2

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.

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

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.

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 Database 10g: SQL Fundamentals I

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

Oracle Database 10g: SQL Fundamentals II

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

Oracle Database 10g: PL/SQL Fundamentals

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

Oracle Database 10g: Develop PL/SQL Program Units

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