|
Date: July 18th, 2001 Location: Royal Sun Alliance Topic: Oracle PL/SQL Best Practices A one-day seminar for the Charlotte Oracle User Group by Steven Feuerstein The Oracle PL/SQL Best Practices seminar is built around Steven's latest book of the same title and is designed to help you write code that can be maintained effectively, is thoroughly tested and handles errors robustly. Topics included... q Writing SQL in PL/SQL: its very easy -- perhaps too easy -- to write SQL into your PL/SQL application. Unfortunately, your data structures are always changing -- and breaking your code. The seminar shows how to write SQL in PL/SQL so that your code base adapts easily (in many cases, automatically) to changes in the underlying data design. q Effective Unit Testing: Few developers test their code thoroughly and even fewer have developed or adopted processes and tools that help us test effectively. The seminar will introduce you to PLSQL, an open source unit test framework that can dramatically the quantity and quality of unit testing you do q Deploying an Exception Handling Architecture: Trapping and handling errors are crucial, but neglected, aspects of most PL/SQL applications. We will explore features of PL/SQL exception handling, identifies common problems with coding for exceptions, and build architecture for consistent error handling throughout one's application. q Building Modular Code: It's hard to write high quality code if you do not build in small, testable units and reuse existing code. The Best Practices seminar presents an array of recommendations for package and module construction, reinforcing important principles with many examples of reusable code. Presenter: Steven Feuerstein Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of six books on PL/SQL. Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992. Finally, Steven is president of the Board of Directors of the Crossroads Fund, which makes grants to Chicagoland organizations working for social, racial and economic justice (www.CrossroadsFund.org). You can reach Steven at steven@stevenfeuerstein.com.
|