A real Oracle SQL hacking session. No foils. Just the audience, the speaker, Java and an Oracle database. Learn how understanding Oracle internals can really make your application scale. We’ll look at topics like joins, fetch size, lobs, logical vs physical IO, clustering factor etc.
This video is a short overview of database administration features available in Oracle SQL Developer v4.0.
Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis. Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database …
This video explores key best practices for PL/SQL development and learn how they fit into a development workflow that produces high quality code. This episode discusses coding standards and naming conventions.
Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.
This lecture covers the concept of the importance of good database design for Oracle. It covers the concepts of Objects and Entities and how to identify dependencies and relationships between the objects. It is an introduction to the design concept in preparation for creating ERD diagrams that will be discussed …
