Lesson 2
Beginner Level
2 of 30 lessons
Setting Up Oracle SQL Environment
Before writing and executing SQL queries, you need to set up the Oracle SQL environment. Oracle provides free tools like Oracle Database Express Edition (XE) and SQL Developer to practice SQL on your own machine.
Overview
Before writing and executing SQL queries, you need to set up the Oracle SQL environment. Oracle provides free tools like Oracle Database Express Edition (XE) and SQL Developer to practice SQL on your own machine.
Steps to Set Up
- ✅ Download Oracle Database XE from the official Oracle website
- ✅ Install Oracle SQL Developer (a GUI tool to write queries)
- ✅ Create a new connection using your Oracle username/password (e.g.,
hr/hr) - ✅ Start running your SQL queries using the worksheet
Connection Example
When creating a connection in SQL Developer:
Connection Name: MyConnection
Username: hr
Password: hr
Hostname: localhost
Port: 1521
Service Name: XEPDB1
✅ Click "Test" and then "Connect" once the test succeeds.
Practice Task
- Install Oracle Database XE and SQL Developer.
- Try creating your first connection with the HR schema.
- Execute a test query:
SELECT * FROM employees; - Note any error or connection issue you face.