Toad Introduction Half-day Workshop: Toad for Oracle Introduction Training
Dan Hotka, Training Specialist
This hands-on course is aimed at the Oracle professional who wishes to increase their productivity by utilizing Toad. This half-day course will cover Toad for Oracle setup/options, Editor, Schema Browser, short cuts/templates/snippets/insights/SQL History, creating scripts, accessing/changing data, using Fast Reports, and additional features.
Please bring your own laptop computer with Oracle RDBMS and the Toad products installed and ready to go. Power will be available at each seat.
Back to Top
Register Now
Data Warehouse Performance
Jerry Ireland, Rightsizing Inc., Mark W. Farnham, Rightsizing, Inc., Tim Gorman, Evergreen Database Technologies, Inc, & Kent Graziano, TrueBridge Resources
This session brings together four experts in performance and data warehousing. All are Oracle ACEs, two are members of the OakTable, and together they represent over ninety years of experience with Oracle. All of the ideas and techniques presented can be implemented with minimal additional hardware and most with a manageable effort. The session will start with some hints and tips that can be used on existing data warehouses and progress to a method of getting performance when the CBO does not recognize a star schema. The session will present partitioning strategies to increase scaling, and finally take a glimpse at some of the benefits of relatively new, but growing, database architecture. The day will be wrapped up with a Q & A with all symposium presenters.
Back to Top
Register Now
New Features in 11g for Developers
John King, King Training Resources
Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, new analytic functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers. Attendees who bring a laptop preloaded with Oracle Database 11gR2 (XE, Standard Edition, or Enterprise Edition) can try some of the new features with provided SQL scripts.
Back to Top
Register Now
Introduction to Java: PL/SQL Enthusiasts Take Heart
Peter Koletzke, Quovera
You've probably noticed that Java is at the heart of almost every product Oracle is offering these days. The reasons for this include Java's flexibility as well as its stronghold as an industry open standard. Most Oracle technologists will, at some point, run into a need to code Java from scratch or at least be able to read and interpret it for the purposes of enhancing or debugging existing programs. If you are not in tune with Java, it helps to experience an introduction in terms that you know. If you have used Java before, a gentle reminder of the basics can reinforce what you know and help you brush up on parts that you may not use much.
The objective of this University Session is to explain to those who understand PL/SQL and other languages but who have had little or no exposure to Java, the basic Java concepts and terms. The session provides an overview of the language, and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures - classes, methods, and constructors -- as well as control statements, exception handling, datatypes, and constants. In addition, the session identifies where Java fits in the context of Web applications, and explains various styles of Java code, such as servlets, applets, JavaServer Pages, and JavaServer Faces. It also touches briefly on how Java programs can access the database.
Back to Top
Register Now
Secrets of the Essbase Gurus: A Symphony of Learning
Edward Roske, interRel Consulting
Over the years, Essbase design and optimization has changed substantially. While some of what you learned years ago in Essbase Fundamentals still applies, most of it is outdated, obsolete, and just plain wrong. Over the course of this half-day content-rich training session, you're going to experience the most accurate and up-to-date design and optimization principles from one of the world's foremost experts in the Essbase world, Oracle ACE Director and published Essbase author, Edward Roske.
Hour 1: BSO & ASO Outline Design: This session will cover the correct ways to build, order, and optimize your Essbase BSO outlines as well as addressing how to build optimal ASO outlines.
Hour 2: ASO Optimization: While you may have heard that ASO models cannot be optimized, this session will dispel this myth and cover ways to speed up data loading, calculations, and retrieving against ASO cubes.
Hour 3: Calculation Optimization: Whether it's member formulas or calc scripts, this session will cover several out-of-the-box methods of speeding up Essbase BSO calculations.
Hour 4: Essbase Best Practices: There are many design principles for building cubes that are easy to understand, access, and use. This session will cover the ten most important ones.
Back to Top
Register Now
