YoVDO

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

Offered By: Oracle via YouTube

Tags

APIs Courses Data Manipulation Courses Database Management Courses Stored Procedures Courses

Course Description

Overview

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


Taught by

Oracle

Tags

Related Courses

Creating Programmatic SQL Database Objects
Microsoft via edX
Developing SQL Databases
Microsoft via edX
Advanced Relational Database and SQL
Coursera Project Network via Coursera
SQL Functions
Coursera Project Network via Coursera
Master C# And SQL By Building Applications
Udemy