|
Main Menu
Onsite
Training
-
1 Low Price
-
Up to 15 People
Training
at your Desk!
Downloads
Tools:
Newsletters
Speaking
Topics
Seminars
Dan Hotka:
Contact us
|
Training Topics
Dan offers training for both the advanced developer and/or DBA
and for those who are new to the Oracle RDBMS or to expand the knowledge of
those group of users known as 'Power Users'.
My pricing model is 1 course fee for up to 15 attendees.
This course fee is comparable to what others charge for 2 to 4 attendees.
The course fee includes the use of my portable computer lab. Course guides
are priced separately per attendee and vary by course offering. Many of
these courses also have an optional book on a related topic.
This training is in the form of workshops with hands-on
lab exercises. www.DanHotka.com is
completely portable and can be scheduled on-site. This format
eliminates the expenses and issues of sending employees away for training.
Attendees will receive hands-on training using the latest Oracle development
tools. The knowledge learned can
easily be utilized in your companies purchased tools, current freeware tools, or manual methods such as SQL*Plus.
The attendees will also receive a study guide packed full of examples and course
exercises that emphasize the learning process.
These classes are
available on-site, in your own training center or conference room.
Attendees Receive:
- Study guide with presentations and relevant white
papers
- Most workshops include a relevant book
- Diskette full of course example SQL and SQL*Plus
scripts
- Opportunity to ask the tough Oracle questions
download a
summary of these workshops.
Jump to Business Intelligence Courses
Jump to Additional Course Offerings
Oracle SQL Performance Tuning Tips and
Techniques
The focus of this tuning course is to illustrate
coding techniques that insure a consistent response time between instances and
releases of the Oracle database. This
course works closely with performance tuning of actual SQL statements as well as
covering a variety of Oracle Server tuning topics.
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.
Optional 3rd day
includes advanced topics that focuses on monitoring Oracle RDBMS and SQL via
the v$ tables, tracing performance issues from Stats Pack to the actual SQL
causing the issues. This section covers a
variety of Oracle Trace options as well. This course
is packed full of scripts to discover a variety of issues.
This course covers important Oracle10g and 11g Tuning
and Space Management New Features.
Download
a course description
I
offer a 1-day, 2-day, and 3-day version of this material - click to download
specific course outlines:
Oracle
SQL Tuning 1-day
Oracle
SQL Tuning 2-day
Oracle
SQL Tuning 3-day
Advanced PL/SQL Tips and
Techniques (3-days)
The focus of this course is to advance
attendee knowledge of the PL/SQL programming language.
This is an excellent course for those people that need a better
knowledge of the PL/SQL language. This
course covers all the latest features of PL/SQL using databases Oracle9i,
Oracle10g, and Oracle11g.
Topics covered:
-
- PL/SQL
Topics
- Package
Usage (both User Defined and Oracle Defined Packages)
- Profiling/Debugging/Compiling
- Cursor
Sharing/Cursor Variables
- Collections
- Dynamic
SQL
- Autonomous
Transactions
- PL/SQL
Coding Tips
- Debugging
PL/SQL
- PL/SQL
Profiling
- Oracle
Trace
Download
a course description
Introduction to SQL
(2-days)
Dan shares his extensive knowledge of SQL and
SQL*Plus Reports in this Oracle introductory course. The attendee
will learn how to get and manipulate data using the Oracle RDBMS.
Dan will illustrate how to best use the SQL language. Students will
work the course examples using the latest Oracle development tools. Students will learn
the SQL language, including SQL functions, sub-queries, date functions,
and creating tables and indexes. Students will also learn how to use
SQL*Plus commands to create and format the SQL into quick and attractive
reports, including HTML reports. This course also covers using
ODBC with MS products.
Download
a course description
Introduction to PL/SQL
(2-days)
The attendees have the
opportunity to construct various PL/SQL routines to solve simple and
complex business questions. Dan
will cover how to code PL/SQL, access data in a variety of methods, error
handling, and will touch on debugging PL/SQL.
Topics covered:
Download
a course description
TOAD for IT Staff (1-day)
Dan will
illustrate the latest features of TOAD necessary to view, extract, and
manipulate data within the Oracle database. This workshop covers all of the
features necessary to develop, manipulate, and debug PL/SQL code, develop &
tune SQL statements, and discover all of the features of TOAD. This short course
will also cover exactly how to put Oracle data into Excel spreadsheets and take
data in Excel spreadsheets and put it back into the Oracle database!
Dan will also show how to see the data relationships of the application
data and how to view this data.
Download
a course description
Oracle/Unix Scripting Techniques
(3-days)
Get
the most out of your Unix and Oracle environments with this 3-day
workshop. Dan instructs users on how to develop Data-driven SQL
scripts. This course builds on this material and includes various Unix
scripting techniques such as automatic Oracle error handling, paging scripts
based on Oracle issues, scripts that automatically add data files, and scripts
that check the status of various Oracle tasks. The attendee will have the
opportunity to actually build scripts that build other Oracle scripts, sends a
message to a pager, learn how to schedule scripts using Unix Cron, and
more.
Download
a course description
Oracle10g RAC for
Administrators
The
course “Oracle Database 10g RAC for Administrators” provides an
introduction
to the features of Oracle Real
Application Clusters (RAC) as well as the tasks necessary to properly install,
configure and maintain an Oracle RAC cluster. Students will learn how
Oracle RAC works, the components necessary to create the RAC cluster and how
to administer it. This will include how to configure Cluster Ready
Services (CRS), the Oracle Database instances, and Oracle Net in a RAC
environment.
Download
a course description
Oracle for Business Intelligence Users:
Oracle Answers
(Oracle BI EE Analytics) for
End Users (2-day)
This
course introduces students to the querying and analytical capabilities of Oracle
Analytics (Oracle BI Enterprise Edition) using the web interface. Students will
learn to create, modify, run, and refine ad hoc queries. They will learn to
view, chart, and analyze multidimensional data. They will also learn to produce
individual ad hoc reports.
Download
a course description
Oracle Analytics
(Oracle BI EE) Training for Administrators (2-day)
This
course gives students hands-on experience with setting up the Oracle Analytics
end user data access environment. Students will practice administrative tasks
using Oracle’s Administration Enterprise Edition tool. Students will learn to
create the RPD data definition repository and create and manage business areas.
Students will learn how to hide the complexity of the data source and provide a
user-friendly view of the data for end users.
Download
a course description
Oracle Discoverer
Training for
End Users (2-day)
This
course introduces students to the querying and analytical capabilities of Oracle
Discoverer. Students will learn to create, modify, run, and refine ad
hoc queries. They will learn to view, chart, and analyze multidimensional data.
They will also learn to produce individual ad hoc reports. Dan
has course materials for both Desktop and Web versions of Discoverer.
Download
a course description
Oracle Discoverer
Training for Administrators (2-day)
This
course shows all the ins and outs of building and maintaining Oracle
Discoverer EUL's. This course covers how to build and implement best
practices of the Discoverer environment including importing/permissions/and
recovery.
Download
a course description
Oracle for Business Intelligence
Users (Introduction to SQL for End Users)
Get
the most out of your investment in SAS, Cognose, Business Objects and your Data
Warehouses with this 2-day
workshop. This workshop focuses on teaching the skills
necessary so that your user community can construct better SQL that will better
utilize your existing investment in both your data warehouse and business
intelligence tools. Better SQL in
these tools results in better answers in a shorter amount of time. This
course also covers using ODBC drivers with MS tools.
- 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)
Download
a course description
Dan also uses available courseware to provide
additional training for your needs. Click here to review these
additional offerings.
Introduction to Oracle: SQL,
PL/SQL, and SQL *Plus
Introduction to Oracle
Introduction to Unix/Linux
Download
my course summary
|
