Overview
SQL Developer is a graphical integrated development environment from Oracle that, when used well, enhances the productivity of SQL and PL/SQL developers.
SQL Developer provides capabilities to create and maintain database objects such as tables, indexes and views and to create, debug, tune and maintain SQL code and PL/SQL procedures, functions and triggers.
Developers and sophisticated end-users can also create and preserve ad hoc database queries or user defined reports through the SQL Developer interface.
SQL Developer also provides utility functionality such as migrating database objects from schema to schema and monitoring and profiling PL/SQL execution.
This class is relevant to SQL Developer versions 1.1 through 1.5.
Intended audience
Novice and intermediate Oracle SQL developers and DBAs
Novice and intermediate Oracle PL/SQL developers and DBAs
Oracle application users with needs to perform ad hoc queries and/or reporting
Technical managers with needs to perform ad hoc queries and/or reporting
Prerequisites
Skill with GUI interfaces
A basic understanding of SQL databases is required to succeed in this class. Persons attending without this will experience difficulty
Oracle Certification
There is presently no Oracle certification testing for SQL Developer.
Course Topics
-
The Petsaver Database
-
Installing and Upgrading SQL Developer
-
Working with Database Connections
-
Working with the SQL Worksheet
-
Introducing SQL Tuning
-
Advanced SQL Worksheet Features
-
Viewing and Modifying Data Without SQL
-
The SQL Developer Interface
-
Working with Database Objects
-
Writing PL/SQL
-
Debugging PL/SQL
-
SQL Developer Preferences
-
Pre-Defined SQL Developer Reports
-
Custom User Defined Reports
