How to install Oracle Database 21c Express Edition and SQL Developer on your computer - for FREE.

in this video we're going to install a version of the oracle database that you can use on your very own computer now as you can might imagine there are lots of different types of versions there's the oracle database enterprise edition that's the full featured very expensive version so you'd install that on a server at work there's a standard edition that costs less money the personal edition that costs about 500 so i recommend you get the express edition which is a free to use version now it does have some limitations primarily it's resources you can use only up to two cpus central processing units two gigabytes of ram and 12 gigabytes of user data on disk now if you're going to do more intensive computing it would be a problem but we're not going to need such intense computing at an early stage so here we are we have oracle database 21c express edition for windows x64 what does this x64 mean well it means that this is for 64-bit computers so if you've got a 32-bit computer i'm sorry you won't be able to use the 21c version instead you would have to find and download an 11g express edition so what are all of these numbers well this was the number that oracle gave to all of its releases so the 10 version came out in 2003 the 11 g came out in 2007 the 12c in 2013 and then they started doing what microsoft were doing with like office 2007 office 2010 so they jumped from a 12 c to an 18 c released in 2018 then 19 c and a 21c if you wonder what the c and the g's mean well c means cloud and g means something called grid computing which supports clusters of services treated as one unit so it jumped from 11g to 12c to 18c so you would have to find an oracle 11g express edition and i found one here for instance the oicbasics.com and there is a download button here however do make sure that it is a real file and make sure that you've got plenty of antivirus and check everything you download well so you can see that to my oracle 21c database is downloading and what i'm going to do is pause the video until it downloads now oracle database express edition has now been downloaded so let's go to my downloads folder and refresh i can right and click on this and i can say open wave windows explorer if you've got winzip installed you can also do that so you can see i've got all these files but they haven't been extracted so what i need to do is right and click over here on the left hand side and go to extract all so this will extract it into its own folder so it's very important that you distinguish between the folder icon and the zip icon so you don't want to be using the zip anymore you want to be using the folder if you're using windows 11 then again you should right and click and go to extract all there go and it is now extracting so now it's extracted we go into the folder oracle exe and scroll down to the bottom and we have got this setup icon here so i'll double click on it if you get a dialog box asking you if you want to make any changes then click yes and you can see it is now preparing to install so it's configuring the windows installer so i'll click next i accept the terms of the license agreement you should read it what i generally do is copy it into a word document and then have a read click next now notice where it installs it doesn't install it into c program files instead it's installing into its own directory c app and then product 21c so if you're looking for where the actual source files are stored you won't find them in c program files now this is important this is a password that's going to be used for sys system and pdb admin accounts so these have access to basically the entirety of your data so make sure you choose a really good password so one with symbols and uppercase letters and numbers and that sort of thing so click install to start so it's going to take quite a few minutes in the previous version it took 20 minutes so i'm just going to speed up the video and let it install you now see that we've got this second dialog box opened as well so you can see how well it's installing as well so it took quite a number of minutes to install so it took around 10 minutes to install but there were no problems whatsoever so i'll click finish and that's the back end installed on my computer so that's the back engine installed so that's the bit that does all of the work but what about the front engine what how are we going to actually be able to use it well for this we're going to use a program called oracle sql developer now there are alternatives to this some really much older but this one allows us to use a lot of functionality plus if you did want to go further into programming language the pl sql then sql developer will help you do this so again we're going to go for the windows 64-bit version with jdk8 so that is the java development kit included so that is necessary if you're trying to install the windows 32-bit then you can download it but then you'd also first of all you should download the jdk8 earlier than that so download that first and then download the windows 32-bit but i'm going to use a 64-bit with jdk 8 included so let's click on this so i have reviewed and accept the oracle license agreement so here is the oracle license agreement again need to have a good read of that and click on download so you can see that for this we need to create an oracle account so let's do that so we need the information email address password country name job title workform company name address city and zip and postal code now if you haven't got a company name then just put none so do all of this you can send me marketing communications if you wish and then click on create account now you can see i've put n a for a lot of these items and also i've just put it made up a group of numbers for the work for but it seems all happy with this so i'll click create account and then you'll see that it will be sending me an email to verify that my email address is correct so having clicked on that email you can see success so click continue your account is ready to use and now i need to go back to where i was and if i just click refresh just to make sure it's i'm logged in now click on download and now i can sign in so now it is downloading now i'm downloading a version that is 21.4 now the version that you might be downloading will probably be a later version however there really is a minimal change between what i'm installing and the one that you're installing so whatever the latest version is as long as it doesn't say it's a beta or test version then you're okay to install it and it will have pretty much the same functionality as my version so i'm just going to pause the video and let it download all right so now it's downloaded again i'm going to go to my downloads and you can see again i've got a zip so i'm going to right and click on it and extract all so it'll take about 30 seconds for it to extract everything so now it is finished i will go into the folder again not the difference between the folder icon and the zip icon going to sql developer and you might think that you now have to install something but no you don't it is already installed so if this is a good place for your sql developer to live then leave it there if not then you can move it to a different folder so i'll move the entire folder at once so now what i need to do is open the application called sql developer so here you can see it's opening i don't want to import preferences from a previous version so i'll click no and so here you are this is oracle sql developer so now i've installed the back engine which does all the work and the front engine of oracle database and oracle sql developer onto my machine in the next video we'll look at how we can connect the two together now when you open up oracle sql developer it looks very busy there's this big welcome page but don't worry about it let's just close it with the x and there we go so you can see there isn't actually that much going on so we've got some reports down there which we won't be using that much at the minute and we've got up here connections well what do we need a connection for well oracle sql developer is the front engine and we previously installed oracle database express edition so we need these two to talk to each other and the easiest way to do that is just click on this plus sign next to connections so we've got this dialog box a new database connection now we only have to set this up once so we can call it anything so i'm going to call it sql database now you can give it a color and i would recommend you do this because that means that when you connect to it it will display that color in a couple of places so you will be able to see now which database we're going to be connecting to it's the local one basically everything is set up for you apart from your username and password so we're going to call in as cis because this is just our test database it's not one that we're using in a commercial setting and we're going to need the password so this is the password that you had previously set up so i hope you remember it and then finally what we need to do is change the role i'm going to check save database as well so i don't need to type it in again now if i go down here and click on test you can see that our role should either be sysdba or sysopa now sysdba is for fully empowered database administrators so allows you to see everything and sysopa allows you to do basic operational tasks without the ability for you to look at your data well we really want to see everything so i'm going to connect as a cis dba so if you change the role to says dba click test again you can see we now have success so it looks very complicated but the good news is you only have to do this the once when connecting to one particular database so let's click connect and you can see that we've got this new database connection which is in red sql database also notice that we've got this window or this window is also in red now if you don't like this particular color no problem just right and click on sql database go down to properties and then you can change the color so i'm going to change it to a more standard black now the reason for having these colors is if you connect multiple databases then you can swiftly see which database you're in so now let's close all of these tabs right and click and go to close all so we've now created a connection to our database so for me this is the most complicated bit done we've installed the back end oracle database express edition we've installed the front end sql developer and now we've created a connection so in the rest of the course we can actually focus on what we actually want to do creating select statements all of the coding and everything else that's required for this certification and to learn sql generally so now if i want a new tab i can go to this sql icon here click on my database connection and click ok or i can click on the drop down and select the database connection from here and then i can type in my code and then press play to run the card so now you're fully set up to write your sql codes in oracle thank you very much for watching this video if i can help you further with your oracle sql journey then why not join me in my udemy course here we'll create tables learn how to use the six principle clauses of the select statement learn about union case merge find about constraints and views and so much more and in the description to this video you'll find a link to this course at a very special price well thank you very much for watching this and keep learning [Music] you

Channel: SQL Server 101

Views: 62,957

Keywords: sql server, sql, microsoft sql server, sql server learn, sql server videos, t-sql, tsql, oracle sql, oracle 21c, install oracle, 21c express edition, 21c xe, install 21c xe, install 21c, 21c xe install, oracle sql developer, oracle 21c xe, install oracle database, install oracle sql developer

Id: ZKVpFZEoFOY

Length: 15min 25sec (925 seconds)

Published: Thu Dec 23 2021