Back

PLSQL Best Practices with Steven Feuerstein

We’re always talking about best practice this, best practice that…well, this free tutorial teaches you what you should never do when writing programs in Oracle PL/SQL.  The advice ranges from attention to the smallest details, such as the problem with VARCHAR2(n) declarations to ways that we write SQL statements in our PL/SQL programs. Attendees of the webcast will come away with a deeper appreciation for the traps into which we can fall, and how to climb on out and bask in the sunshine of high quality code.

Steven Feuerstein is an expert on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O’Reilly Media). Steven has been developing software since 1980, spent five years with Oracle back in the “old days” (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014 – at which point he returned joyfully to Oracle Corporation. He was one of the original Oracle ACE Directors and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG’s Lifetime Achievement Award (2009).

Follow Steven on Twitter: @sfonplsql (with an added bonus of his personal Twitter account @stevefeuerstein)
Blog: stevenfeuersteinonplsql.blogspot.com

This free training is segmented into several separate lessons:

  1. Introduction (4:02) (click on video below)
  2. Best Practices with VARCHAR2 (7:23)
  3. Best Practices with Overloading (10:10)
  4. Best Practices with Error Handling (5:00)
  5. Best Practices with Bulk Processing (9:42)
  6. Best Practices with Top Down Design (8:35)
  7. Summary (3:06)

 

Date: Oct 25, 2011


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.