Our 5-day lab-based course transforms application developers and database administrators into fearless SQL optimizers. Here, students learn to measure performance instead of guessing about it, using an efficient performance testing harness that the students keep. The course produces faster students writing faster SQL that will scale efficiently to handle your production workloads.

C. J. Date is the world’s best known relational advocate. His innovative approach to teaching database design theory will help you create robust, flexible, and accurate real-world databases. This seminar will benefit professionals using Oracle, SQL Server, MySQL, PostgreSQL, and DB2 systems alike. Read more...

C. J. Date is the world’s best known relational advocate. In this seminar, he shows you how to write SQL code that’s logically correct; how to avoid various SQL traps and pitfalls; and, more generally, how to use SQL as if it were a true relational language. This seminar will benefit professionals using Oracle, SQL Server, MySQL, PostgreSQL, and DB2 systems alike. Read more...

Oracle trace data is an extraordinarily rich information source for database application developers, administrators, and anyone who cares about the speed of an Oracle Database application. Oracle trace files include information that yields value throughout your software life cycle, whether you’ve bought prebuilt applications or built them yourself. This course, designed and taught by Cary Millsap, is your fast track to becoming a master of this commonly underutilized data source. Read more...