• When and How to Write SQL in PL/SQL with Steven Feuerstein (Recorded Webcast Event)

    Oracle PL/SQL makes writing SQL so darned easy – in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code.
     
    This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names.
     
    After viewing this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability.
     

    Duration: 60 minutes

    This content is intended for the following job role(s): Application Express Developer, PL/SQL Developer

    Release Date: 09-JUL-2014

    Created by: Steven Feuerstein

Embed You Tube Videos

Reviews (3)

  • 10.6 years ago
    rajini.6
    Really helpful video on sql for developers. Highlighted good points on using advaned feature of SQl.
    • 10.7 years ago
      vijay.badam
      I have a 15+ years experience in SQL, PLSQL. There is always plenty of opportunity to learn new stuff. Wanted to give feedback on couple of areas. Audio Quality needs to be improved. When showing the code from SQL Developer, if you could zoom to the same level as the presentation would be great. Also more code examples would be very nice. Overall , it was very nicely done presentation in terms of the subject. Appreciate it.
      • 10.7 years ago
        omarsawalhah
        -

        Buttons