Pro Oracle SQL

Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior Technical Consultant for Enkitec. For more than 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a database administrator, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90s, she began teaching others how to use Oracle over a decade ago. Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of "Oracle scientists" that are well known throughout the Oracle community). She blogs at karenmorton.blogspot.com.

• * Core SQL * SQL Execution * Access and Join Methods * SQL is About Sets * It's About the Question * SQL Execution Plans * Advanced Grouping * Analytic Functions * The Model Clause * Subquery Factoring * Semi-joins and Anti-joins * Indexes * Beyond the SELECT * Transaction Processing * Testing and Quality Assurance * Plan Stability * Plan Management/Control * Cool SQL Constructs