Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle SQL Developer

Recommended Duration:
1-2 Days
Version: Most Current
Course can be taught with earlier versions of the tool.
Benefits
SQL and PL/SQL developers will learn to use this tool to create, test, and improve SQL and PL/SQL.
Audience
People who create, test, and improve Oracle SQL and PL/SQL.
Prerequisites
No prior experience is necessary; some prior Oracle SQL and/or PL/SQL experience is helpful.
 
Exercises
There are ten hands-on exercises.
Major Topics
  • SQL Developer Preferences
  • Code Assist
  • Formatting
  • Shortcut Features
  • Working with JSON
  • Outputting: csv, xml, INSERT, load
  • SQL Developer Tools
  • SQL Developer and PL/SQL
  • Autonomous PL/SQL blocks
  • DBMS_OUTPUT
  • PL/SQL Procedures, Functions, Packages, Triggers
  • Compiling, testing PL/SQL
  • Source repositories: Git, CVS
  • Unit Testing
  • EXPLAIN PLAN
  • AUTOTRACE
  • Data Modeling Features
  • (optional) DBA Tools
  • ORDS features
  • SQL Developer Built-In Reports
  • Short-cuts, tips, and tricks