Oracle SQL Developer : Tips and Tricks
4.4 (1,277 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.
24,662 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL Developer : Tips and Tricks to your Wishlist.

Add to Wishlist

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 (1,277 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.
24,662 students enrolled
Created by Carlos De Leon
Last updated 3/2017
English
English [Auto-generated]
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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...
View Curriculum
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.
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 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.


Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:16:37
+
Introduction
1 Lecture 02:08

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

Introduction
02:08
+
Program Installation
2 Lectures 06:41
Reminder: You need a database. 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
06:19
+
Tips and Useful Features
16 Lectures 49:30

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

Changing the language
02:33

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

Creating database connections
02:42

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

Disabling features you don't need
02:52

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

Executing commands and scripts
02:24

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

Displaying line numbers (The Line Gutter)
02:10

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

Formatting Code
05:11

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

Displaying nulls in a special way
01:45

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

Displaying results in different tabs
03:33

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

Exporting data
06:12

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.

Using code templates
03:38

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

Using Code snippets
02:33

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

Generating Relational Diagrams
04:31

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.

Navigation Filtering and Zebra Pattern
02:07

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.

Useful shortcuts
04:37

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

Useful Shortcuts 2
02:38

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

Enjoy!

Cheat Sheet: Summary of Features and Tips
00:04
+
Extras
4 Lectures 18:24

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
06:55

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

Displaying Gauges
02:43

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.

Appendix 1: Installing Oracle Database Express Edition On Windows
07:42

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

Bonus Lecture: Discount for my Oracle SQL course
01:04
About the Instructor
Carlos De Leon
4.4 Average rating
1,331 Reviews
24,829 Students
2 Courses
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.