Oracle SQL Developer is a free tool provided by Oracle as a development environment for the SQL language. In this video, learn how to open SQL Developer and explore its graphical user interface.
- [Instructor] Oracle SQL Developer is an integrated development environment that allows you to work with the SQL language in your Oracle database. It actually allows for much more, but that's what we'll be using it for during this course. SQL Developer is provided for free from Oracle, and it uses Java, so in case you want to download SQL Developer and install it on your computer or laptop, make sure you have the Java Runtime Environment properly set up before doing so.
If you are using the Oracle Developer virtual machine, which I'll be using for the exercises and demos in this course, then you're in luck because Oracle SQL Developer is already installed. You can find an icon for opening Oracle SQL Developer on your desktop. So double click on this icon to launch Oracle SQL Developer. Note that Oracle SQL Developer is a SQL client. You can download it and install it on any machine, and assuming that you have network connectivity to your database, you can use it to execute your queries.
There are multiple other SQL clients that allows you to run queries in your Oracle database, but SQL Developer is the most commonly used one, as it provides a big set of features and a very easy-to-use UI. As you can see, we now have SQL Developer open. In our next video, you will see how you can configure a connection from Oracle SQL Developer to your Oracle database. And of course, throughout this course, use Oracle SQL Developer to write and execute your queries.
Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
1. Introduction to SQL
2. Preparing the Course Environment
Downloading the course VM2m 16s
3. Using Oracle SQL Developer
4. Basic SELECT Queries
5. String, Number, and Date Functions
6. Joining Table Data
7. Manipulating Data
8. Grouping Data
9. Advanced Topics
Next steps1m 33s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.