The purpose of this module is to address the issues surrounding the development and tuning of SQL statements in an Oracle database shop. Historically, the development of SQL has been fragmented with the development staff writing SQL and the DBA staff tuning the SQL statements.
Now, with the evolution of Oracle8 and the use of SQL in stored procedures, the DBA is taking a more active role in the approval and tuning of all SQL statements that run against the database because the tuning of SQL statements can have more positive impact than almost any other tuning activity.
This module will show the various roles of the developer and the DBA as well as discuss methods and standards that the DBA can use to ensure quality and consistency of SQL development. Topics in this module include:

1. Identifying the roles of the DBA in SQL tuning
2. Enforcing SQL standards
3. Working with SQL developers
4. Using SQL in stored procedures

Let us get started by identifying the roles of the DBA in SQL tuning.