Getting Productive with SQL Developer

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.
Course info
Level
Beginner
Updated
April 20, 2017
Duration
3h 53m
Table of contents
Overview
9m 15s
Description
Course info
Level
Beginner
Updated
April 20, 2017
Duration
3h 53m
Description

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.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
More courses by Pankaj Jain
Transcript
Transcript

Hello everyone, my name is Pankaj Jain and I am very excited to welcome you to my course, Getting productive with Oracle SQL Developer.

Oracle SQL Developer is a very popular free Graphical user interface widely used by developers and dbas around the world. 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 we will take an in-depth look at this tool. You may be a beginner with Oracle SQL Developer or an experienced user, I am very confident you will find some useful tips and tricks that you can take away from this course. No prior experience with Oracle SQL Developer is required.

Some of the major topics that we will cover include:

  • Downloading, installing and getting started with Oracle SQL Developer2
  • Exploring schemas and creating database objects
  • Writing complex queries with ease using the visual query builder and intelli-sense
  • Enhancing productivity using the code templates and snippets
  • Running and debugging program units
  • Reverse engineering the database using data modeler, database copy and diff and other DBA functions
  • Writing powerful and visually appealing reports and automating tasks using the SQL Developer Command Line Interface
By the end of the course, you will have a solid foundation to get started and be productive with Oracle SQL Developer.

I hope you’ll join me on this journey to learn about this wonderful tool with the Getting productive with Oracle SQL Developer course, at Pluralsight.