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
Rating
(18)
Level
Beginner
Updated
Apr 20, 2017
Duration
3h 54m
Table of contents
Course Overview
Overview
Installing Oracle SQL Developer and Connecting to Databases
Browsing the Database, Creating, and Modifying Objects
Easy SQL Querying and Reuse with Snippets and Code Templates
Discovering Database Using Data Modeler
Exporting & Importing Data
Debugging Program Units Using SQL Developer
Executing DBA Tasks
SQL Developer Reports & Command-line Interface
Description
Course info
Rating
(18)
Level
Beginner
Updated
Apr 20, 2017
Duration
3h 54m
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
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
More courses by Pankaj Jain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Pankaj Jain and I'm 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 developers and DBAs a breeze. This tool allows you to write complex queries, explore the database, and provide a complete development platform for Oracle PLC 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'm 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 Developer, exploring schemas and creating database objects, writing complex queries with ease using the visual query builder and intellisense, enhancing productivity using the core templates and snippets, running and debugging program units, reverse engineering the database using data modeler, database copy and div, and other DBF functions, writing powerful and visually appealing reports, and automating tasks using the SQL Developer command line interface. By the end of this course you will have a solid foundation to get started. And be productive with Oracle SQL Developer. I hope you will join me on this journey to learn about this wonderful tool with The Getting Productive with Oracle SQL Developer Course at Pluralsight.