
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.
Master the Oracle SQL developer worksheet by opening connections, writing semicolon-terminated statements, and running queries, and view results in the grid or script output pane.
Change the SQL Developer user interface language with two methods: edit sqldeveloper.conf to add -Duser.language=en, or adjust the shortcut target; also check ide.boot for oracle.translated.locales.
Disable unused features in Oracle SQL Developer to improve startup time and simplify the user interface by selectively turning off groups like noSQL, OLAP, Apex, and migrations, then restart.
Explore how to use the reports pane in SQL Developer to save time, access hundreds of predefined reports, and create your own customizable reports with text, gauges, and charts.
Explore predefined data dictionary reports in Oracle SQL Developer, learn bind-variable parameterization, owner filters, and how to copy SQL, pin results, and set auto refresh.
Create and customize user-defined reports in Oracle SQL Developer by creating new reports, cloning predefined ones, or saving query results as reports, then refine with bind variables to filter data.
Learn to build master-detail and drill-down reports in Oracle SQL Developer, linking master and child queries with bind variables and creating department–employee drill-down workflows.
Explore gauge reports in Oracle SQL Developer, learn how to create dial gauges as child reports, and configure min, max, and thresholds while driving dynamic values from queries.
Export report definitions as XML or generate HTML with assets for easy sharing, and use the command line to automate HTML reports. Note this is not an enterprise solution.
Maximize your SQL Developer workspace by using document groups, splitting worksheets, and detaching or moving tabs to view multiple editors and tables at once.
Learn to generate relational diagrams for tables in SQL Developer, use the model view and data modeler, and print or export diagrams while including parent and child tables.
Explore SQL Developer's performance tuning features, including explain plan and autotrace for execution plans, the hotspot button, instance viewer, and the SQL tuning advisor with licensing notes.
Display gauges in query results to visualize values using min, max, low and high thresholds, with a value expression such as salary; make gauges dynamic with analytic functions.
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 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.
Get access to additional content, and learn how to connect with Carlos!
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 and the database community in general: “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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.