Oracle SQL Developer : Essentials, Tips and Tricks
4.4 (3,952 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
68,253 students enrolled

Oracle SQL Developer : Essentials, Tips and Tricks

Use Oracle SQL Developer like a Pro. Learn the features and tricks that will help you be the most productive developer.
Bestseller
4.4 (3,952 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
68,253 students enrolled
Last updated 6/2020
English
English
Current price: $29.99 Original price: $49.99 Discount: 40% off
3 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 2 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will learn how to Install and customize SQL Developer in a way that works and feels best for you
  • You will learn how to take full advantage of all the basic features of the tool
  • You will learn how to create and share beautiful and interactive reports
  • You will take advantage of many useful features that will make you more effective and efficient at work
  • You will learn a lot of tricks and enjoy being seen as an SQL Developer expert
Requirements
  • You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs
  • Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary.
Description

Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.

If you are one of them, this  course will help you get out of that group and start using Oracle SQL Developer more smartly.

Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.

Learn the features that can help you work with your Oracle database better and faster:

  • Install and customize SQL Developer in a way that works and feels best for you.

  • Take full advantage of the most useful features of the tool.

  • Create and share beautiful and interactive reports.

  • Take advantage of features that will make you more effective and efficient at work.

  • Learn a lot of tricks and enjoy being seen as an SQL Developer expert.


All Oracle SQL Developer features are free. Take advantage of them:

This course was created because there appears to be a pattern among Oracle SQL courses, regardless of the platform where they are taught: “If you are able to install it and connect to a database, you are good to go".

What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.

The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job, so that  you can be more efficient and productive, and thus, stand out.


Content and Overview:

The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer.

There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.

The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.

Learn these tips and apply them to your work, and you will not only be well prepared to learn SQL or work with it more smartly, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.


Who this course is for:
  • Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition.
  • Aspiring application or database developers looking to work with Oracle databases.
  • Anyone taking or planning to take Oracle SQL or PL/SQL courses.
  • College/University students who need to learn and use SQL for Oracle to pass their database-related courses.
Course content
Expand all 45 lectures 03:39:39
+ Introduction
2 lectures 04:25
Course Structure and How to Take Advantage of it
02:09
+ Program Installation
2 lectures 04:44
Reminder: You need an Oracle Database Already Installed! Don’t have one?
00:22

In this lecture you learn how to download and install Oracle SQL Developer. If you already know how to do it, you can safely skip this lecture.

Downloading and installing SQL Developer
04:22
+ Oracle SQL Developer Basics
5 lectures 20:54
Introduction (SDB)
00:48
Creating and Organizing Database Connections
06:23
Working with the Worksheet
04:58
Working with the Results’ Grid
05:20
+ Useful Customizations
7 lectures 22:58
Introduction (UC)
00:40
Changing the Language
03:58
Disabling Features you Don't Need
02:31
Improving the way Data is Displayed
03:16
Advanced Code Formatting
07:13
Navigation Filtering
01:31
Customizing Fonts and Syntax Colors for Eye Comfort
03:49
+ Reports
8 lectures 54:05
Introduction (R)
00:57
Predefined Reports Overview and Reports Basics
04:49
User-Defined Reports Basics
06:15
Master-Detail and Drill Down Reports
09:12
Gauge Reports
06:04
Chart Reports
11:09
A Final Reports' Trick
08:15
+ More Useful Features, Tips and Tricks
18 lectures 01:34:46
Introduction (MUF)
00:36
Splitting Worksheets and Document Groups
05:55
Exporting data
07:07
Code Templates
03:43
Code Snippets
02:57
Taking Advantage of The Line Gutter
02:23
Performing Local Searches on Your Results
04:21
Testing Program Units Smartly
04:47
Debugging Program Units Smartly
12:52
Finding Database Objects
03:59
Getting Information about a Database Object
03:17
Oracle Folks Love Drag & Drop
04:38
Generating Relational Diagrams
04:37
Navigating Your Code
07:20
Performance Tuning Features
10:52
Displaying Gauges
03:25
Useful Tips and Shortcuts 1
06:21
Useful Tips and Shortcuts 2
05:36
+ Extras
3 lectures 17:46

In this lecture you learn how HTML can be used in your code and some of SQL Developer's settings. A pretty cool but mostly unknown feature.

Using HTML in SQL and in preferences
05:23

In response to students' feedback, I decided to add this lesson to show you how to download and install the database software on a Windows machine, although having a database already installed is one of the prerequisites of this course.

This lesson is an excerpt from my Oracle SQL course.

Appendix 1: Installing Oracle Database Express Edition 18c On Windows
11:21

Get access to additional content, and learn how to connect with Carlos!

Bonus Lecture: Discounts for other courses
01:02