Now, let's understand how to use SQL Developer, which is a tool to interact with Oracle. It is more user friendly than other tools provided like SQL plus, to start with go to as usual oracle.com and go to downloads. And you're looking for a developer tool. So select developer tools here. I hope you already got your database up and running. If not, go back and watch the previous video, check out how you can set up your database.

And now go to developer tools. And there you find something called SQL Developer. So here we are, and click on SQL Developer and it's going to show you what to download. So here we have three options. You Also got option for Mac because Mac cannot have Oracle server running. But you can run this on Mac and connect it to Oracle server running on some other system.

So we are interested now in Windows 64 bit, you can either go with the JDK included or without JDK, the choice is yours. In case you don't have a Java already installed in your system, I suggest you go with this. But if you already have Java installed, then you can go with this because it will use Java that is already installed in your system. But you need to have JDK eight or above. So if you don't have that, just go with this. It's all in one.

But if you have JDK installed go with this. I'm going with this because in my system JDK is already installed And as usual, it's asking me to accept license and then download. And it's going to start the download, of course, after you log in, and this is where you sign in, and then the download will start. In case you don't have an account in Oracle, just register, it's free. Well, I don't need to download this because in my system, I already downloaded this. Okay, so I'm canceling it.

I'm going to the folder. And here is the download a little while ago, I already downloaded that, and this is around 400 Mb, that's what it is. And I'm downloaded the one which is without JRE. So just a double click on that, and it'll ask you to extract and you just need to extract that. So this is what it is going to create SQL Developer So I suggest you go to extract and say you want to extract this into some D drive or C drive anything. I prefer this to be in the root directory.

In fact, I have already done it. And here is my SQL Developer in D drive. I already extracted that. But in your case, you have to proceed with this step and extract. So once you extracted that, you get a folder like this in D drive, because in my case, I extracted that into D drive. So here we are.

Having this extracted into the drive and SQL Developer folder, just go there and double click on the SQL Developer. This is the application double click, it'll start and if you install the one without JDK, eight will ask you to provide a JDK First time when he starts, it'll ask you where is your JDK? You have to just select that. In my system. I just started that. So it's not asking me, but in your case, it'll ask you where is your JDK?

Just select your JDK folder, it'll automatically pick up required Java code from that. I mean, it needs JRE to run this application, because this is built with Java. So once you start SQL Developer by simply double clicking on this, if JDK is not included with the software, it will ask you to provide the folder for JDK. And once you provide the folder, it is going to start while it takes a little while to start. So let's wait until it starts. Well, this is how you get your SQL Developer Actually, you get the welcome screen and I just closed it because it's not relevant for us.

Now all that you need to do is go to Oracle connections and click on Place to create a new connection. So on the left, you see the connections and you need to go to Oracle connections, click on plus, and it's going to open a window where you need to give the details. So I just give the name as headshot. And then I'm talking about the user name head. char password is also Hey, char, I want the password to be saved so that I don't need to enter it again and again. And this is where you need to give the details.

And this is where you give 192 dot 168 dot one dot 34 I guess that's what we have seen. Am I right? Yeah. And then 1521 And this is going to be Exede PDB one and with those details you can test you can ask it to check whether it can connect. This is the hostname, this is the port, this is the SSID and click on test it is going to check okay well that is actually this. So, we are talking about service name not aside please remember, it is service name, okay.

So x EP DB one, the port is same, the host name is the IP address, which we found out in the previous step. And this is the username password and please say password so that it won't bother you to enter it again and again. That's it, you got it. You save this you can see a connection and you can just click on Connect. Okay, and then once you Enter the connection details, you got a connection created, you can expand the connection, it's going to show you what the connection is having. And we are more interested in what are the tables that are present.

So these are the tables. And you have a lot of stuff here. But the most important part of it is this. Right now we are working with the HR. This is the connection. And here you can give commands.

For example, I want to know what are the rows we have in a table called jobs, no need to give semicolon here because it knows the end of the command, just click on this green button, which is to execute and eight runs and displays the result just below that. This is an awesome tool. And we'll be using this a lot because this is easy to use. And you can also type multiple commands for example, select Start from departments. I can select this and then click on that. And it is going to execute only what is selected, not the other one.

So you can have multiple commands and you can select whichever you want to execute, click on that you get the result. So this is the tool I strongly suggest to use, it's free. So download from oracle.com extracted. And if you include the JDK along with that, no need to do anything else it will start automatically. But if you are downloading the one without JDK, then you need to select where JDK is present in your system. That's it, then create a new connection.

This is the way it is done. Just go to connections. Click on this and here you need to give some name for that. And then you are talking about the user name and password. And then here, you should select service name, not this SSID. And there you need to give our service name SC, p DB one.

And also this is where you should change to the port number 192 dot 168 dot one dot 34. That's what we need to give. And then username and password you can also connect it to your system and then you can give the password of the system again say save password not a good idea to save system password because it's powerful account. But if you're not sharing your system with anybody else, that's fine. Okay. So I say system password, and I say the name of this account a system.

Okay, just test to be sure it is fine. And look at this. This is where you get the message success. Okay. And once you're done, you You can save and you can close this or you can even connect. And when you say Connect, it's asking you for password.

Right this so you are now connecting to system. So you have two tabs. This is about system account. This is about HR. You can see them here also. So whichever you want to use, you can go with that.

Let's close both. And it's saying Do you want to save changes? No. And then you can go back to this and you can open what is called as the sheet the SQL worksheet. Okay, anytime if you want to create the worksheet, just go and say open SQL worksheet, you get that and you can start giving commands. That's it.

That's how you get started with SQL Developer. And this is with the assumption you already have a racquel 18 c Express Edition setup. If not watch my previous video where I explained how you get started with that. That's it