back to Course Categories | back | print
Oracle10g: Advanced SQL Workshop          

Duration: 3 days

Description 
This class is designed to teach Oracle developers and DBAs advanced SQL programming skills. This class will teach developers how to write efficient SQL for large complex databases. Attendees will learn how to write code using large multi-way joins, deep nested queries against complex data structures. Attendees will evaluate execution plans using large joins, partitioned tables, index-organized tables and complex indexes. Code will be written using advanced analytics, advanced functions, external tables, table functions, predictive analysis and using new model features in Oracle10g. The goal of this class is to teach attendees advanced SQL skills that need to be used in today's complex Oracle environments. This class will be taught in a hands-on workshop versus the traditional lecture/labs environment.

Topics

  • Review the Oracle architecture
  • Review CBO and SQL tuning
  • Understanding the cost-based optimizer
  • CBO internals
  • SQL tuning best practices.
  • Top SQL and ADDM
  • SQL tuning advisor
  • SQL tuning sets
  • SQL profiles
  • Generating statistics using DBMS_STATS
  • Powerful tools for evaluating SQL
  • Understanding explain plans
  • Access methods
  • Evaluating plans against complex indexes
  • Evaluating plans agains partitioned objects
  • Evaluating execution plans
  • Autotrace in Oracle10g
  • SQL Trace
  • Oracle 10046
  • 10053 trace data
  • Statspack
  • Tkprof
  • Evaluating runtime statistics
  • Working with complex joins
  • Using the MODEL clause
  • Predictive analytics
  • Analytical functions
  • Advanced SQL functions
  • Writing code against external tables
  • SQL using table functions
  • Tuning data warehouse environments

Prerequisites

  • A solid understanding of SQL programming and PL/SQL is required.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design