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
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.