| Course Name |
Hours |
List Price |
Content |
| MySQL Administration |
14.00 |
$999.00 |
|
Description: This 2-day class walks the admin through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning.
# of Days:
Setting:
|
| MySQL Administration and Development |
28.00 |
$1,999.00 |
|
Description: This 4-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. MySQL is the open source communitys most popular Relational Database Management System (RDBMS)
offering, and is a key part of LAMP Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs. This course covers MySQL 5.5.
# of Days:
Setting:
|
| MySQL Development |
21.00 |
$1,499.00 |
|
Description: This 3-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, and learn about optimization.
# of Days:
Setting:
|
| Oracle SQL Optimization for Developers and DBAs |
21.00 |
$1,920.00 |
|
Description: This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMSSTATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented.
Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures.
This course can be taught for any Oracle version.
|
| Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs |
14.00 |
$1,195.00 |
|
Description: This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. This course can be taught for any Oracle version.
|