Benthic Software - Training

Products

Shopping

Professional Training

2-Day On-site Oracle Workshops
Instructor: Dan Hotka

Give your technical staff that competitive edge with Oracle Workshops. These courses are designed to enhance your staff's skill set to perform their job functions better. Authored Oracle Expert Dan Hotka has over 20 years experience with the Oracle RDBMS product and has designed the following courses to meet the demands of today’s computing environment.

These workshops are designed to be held on-site, at your location. Dan has his own portable computer lab. On-site instruction enables more people to be trained with the same training dollar.

The course utilizes the Benthic Software - Golden tools. Students will have the opportunity to learn more about Golden during the course of study. Knowledge of Golden is not a requirement of any of these workshops.

Please mention Benthic Software when you speak to Dan regarding training.

Workshops

Introduction to Oracle/Oracle for Business Intelligence Users:

This course is excellent for users and managers who simply need to know more about Oracle.

Oracle Architecture
Introduction to SQL topics: Select, Insert, Update, Delete
SQL Scripting Topics (Formatting SQL & creating web-based reports!)
Creating Tables/Indexes
Advanced Topics (Functions, cross-reference output, Referential Integrity)
Optional 3rd day: Golden Tips and Techniques for Power Users

More information

Advanced Oracle for Business Intelligence Users:

Oracle Analytical SQL (Rollup/Cube/Rank Over/Percentiles/Offset Functions)
Introduction to SQL Statement Tuning:
- Using Explain Plan Tools
- Indexing Review
- Reading SQL Explain Plans
- Understanding the Oracle SQL Optimizers

More information

Oracle SQL Statement Tuning Tips and Techniques:

This course is designed for the novice tuner.

Understanding SQL Tuning Statement Topics
Reading Explain Plans
Controlling both the Cost and Rule-based Optimizers
Using Hints
Optional 3-day Mix…this course with 1-day of advanced tuning topics

More information

Advanced Oracle SQL Tuning Tips and Techniques:

This course covers advanced tuning topics around the Oracle RDBMS

SQL Tuning Topics for the Intermediate and Advanced Developers & DBA’s
Advanced problem-solving topics using V$ Table information
Oracle9 & 10 Tuning & Space Management New Features
In-depth look at Explain Plans
Oracle Trace Facility/Stats Pack/Wait Events covered
SQL Troubleshooting/problem solving

More information

Oracle/Unix Scripting Tips and Techniques:

This course is perfect for those who know Oracle but are new to Unix

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

More information

More about Dan Hotka

Dan Hotka is a Training Specialist who has over 25 years in the computer industry and over 20 years of experience with Oracle products. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dan’s latest book (co-author) is the Oracle10g on Linux by Oracle Press. He is the author of Oracle Utilities Pocket Reference by O’Reilly, Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 6 other popular books. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Dan can be reached at dhotka@earthlink.net.