In order to write and execute SQL queries, we first have to create a connection to our desired Oracle database server. In this video, learn how to configure and save a database connection in SQL Developer.
- [Instructor] Before we can start using SQL Developer…to write and execute our SQL queries,…we first have to configure a new connection to…our Oracle database.…That's because Oracle SQL Developer is the program…or application we use to execute our SQL queries,…but it still needs to connect to an Oracle database…which contains the data we wish to query.…Oracle SQL Developer supports the ability to create…and configure multiple connections to multiple…Oracle databases.…However, for our course we'll only be using a single…connection to the HR or human resources schema that…comes pre loaded in the Oracle demo virtual machine.…
So, how to create a new connection?…Easily.…We'll use the Connections pane on the left side of the…screen and either click on the green plus button or…right click on connections and choose new connection.…In the next screen, we'll need to provide our…connection details.…For example, we need to give a name for our connection.…HR suits our use case as we will be…connecting to the HR schema.…We'll also need to specify the username and password.…
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.