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

This course will teach you how to boost your productivity using Oracle SQL Developer. It's packed with tons of cool features and useful wizards which can make doing common database tasks, against databases, both on-prem and cloud, a breeze.

Oracle SQL Developer is a fantastic productivity tool. In this course, Getting Productive with SQL Developer, you’ll learn to use this free database IDE efficiently and effectively, against databases both in cloud and on-prem. First, you’ll explore how to perform common development tasks like query writing, creating, and browsing database objects like tables, views, procedures, functions, and packages. Next, you’ll discover various features of the tool like exporting and importing data in various formats, data modeling utility, extensive monitoring and debugging capabilities, and support for performing critical DBA tasks. Finally, you’ll learn how to use several productivity enhancement features and wizards like creating code snippets and code templates as well as writing reports and using the command line interface for automating tasks.When you’re finished with this course, you’ll have the skills and knowledge of using this powerful tool to efficiently perform your day to day development and DBA tasks.

Syllabus

  • Course Overview 2mins
  • Introduction 11mins
  • Installing SQL Developer and Connecting to Databases 22mins
  • Browsing the Database, Creating, and Modifying Objects 30mins
  • Easy SQL Querying and Reuse with Code Snippets and Code Templates 30mins
  • Discovering Database Using Data Modeler 19mins
  • Exporting and Importing Data 19mins
  • Debugging Program Units Using SQL Developer 31mins
  • Executing DBA tasks 24mins
  • SQL Developer Reports and Command Line Interface 56mins
  • Exploring Database Actions 47mins

Taught by

Pankaj Jain

Reviews

4.1 rating at Pluralsight based on 18 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.