Hotsos Symposium Speaker – Karen Morton
Karen Morton is a returning Hotsos Symposium presenter.
Biography
Karen 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: