In this tutorial I’m going to show you how to install Oracle, SQL developer and create a local connection on Windows.
- Download Oracle Database Express Edition 11g
- First login to Oracle (if you don’t have an account, you’ll need to create one)
- Accept License Agreement and download either the 64bit or 32bit version depending on your system (if your’re unsure, sight click on This PC, click properties and it will say under System Type.
- Once downloaded, navigate to the download folder and click install.
- Oracle will ask you to set a password for your system, it is important to remember this password as you will need it to create a connection later.
- Next, download SQL Developer
- Again you will need to log in to Oracle, accept the licence.
- Check you have JDK 8 installed. Open the command line (search windows for cmd) enter the command javac -version.
- If you haven’t got 1.8 installed then download the SQL developer with JDK 8 included, otherwise download the Windows 32-bit/64-bit version.
- Navigate to the folder it was downloaded too and run SQLDeveloper
- Open SQL Developer, click the plus sign and create a new connection.
- Enter a Connection Name of your choice
- Enter system as the username
- Enter the password you created when installed Oracle in step 1
- Leave the hostname as localhost
- Leave the port as 1521
- Leave the SID as xe
- Click Test which should return ‘success’
- Click Connect and begin using SQL
Now you can begin creating tables and developing your SQL skills. See Oracle’s documentation for more information on getting started.