Hi, let's talk about installing Oracle 18. See, the latest version from Oracle will be interested in Oracle 18 three Express Edition, which is meant for beginners and hobbyist. The first thing we need to do is download a TNC Express Edition. So click here. First you have to go to oracle.com. And in the homepage you see downloads right here.

This is where you need to click and it is going to provide your list of options. And there you have to select what do you want to download? Go to database, because we want to download Oracle Database 18 C and then you have to select database 18 c Express Edition The rest of the additions are priced. They are not free. So we work with a TNC Express Edition. Click on this.

And it's going to ask you which version you want to download. Is it for Linux or Windows? Unfortunately, there is no Oracle for Mac. So if you're a Mac user, sorry, you're disappointed. So this is how we get here. Click on that.

It'll start the download, accept the license agreement, click on that. And it might ask you to login because you are expected to log in with a racquel account. So there you are. So it's asking me to log in but my credentials are all laid there. I say just get in. And now it will start downloading it while it's going to take a while to download that.

Put it anywhere you like. But make sure you know Where it is going. And of course, it's a little big. In my case actually, I just downloaded this so I'm not going to download it again. So in my case, it is here in my Oracle folder I already downloaded it, and as you can see it's around two GB. Okay, that's the size of it and you have to wait for quite some time before the whole thing is downloaded.

And once it is downloaded, then we'll review the installation process for now I'm not proceeding with the download because I already have it. So you carry on with your download and once you're done, then you can come back here. Well, here we are. The download is done. And this is what you got from oracle.com just extracted because this is a Jeep file and I'm using windra you can use whatever you like. And it is to be extracted.

I already extracted that into folder like this. And mine is Windows version and that 264 bit. So get into that folder and start the setup program, double click on setup. And it's going to start yes proceed and it is going to start the installation process. We don't have too many steps in this but it does take some time. So let us take the required steps first and then we can leave it for installation.

So go to the next step and then accept the license agreement as usual. Next, it's asking where do you want to install this and I prefer to change the folder. I prefer to put it in a folder like racquel 18 While you can choose whatever you like. So I just want to put it in a folder called Oracle 18. And that's where it is going to install this and make sure you have enough space. Go to the next step.

And this is very important. This is the password that you need to use to log into Oracle. So give a simple password and unless you have a reason do not complicate it. So keep it simple. So I gave the password and trying to proceed. It's showing me where it is going to install Oracle and go ahead and say install and it's going to take a while to install and we'll come back once the installation is completely done.

The installation is completed and you must be seeing a screen like this. Pay close attention to this This is the pluggable database that we are actually interested in. We also have something called container database, which is also important, but our interest is more on this. It's because this contains a user called HR, which is about human resource. That's what we are going to use. So all through so this is the name of the database.

Okay, x e, that is Express Edition, pluggable database. And we can also connect it to a container database without this name, and actually the name of that database is simply x E. Well, we need to take a couple of steps now to connect it to Oracle database and this is different from what it used to be in level g Express Edition bit of advice here. If you are not really keen about the latest version, I strongly recommend you go with 11 g Express Edition, which is very good for beginners and you don't have different databases single database. So the whole process of connection etc would be much easier. And also it doesn't take as much time as 18 c takes. So if you're all about lending databases and interested in laying a foundation, Levin G is an awesome database system.

I mean, Levin g Express Edition, please check out my YouTube channel to understand how to get started with 11 g because it's possible to install and then make things happen much more quickly and relatively easily. Anyway, we have done this so Let's just click on Finish to finish things off. And now how do you connect to database first go to command prompt, I hope you know how to get there. And once you go to command prompt, then find out what is the IP address of your system. And this is exactly what I want you to remember the IP address you get from your IP config command. So here is the command IP config and it gives you information about your systems IP address, we need this.

So 192 dot 168 dot one dot 34 is my system but please find out what it is in your system. So once you get that then we are all set to connect to Oracle. We are not connecting to a container database. We are interested in pluggable database so we can Straight away start with SQL plus, that's the program provided by Oracle. And then we need to use something like the username system is the username. Whatever password you have given in my case have given a very simple password that is Oracle.

And then you need to give the IP address of your system. So we have just seen the IP address so 192 dot 168 dot one dot 34 colon 1521 and then you need to go with something like a slash. And then you need to give the database name X key PDB one, this is the full string so system the name of the user system means the data Ba the administrator, Oracle is the password I have given. And this is the IP address of my system. This is the standard number 1521. And then this is the name of pluggable database and with this command we can connect it to or I can just press ENTER key after that, you are connected.

And here we are, we are connected to racquel 18 c Express Edition, you can clearly see that Okay, and now we connected to system you can even ask racquel who you are by saying show user it says your system. Now we have an account called HR, the human resource account which contains tables it has precisely seven tables with a reasonable amount of data. Very good set of tables for beginners to learn what is what is The tables were designed by racquel Education team. So here, I'm going to unlock that account that hatch our account is by default locked, we can't access it. So we have to give two commands to unlock it, just give the commands as they are, you might not know much about what they do, but they just unlock the account, alter user HR account, unlock. This is the command and don't forget semicolon at the end and press ENTER key, you unlock the account and also change the password because the existing password is expired.

So you have to give a new password but I give the same password that is HR. The user name and password are same. That's okay. You can give a different password if you like. So alter user HR identified by HR. That's the past Word, that's it, you unlock the account with this command.

And then you change the password with this command. And now you're all set to exit this account the system account and get back to that account. So just go back and give the same command just change HR HR system should be replaced with HR and password is replaced with HR, the rest remains the same. And now you are connected to HR. And all that you need to do is just again, find out who you are, you are now HR and you can also find out the tables that are present. You can say select the name from something like okay t name from tab, and that is going to tell you what are the tables that are present.

Well, you get To see more about select later, but for now, this command is saying displayed the table name for all the tables. And these are the tables that you have. So you will get to know them later. For now, this is the way you log into system account. So this is very important, you got to give this. And if you're not giving all the details, then you will be connecting to the other database called container database.

And the problem with container databases, you don't have this HR account. This is only in this pluggable database. So please remember that, and this is the way you connect to it. And you can start using the tables that are there. For example, we have a table called jobs and we can get all the columns or we can just take job titles from that I say job title. And that's it.

This is how you can give commands. Okay, so once again, I repeat the process, please make sure you understood that this is how you connect it to system account first, after you're connected to system account with the password you have given at the time of installation. Remember when we were installing, we were asked to enter password and this is that password. And this is the IP address of your system and you have to be aware of it. So find out this by using IP config command. And these are all standard names don't change them.

And 1521 is a standard port number. And this is the database name. So just give them as they are and you will be connected to system but then you need to give two commands in order to unlock the account the first time The commands is HR unlock. So alter user HR account unlock, then you need to give one more command to change the password. That's all you need to do after log into system, get out of it. And now you cannot using HR like this.

This is precisely what you need to do. But if you try to do it in the beginning, you get them essays, the account is locked. So, log into system, unlock it, now you're ready to go. Okay, so that's how you get started.