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.
Author Name: Pankaj Jain
Author Description:
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Table of Contents

• 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