ORACLE INSTALLATION
In this tutorial, we will discuss what are all the software that is required in order to get started with SQL language. So for this I would like you to recommend downloading the Oracle database, which is 11g release 2 version where it is available for free.
Steps to start up with SQL software;
- Go to oracle.com website.
- Register with oracle.com.
- After which you will receive e-mail verification and get it confirmed.
- You will be allotted an account.
- Now you can download the link relevant with the Oracle 11g release 2, which is an Express edition.
Apart from this I would like to suggest one more point is that, to more effectively work with SQL language, we require something called an SQL Developer, which is a wonderful interface that was developed by oracle.
SQL Developer going to help us to have a very better GUI model where you can write the code and you can see the data then and there itself.
we will discuss 2 things;
- How to download oracle database
- How to download SQL developer
1. How to download the oracle database?
I would like you to recommend you to download Oracle database which is 11G release2 version, where it is available for free, in order to download you need to have the login credentials with you.
Now let’s see how to download these 2 elements; by using Oracle.com website.
This is how the oracle.com looks like.
Register with Oracle.com website, after which email verification will be processed by Oracle.com. Once after you get it confirmed. You will be allotted an account.
Now you will be able to download the link relevant with the 11G release2 version, which is an express edition. In order to work more effectively with SQL language, Apart from this, I would also like to suggest you to download SQL developer.
Go to the menu bar and click on the downloads button.
Scroll down, where you can see Oracle Database 11g Release 2 click on it.
We use the above one to learn the SQL in a detailed manner, as we are not concentrating on database management or Database backup and we are not concentrating on full level installation.
Now Scroll down, where you can see Oracle Database 11g Release 2 Express Edition for windows 64 click on it.
Once you come here, you check yourself; whether your system relies upon windows or Linux, accordingly download it based on your platform.
Click on download Oracle Database 11g Release 2 Express Edition for windows 64
2. How to download SQL developer?
SQL Developer is a wonderful interface, which is developed by Oracle. It will help us to have a better GUI model, where you can write the code and see the data then and there itself.
In the menu bar, type it as SQL Developer download, a link which already provided by oracle, will be reflecting. Click on it.
After which you will be able to see various types of downloads, that are available.
I would like you to suggest, go for the link which has Windows 64-bit with JDK 8 included, because the other links which are available for which you need to install Java software development kit(JDK) externally or if you have preinstalled JDK.
So if you are new and starting from scratch, then I would suggest you to download the above link.
Download these 2 and keep it on your desktop to further proceed with the installation part.
SQL Installation
we will discuss the installation of 2 software;
1. How to install the Oracle database?
2. How to install SQL developer?
1. How to install the oracle database?
Once the download is completed, we can see Oracle Database 11g Release 2 Express Edition in our folders. The platform in which I am going to run is on oracle windows 64bit.
Below you can able to see OracleXE112_win64.
By right-clicking on the folder, you will be able to see Extract here option. Click on it.
Once after the extraction, you will be able to see the folder as DISK1
In the Disk1 folder, you can able to see the subfolders, in which you can identify a folder called setup
Double click on the setup folder, you will be able to see the below popup.
This will help us to install Oracle Database 11g Release 2 Express Edition.
Click on the Next button, accept the terms and license agreement.
Click on the Next button, checkbox Oracle database 11g Release 2 Express Edition. Where you can also see the path where it has been stored like C drive, D drive, etc..
Click on next and click on Yes.
After which it asks for Database password. Enter the password and do remember it. Click on next.
Now you would be able to see the configuration of your database. Click on Install.
Once after this click on the Finish button.
How to install SQL developer?
For this you need to go to the required folder and click on the file of SQL developer, which is already downloaded.
Right-click on the SQL developer, and in which Extract here option will be available. Click on it.
Once after installation you will be able to find a folder called SQL developer.
