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:
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.
This lecture explains how the course content is structured and gives recommendations on how to take full advantage of it.
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.
This lecture explains how to change the language of SQL Developer's user interface
This lecture shows how to create database connections in SQL Developer. Special emphasis is made about defining a connection color, to avoid dangerous mistakes.
SQL Developer has many features not everyone will need or use. This lecture explains how to disable unneeded ones.
In this lecture you learn the different ways available to execute commands and scripts in SQL Developer.
This lecture explains how to use the line gutter to display line numbers and mark text more easily on SQL Developer's text editor.
This lecture explains how you can use and customize SQL Developer's code formatter.
This lecture explains how you can define the way nulls are displayed by SQL Developer to be more easily recognizable.
This lecture explains the different ways in which query results can be displayed in separate tabs.
This lecture explains different and interesting methods to export data and generate formatted output with SQL Developer.
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.
This lecture explores SQL Developer's code snippets feature, which can simplify your work with occasionally used or complex commands.
In this tip you will learn different methods to generate relational diagrams from your tables. Very useful for documenting your designs.
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.
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.
Here you have some other very useful keyboard shortcuts to help you be more efficient when working with SQL Developer.
Here you have a summary of most of the features, tips and shortcuts included in the course (downloadable).
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.
In this lesson you will learn how to display beautiful gauges in the results of your queries.
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.
Get access to additional content, and learn how to connect with Carlos!
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.