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.

Please Login or Register (Quick) to see the download links.

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.

Please Login or Register (Quick) to see the download links.

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.
(more…)

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.
(more…)

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.
(more…)

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.
(more…)

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.
(more…)