What you will learn:

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

What you will learn:

This course is designed for developers with basic PL/SQL and SQL language skills. In class students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Student also learn to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects.
Students are introduced to the utilization of some of the Oracle-supplied packages.
Learn To:

• Create and manage Procedures and Functions
• Manage Dependencies and Large Objects
• Create Packages and maintain them
• Create and apply Triggers
• Utilizing Oracle-Supplied Packages in Application Development
• Understand and influence the PL/SQL Compiler

What you will learn:

This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.
In this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

What you will learn:

This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.
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. Delegates 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.

What you will learn:

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.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification

Suggested Prerequisites:Oracle Database 10g: PL/SQL Fundamentals