Toad World > Knowledge > Database Knowledge > Steven Feuerstein's PL/SQL Obsession

Home

Products

Community

Knowledge

Downloads

Site Map

Hello, you are not logged in. Login or sign up

Knowledge >> Database Knowledge >> Steven Feuerstein's PL/SQL Obsession >> Practical Best PL/SQL Video Series


		Practical Best PL/SQL Video Series

Learn how to write the best PL/SQL code of your life!

We all want to "do the right thing" when it comes to code. We want our programs to run fast, have the fewest bugs possible, and be easy to understand, maintain and upgrade. Easy to say, hard to do -- without the right guidance and right tools. Join Steven Feuerstein, PL/SQL Evangelist of Quest Software, as he explores key best practices for PL/SQL development and learn how they fit into a development workflow that produces high quality code.

This series of videos produced by Steven Feuerstein will open your eyes to ways of writing (and testing) PL/SQL programs that will result in code you can be proud of, and code that will make your company more successful. We encourage you to watch them in order, but you can also pick and choose according to your own interests and challenges.

Practical Best PL/SQL Video Series:
Note: This series is in progress. Greyed titles will be coming soon.

Agenda (20mb)
Overall perspectives on writing software (39mb)
Establish a foundation of shared code for team development (19mb)
- Apply coding standards and naming conventions (40mb)
- SPODify your code: aim for a Single Point of Definition (62mb)
- Manage exceptions with shared utility
- Break your addiction to SQL
Best practice workflow for writing individual programs
- Stop guessing and start testing your code
  - (continued). Testing options for PL/SQL
- Say no to spaghetti code, say yes to Extreme Modularization
- Two heads are better than one: code review and analysis
- Turbo-charge performance of your PL/SQL programs
Maximize readability in your code

Note: these videos are not meant to be in-depth trainings, but introductions to key concepts and quick recommendations for implementation. You can find more complete resources for PL/SQL development at PL/SQL Obsession.