Oracle SQL Developer

    

Summary:
SQL Developer is a graphical integrated development environment from Oracle that enhances the productivity of SQL and PL/SQL developers. Developers and sophisticated end-users can create 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.

Duration:
2 Days/Lecture & Lab

Audience:
This course is designed for:-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 or reporting-Technical managers who need to perform ad hoc queries or reporting

Topics:

• Installing and upgrading SQL Developer
• Working with database connections
• The Petsaver database
• Viewing, changing and saving data without SQL
• Working with SQL
• Advanced SQL features
• The SQL Developer interface
• Working with tables, indexes and views
• Understanding the SQL Developer PL/SQL Editor
• Writing PL/SQL
• Debugging PL/SQL
• More features of the SQL Developer interface
• Data dictionary reports in SQL Developer
• User defined reports in SQL Developer

Prerequisites:
A basic understanding of databases is required to succeed in this class. Students attending without this will experience difficulty. Experience with Skill with GUI interfaces will be also be helpful.

Last Update: May 24, 2013