Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Getting Productive with SQL Developer

via Pluralsight

Overview

Oracle SQL Developer is a very popular free Graphical user interface. This course will teach you about this tool and see how it makes database development and management a breeze, for database developers, DBAs, and analysts.

This IDE is packed with tons of cool features to significantly boost productivity and making executing the day to day tasks for both the database developers and DBAs a breeze. This tool allows you to write complex queries, explore the database and provides a complete development platform for Oracle PL/SQL applications. In this course, Getting Productive with SQL Developer, you will get an in-depth look at this tool. First, you'll discover how to download, install, and get started with Oracle SQL Developer. Next, you'll explore schemas and creating database objects. Then, you'll discover how to run and debug programs. Finally, you'll learn how to write powerful and visually appealing reports and automating tasks using the SQL Developer Command Line interface. By the end of this course, you'll have a solid foundation to get started and be productive with Oracle SQL Developer.

Syllabus

  • Course Overview 1min
  • Overview 9mins
  • Installing Oracle SQL Developer and Connecting to Databases 19mins
  • Browsing the Database, Creating, and Modifying Objects 28mins
  • Easy SQL Querying and Reuse with Snippets and Code Templates 28mins
  • Discovering Database Using Data Modeler 19mins
  • Exporting & Importing Data 17mins
  • Debugging Program Units Using SQL Developer 25mins
  • Executing DBA Tasks 24mins
  • SQL Developer Reports & Command-line Interface 60mins

Taught by

Pankaj Jain

Reviews

4.5 rating at Pluralsight based on 41 ratings

Start your review of Getting Productive with SQL Developer

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.