Oracle SQL Developer: Mastering its Features + Tips & Tricks
All LevelsOffice ProductivityOracle SQL

Oracle SQL Developer: Mastering its Features + Tips & Tricks

Use Oracle SQL Developer like a Pro: Learn the features & tricks that will help you be the most admired SQL developer

Created by Carlos DL, Standout-Dev Academy
3.5 hours
Video Content
45
Lectures
77,319
Students
4.6
Rating
4.6
(77,319 students enrolled)

What you'll learn

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
You will learn how to create and share beautiful and interactive reports
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

Course Content

7 sections • 45 lectures • 03:40:01 total length

Introduction

2 lectures • 04:23

Course Structure and How to Take Advantage of it02:09
What this course IS and IS NOT02:14

Program Installation

2 lectures • 04:44

Reminder: You need an Oracle Database Already Installed! Don’t have one?00:22
Downloading and installing SQL Developer04:22

Oracle SQL Developer Basics

5 lectures • 20:54

Introduction (SDB)00:48
User Interface Basics03:25
Creating and Organizing Database Connections06:23
Working with the Worksheet04:58
Working with the Results’ Grid05:20

Useful Customizations

7 lectures • 22:58

Introduction (UC)00:40
Changing the Language03:58
Disabling Features you Don't Need02:31
Improving the way Data is Displayed03:16
Advanced Code Formatting07:13
+2 more lectures

Reports

8 lectures • 54:05

Introduction (R)00:57
Predefined Reports Overview and Reports Basics04:49
User-Defined Reports Basics06:15
Master-Detail and Drill Down Reports09:12
Gauge Reports06:04
+3 more lectures

More Useful Features, Tips and Tricks

18 lectures • 01:35:09

Introduction (MUF)00:36
Splitting Worksheets and Document Groups05:55
Exporting data07:07
Code Templates03:43
Code Snippets02:57
+13 more lectures

Extras

3 lectures • 17:48

Using HTML in SQL and in preferences05:23
Appendix 1: Installing Oracle Database Express Edition 18c On Windows11:21
Bonus Lecture: Discounts for other courses01:04

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 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.


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.

This course includes:

  • 3.5 hours on-demand video
  • 2 articles
  • 6 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

Carlos DL

Standout-Dev Academy

Students also download

Explore related courses to expand your learning journey.