Tips and Tricks for SQL Developer and SQL Developer Command Line - Increasing Productivity

Discover powerful tips and tricks to enhance productivity in SQL Developer and SQL Developer command line in this 33-minute Oracle session. Learn how to save keystrokes and mouse-clicks while working with data, stored procedures, and APIs. Explore modern tooling that empowers users, including features like clicking into objects, customizing options, and utilizing the DBA panel. Gain insights into formatting, upcoming Data Guard and Data Pump functionalities, and JavaScript integration. Master the Command Palette for efficient coding, create charting dashboards, and learn to build REST APIs using SQL and PL/SQL knowledge. Understand how to enable existing PL/SQL code and generate DDL in SQL Developer Data Modeler. Walk away with practical skills to boost productivity and enjoy working with these Oracle tools.

Syllabus

Intro
Modern Tooling Empowers Users, Increases Productivity
Today's Goal: 3 Power Tips for Each Product Quick, fun, transformative
SQL Developer FREE
Click into Objects
TIP 82: Don't use the default options
TIP 83: Double your Feature Set - Open the DBA Panel
Formatting
Data Guard & Data Pump, Coming Soon!
JavaScript
Meet the New Boss, Same as the Old Boss
TIP 12: Command Palette - Everywhere you code
TIP 3: Charting Dashboards are the new Awesome
Know SQL, PL/SQL? You can build REST APIs!
Already wrote your PL/SQL? Just Enable it!
SQL Developer Data Modeler
TIPS: Generate DDL