How To Install MySQL Server on Ubuntu!
Published: 2021-09-17 11:22:27

# What is SQL Developer?
SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.

---

# Prerequisite(s)
 - JDK 8/11

## Downloading Prerequisite

Oracle JDK 8/11

 1. Go to [download Oracle JDK page](https://www.oracle.com/java/technologies/javase-downloads.html)
  2. I will use Oracle JDK 11 because it has a .deb installation file which can be easily installed using dpkg
![jdk download.png](https://cdn.devdojo.com/images/september2021/jdk%20download.png)

 3. Download Oracle JDK 11 for Debian package (at the time of this post, the version is 11.0.8), you will be prompted to sign in using oracle account to download, you will be prompted to sign in using oracle account to download
![jdk 11 .deb.png](https://cdn.devdojo.com/images/september2021/jdk%2011%20.deb.png)

Oracle SQL Developer
 1. Go to [download Oracle SQL Developer page](download Oracle SQL Developer page)
 2. Download Oracle SQL Developer for Other Platforms (at the time of this post, the version is 20.2)
![sql dev install other platform.png](https://cdn.devdojo.com/images/september2021/sql%20dev%20install%20other%20platform.png)

## Prerequisite Completed
![download folder sql dev.jfif](https://cdn.devdojo.com/images/september2021/download%20folder%20sql%20dev.jpeg)

---

# Installation
## Install Oracle JDK 11 and Oracle SQL Developer
Oracle JDK 11

 1. Open your terminal, go to directory where your prerequisite files are located (in my case it's in ~/Downloads)
 2. Install Oracle JDK 11 by using command:
``` 
sudo dpkg -i [YOUR_ORACLE_JDK_PACKAGE.deb], in my case it's sudo dpkg -i jdk-11.0.8_linux-x64_bin.deb
```
 3. Verify your installation by listing the directory of /usr/lib/jvm

## Oracle SQL Developer
 1. Open your terminal, go to `/opt` directory. This is where i will store the sqldeveloper application, you can choose other directory, but this my preference (and i read also that `/opt` is for 3rd party apps that we cannot install via `apt` package manager)
 2. Unzip Oracle SQL Developer with command 
```
sudo unzip [YOUR_SQL_DEVELOPER_FILE_WITH_LOCATION].zip, 
```
 By default the unzip program will extract the zip file into the current directory, since we are in `/opt` now, we don't need to specify target directory.
 3. Locate your Oracle JDK installation under `/usr/lib/jvm`, we'll need this location to tell Oracle SQL Developer where our Oracle JDK is located. In my case it's `/usr/lib/jvm/jdk-11.0.8`
 4. Go inside the sqldeveloper directory
 5. You can see that `sqldeveloper.sh` has executable permission so that we can run it by doing `./sqldeveloper.sh` or `sh sqldeveloper.sh` in the current directory.
 6. You will see Oracle SQL Developer starting
![sql dev starting.jfif](https://cdn.devdojo.com/images/september2021/sql%20dev%20starting.jpeg)

That’s it, you have successfully installed SQL Developer on your Ubuntu Device and you can start using it!

## If you found this usful then please comment and follow me! Also check out [my website where I also post everything from here](https://howtoubuntu.xyz)