Oracle Database 10g: A Comprehensive Hands-On Introduction

What is this course about?

This course offers a comprehensive introduction to the relational features of Oracle Database 10g used to create powerful and robust database applications.

Oracle 10g is a large, complex system. This course provides a broad overview of the power and flexibility of Oracle and the SQL language and serves as the foundation for the other courses in the Learning Tree Oracle Databases curriculum.

You learn how to use SQL and PL/SQL so that you can begin to develop high-performance database applications right away. The extensive hands-on exercises provide invaluable practical experience solving business problems using Oracle 10g.

Who will benefit from this course?

This course benefits a wide range of professionals including:

• Developers, analysts, administrators, managers, programmers, consultants, power users and others who design and write Oracle applications using Oracle 10g
• Database administrators who want to become proficient in querying and manipulating an Oracle database
• Those who are familiar with SQL but wish to learn the special features of Oracle's PL/SQL
• Data processing professionals with experience working with traditional database systems (hierarchical or network), who are now moving to a client/server or Web environment
• Technology managers and project leaders who need a general overview of Oracle 10g

What background should I have?

Some experience working with a relational database and familiarity with basic programming concepts are helpful but not required. If you have a strong background in a dialect of SQL other than Oracle's, some parts of the course may be redundant for you, but you will still benefit from all the Oracle-specific material presented.

What version of Oracle is used?

This course is currently running on Oracle10g, Release 2 on the Windows platform.

Is this course useful if I'm working with an earlier version of Oracle?

This course uses Oracle 10g. However, because the basic architecture is the same across all Oracle environments, this course would be applicable even if you are using an earlier version of Oracle. If you are evaluating Oracle 10g, or if you are currently working on an earlier version but are planning to move to Oracle 10g, then this course is for you. The course highlights the main differences between the Oracle versions with icons ("10g", "9i", "8i").

How do Oracle 10g and Oracle9i differ from each other and does this course cover the new features of Oracle 10g?

In general, Oracle 10g is a superset of Oracle9i, containing additional functionality.

This course is an introduction to Oracle 10g and is not intended for people experienced in previous versions of Oracle. While some of the database's new features are covered, such as regular expressions and restoring dropped tables, this course does not focus on what is "new" with Oracle 10g.

Will the material I learn be relevant for my UNIX [or VMS] shop?

Yes, SQL and PL/SQL are platform-independent. Everything you learn is applicable to a UNIX or VMS environment.

How much time is spent on each topic?

What kind of hands-on exercises are included in the course?

Approximately 40% of class time is devoted to hands-on exercises. The hands-on exercises in this course provide immediate reinforcement of material covered. Exercises include producing queries using joins, set operators, groupings and subqueries, utilizing declarative constraints to impose business rules, enhancing performance with indexes, controlling logic and handling exceptions, building PL/SQL procedures, triggers and packages, and creating object types and nested tables.

How are object-relational databases addressed in Oracle 10g?

The object-relational functionality in Oracle 10g fully supports the creation of reusable code. This enables you to quickly create additional functionality within new and existing applications simply by copying objects. The object capability also allows you to standardize code across applications, simplifying administration.

I am currently enrolled in the 4-day, extended-hours course. Is the content covered identical to the 5-day course?

Yes, all courses present identical content. The only variation is the length of the individual course days. 4-day courses meet from 8:00 am until 5:00 pm with a 45 minute lunch break. 5-day courses meet from 8:30 am to 4:30 pm with a one hour lunch break. The goal of the 4-day extended-hours course is to achieve the same knowledge you would receive in the 5-day course in a shorter length of time.

What is the difference between this course and the one offered by Oracle?

Learning Tree is dedicated to accelerating the careers of our clients by providing them with world-class technology and management training. Our independence from Oracle (and every other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Oracle by industry experts who bring their real-world experience to the classroom.

How does this course relate to other Learning Tree courses?

Course 593 is the prerequisite for Course 594, Oracle^® Database 10g Administration: Hands-On. Course 594 helps prepare you to set up and configure Oracle databases, control and administer user accounts, monitor and optimize database storage, and protect the database with appropriate backup and recovery strategies.

The following courses may also be of interest:

• 382, Relational Database Design, Tools and Techniques: Hands-On provides a comprehensive introduction to relational databases.
• 492, Application Development and Tuning for Oracle® Databases: Hands-On provides the knowledge and skills needed to create powerful and secure Oracle database applications and tune them for optimal performance.
• 493, Oracle® PL/SQL Programming: Hands-On provides extensive experience in utilizing advanced techniques to design PL/SQL applications that solve complex business problems.
• 234, Developing SQL Queries for Oracle® Databases: Hands-On offers the skills needed to write robust, reliable and efficient SQL queries.
• 518, Hands-On Oracle® Database 10g: Backup, Recovery and Server Tuning , offers techniques to solve a range of issues, including media and site failures, invalid user input, lock contention, and poor memory and storage allocation.