Oracle SQL Developer : Tips and Tricks

Learn how to use Oracle SQL Developer and take advantage of its most useful features. Use it smartly.
4.4 (850 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
15,632 students enrolled
Free
Start Learning Now
  • Lectures 21
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course Description

Last Updated on 22/10/2016.

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 configure Oracle SQL Developer to run in your desired language and only with the features you need.
  • Create database connections and execute commands and scripts.
  • Display your results in a way that makes your work easier.
  • Use code templates and snippets to accelerate your work.
  • Export data in different formats and using different methods.
  • Some other useful and interesting things.


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.


Content and Overview:

The course includes more than 20 lectures, each one starting by showing you why you need it or how it can be helpful to you, and then proceeding to demonstrate how to enable it and/or use it.

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 smartly, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.


What are the 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 a 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.

What am I going to get from this course?

  • You will learn how to Install and configure SQL Developer to run in your desired language and only with the features you need
  • You will learn how to create database connections and execute commands and scripts
  • You will learn how to display your results in a way that makes your work easier
  • You will learn how to use code templates and snippets to write code easier and faster
  • You will learn how to export data in different formats and using different methods
  • And more...

What is the target audience?

  • Anyone taking or planing to take Oracle SQL courses
  • Aspiring application or database developers looking to work with Oracle databases
  • College/University students who need to learn and use SQL to pass their database-related courses
  • Application or database developers already working with Oracle databases who want to do their job in a smarter way

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

02:08

This lecture explains how the course content is structured and gives recommendations on how to take full advantage of it.

Section 1: Program Installation
06:19

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.

Section 2: Tips and Useful Features
02:33

This lecture explains how to change the language of SQL Developer's user interface

02:42

This lecture shows how to create database connections in SQL Developer. Special emphasis is made about defining a connection color, to avoid dangerous mistakes.

02:52

SQL Developer has many features not everyone will need or use. This lecture explains how to disable unneeded ones.

02:24

In this lecture you learn the different ways available to execute commands and scripts in SQL Developer.

02:10

This lecture explains how to use the line gutter to display line numbers and mark text more easily on SQL Developer's text editor.

05:11

This lecture explains how you can use and customize SQL Developer's code formatter.

01:45

This lecture explains how you can define the way nulls are displayed by SQL Developer to be more easily recognizable.

03:33

This lecture explains the different ways in which query results can be displayed in separate tabs.

06:12

This lecture explains different and interesting methods to export data and generate formatted output with SQL Developer.

03:38

This lecture explains how you can use code templates for commands you use frequently, which will allow you to write code quickly and be more productive.

02:33

This lecture explores SQL Developer's code snippets feature, which can simplify your work with occasionally used or complex commands.

04:31

In this tip you will learn different methods to generate relational diagrams from your tables.  Very useful for documenting your designs.

02:07

This lesson includes 2 tips:  How to enable filtering in the objects tree to make it easy to find things, and how to activate the zebra pattern in the results grid, which can make reading results easier.

04:37

This lecture contains several short but very useful tips and shortcuts that can really make your work with SQL Developer easier.


It covers the SQL history, auto-completing code, going to specific line numbers in the code editor, getting information about database objects quickly, switching between tabs easily with the keyboard.

02:38

Here you have some other very useful keyboard shortcuts to help you be more efficient when working with SQL Developer.

Article

Here you have a summary of most of the features, tips and shortcuts included in the course (downloadable).

Enjoy!

Section 3: Extras
06:55

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.

02:43

In this lesson you will learn how to display beautiful gauges in the results of your queries.

Article

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Carlos De Leon, Professional Software Developer & Trainer

Carlos is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for almost 20 years, and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for more than a decade.

His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time.

He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites.

In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy.

If you are into software or database development, make sure to check out Carlos's courses now.

Ready to start learning?
Start Learning Now