Main Menu       Contact Us

Main Menu 

  Onsite Training

  • 1 Low Price

  • Up to 15 People

Training at your Desk!

  • Instructor-led training over the web!

  • Morning Lectures

  • Hands-on Lab

  Downloads

  Tools:

   Newsletters

  Speaking Topics

  Seminars

Dan Hotka:

Contact us

 

1 Day Seminars

Oracle/Unix Scripting Tips and Techniques

Give your technical staff that competitive edge with this local Oracle/Unix Workshop.  This course is full of tips and techniques for the novice and experienced developer/DBA.  Topics are supplemented with hands-on lab exercises.

Topics covered:

  • Introduction to ‘tools of the trade’ – various editors in Today’s scripting world
  • Introduction to shell programming
  • SQL*Plus Reporting and Web reporting techniques
  • SQL creating SQL
  • Building Oracle data-driven scripts
  • Unix Shell Programming
    • Paging Script
    • Monitoring Scripts
    • Scripts to Automate Repetitive tasks
    • Oracle/Unix Shell Techniques

Download Information in PDF format

   

Oracle Tuning Tips and Techniques

Give your technical staff that competitive edge with this local Oracle Workshop.  This course will cover a variety of SQL statement tuning issues, controlling the Oracle optimizers, tips and techniques for good relational/application design to take advantage of Oracle's b-tree indexing structures, and advanced topics such as Oracle Trace, Stats Pack, and a variety of parameter settings that make a big difference to Oracle-based applications.  One-forth of this workshop focuses on monitoring Oracle RDBMS and SQL via the v$ tables.  This course is packed full of scripts to discover a variety of issues.

 This course also covers new features in Oracle9i/10g that will have an affect on your migrated applications.

 The course utilizes a variety of current tools.  Students will have the opportunity to learn more about TOAD, TextPAD, JS Tuner, as well as the Oracle tools like SQL*Plus.

 Topics covered:

  • SQL Tuning Topics for the Intermediate and Advanced Tuners/DBA’s
  • Advanced problem-solving topics using V$ Table information
  • New Oracle9 & 10 Tuning & Space Management Features
  • In-depth look at Explain Plans
  • SQL Problem Queries

 

Download Information in PDF format