Steven Feuerstein - Make the Most of the Best of PL/SQL- Best Practices
Tuesday, March 12, 2013 at 8:00 AM - Wednesday, March 13, 2013 at 4:30 PM (PDT)
Oracle has been packing the PL/SQL language full of features for years. This leaves programmers with two big challenges: first, being aware of the most important of these features. Second, you need to figure how to best apply these features so that the result is code which is easy to read, maintain and enhance.
Making the Most of the Best of PL/SQL starts off with a review of the most critical features of the PL/SQL language, including features added in 11g: if you are not using these features, you simply cannot be writing optimal applications in PL/SQL. From there, we will focus exxclusively on best practices: techniques for deploying key features, plus many ideas about how to improve the maintainability of your code.
Topics covered include:
- Techniques to avoid hard-coding in all its forms
- Best practices for writing SQL in PL/SQL
- Leveraging key package features, from overloading to session-persistent data
- Error management best practices
- Application tracing and testing
To help students absorb the material most effectively, Steven will demonstrate all techniques with code samples (available for download) and test students with quizzes throughout the seminar (prizes galore!).
Questions you might ask:
Question - "I took "High Performance PL/SQL & 11g PL/SQL New Features" last March. Is there two-days-worth of new material?"
Answer - "We will kick off the training with approximately an hour of review of critical features of the PL/SQL language. From that point, the focus will be on how to best apply those features and other aspects of the language in order to produce high-quality, highly maintainable code. So, yes, the vast majority of the coursework is new material, complementing what you learned in the earlier class."
Question - "I did not take "High Performance PL/SQL & 11g PL/SQL New Features" last March. Will I be completely lost?"
Answer - "Not at all. We will start the course with a quick review of key features and the role they play. If you did not take the High Performance course, that will be sufficient to set the stage for the rest of this class."
When & Where
Speak-Tech Seminars & Webinars
Speak-Tech is Minnesota-based and has organized webinars and seminars featuring the world’s leading Oracle experts for over 12 years.
Speak-Tech has organized over 100 training events for experts such as Jonathan Lewiis, Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha and David Kurtz, considered to be some of the world’s leading experts in Oracle Performance Tuning; Syed Jaffar Hussain, Oracle ACE Director who was awarded the Oracle Excellence Award for Technologist of the Year: DBA, 2011; Steven Feuerstein, considered to the world's leading expert in PL/SQL, Jim Czuprysnski and Matt Hart, all leading experts in their Oracle specialties.