Oracle SQL Developer

    

Summary:
Students attending this class will learn how to use the SQL Developer tool to write their Oracle SQL and PL/SQL programmatics. The class contains both lectures and extensive lab exercises.

Duration:
2 Days/Lecture & Lab

Audience:
This class is intended for Oracle Programmers, designers, analysts and other personnel who are interested in using the SQL Developer tool.

Topics:

• Introduction to SQL Developer
• Facilities provided by the SQL Developer Tool
• Browsing database objects and data
• Editing database objects and data
• Creating database objects
• Updating database objects
• SQL Developer Reports
• Creating reports
• Sharing reports
• Writing PL/SQL Code
• Editing PL/SQL code
• Debugging PL/SQL code
• Working with the files navigator
• Exporting data
• Importing data
• Using the database copy wizard
• Working with Application Express

Prerequisites:
There are no prerequisites for this course.

Last Update: May 23, 2012