Hotsos Symposium Speaker – Karen Morton

Karen Morton is a returning Hotsos Symposium presenter.

Biography

Karen MortonKaren Morton is a Senior Technical Consultant for Enkitec based in Irving, Texas. For more than 20 years, Karen has worked in information technology starting out as a mainframe programmer, developer, DBA, data architect, author, researcher, educator and consultant.

Having used Oracle since the early '90s, she began teaching others how to use Oracle over a decade ago. Her specialty is in Oracle performance optimization, particularly SQL tuning and the optimizer. Karen is the co-author of three books from Apress: Beginning Oracle SQL, Expert Oracle Practices: Database Administration from the Oak Table and Pro Oracle SQL.

She is a frequent speaker at conferences and user groups, an Oracle ACE and a member of the OakTable Network.

Presentation Titles

Session 1: Fat to Fit: SQL Development Fitness

Session 2: Optimizing and Simplifying Complex SQL with Advanced Grouping

Abstracts

Session 1: Fat to Fit: SQL Development Fitness — If you want to improve your fitness level or lose weight, you start with a plan for how to eat and workout that will lead to optimal results. It's really no different if you want to improve the health and fitness of your application SQL.

This presentation reviews six simple health and fitness steps that you can use to get your SQL (and yourself too!) in the best shape ever.

1. Know Thyself (Thy Data)
2. Change Your Attitude
3. Know How Much You're Eating (How Much Your SQL Eats)
4. Start Exercising
5. Learn About Nutrition
6. Keep At It

Session 2: Optimizing and Simplifying Complex SQL with Advanced Grouping — No doubt you are aware of the advanced grouping features found in Oracle SQL, operators such as GROUPING(), CUBE(), GROUPING_ID() and GROUPING_SETS(). Like many though you may not be sure how to take advantage of these operators. What do they do, and why should you use them?

This presentation will show how these features can be used to simplify SQL that was previously quite complex by reducing the amount of code needed and improving readability, and perhaps most importantly, greatly optimizing the performance of SQL statements.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: