O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In our final look at SQL, we've examined some of the issues that are important in real-world SQL development. We've seen how SQL can be integrated into other programming languages, such as Perl and Java. We examined the Oracle optimizer and how statistics gathering and EXPLAIN PLAN can be used to produce efficient SQL code. We've looked at several complex SQL statements that utilize many of the aspects of SQL we have learned and broken them down into logical, more manageable components. Finally, we have laid out a preparation strategy for taking the SQL certification exam and looked at some helpful hints.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required