Oracle 11g Installation | Oracle Database installation | Oracle installation on Windows 10/11

hello everyone welcome to Nick height Academy in our today session we are going to learn how to install Oracle database in our Windows machine if you follow these three steps you can able to install Oracle database in your windows Mission very easily before going to do the installation I will explain the setup so that it will be very easy to understand and if any issues you can able to solve it so Oracle is a database so that database we are going to install here so we do have different versions so in this session we are going to install Oracle 11g Express Edition database Oracle has many versions my latest version is 21c in order to practice our SQL Oracle 11g itself is more than enough it is a very lightweight software you can install any questions without any issues so Oracle is a database in this database we can have a different schema so schema is nothing but a subset of our database based on the different objects so one single schema will have different objects like a views tables and synonym sequences indexes and everything so if you look at this particular picture here we have three schemas in one single database so by default Oracle 11g will have a schema called a system schema it is nothing but admin schema so in real time project only DBS will have access to this particular schema they will create other schema and other users they will manage it other schema and other users they will manage all the database related activities in this 11g database by default we do have a schema called HR schema it's a human resource schema you can use this particular schema to create all the tables or an example for this system schema we are going to use username as system and password we are going to have assignment so this is the password you can enter while installing the software so that it will be easy to remember then HR schema we can have the username as HR and password shr and we can create n number of schema here for an example if you want to create one more schema for practice yes you can create a schema called core schema or test schema or any other schema so here I'm going to create a schema called core and username will be password will be a code in real time projects we do have many schema many users and each schema will have different different objects you can create a table here you can take you can create a tables here so if you have access to this particular schema in this schema you can log in and then you can see all the tables for an example by default Oracle 11g will have seven tables the tables are we have employees tables we have departments tables so you can use these tables for the practicing purpose and Etc you have seven tables and here you can create n number of tables for an example I want to create my own table customer table I want to create I want to create a product table yes you can create any number of tables so this is what the database we are going to install and we are going to configure different schema it's very simple don't get confused I will explain while installing it's very very simple after installing it you'll be seeing this particular icon you'll be seeing this this particular icon in your machine and this is the database in order to query this database we need to have a a GUI tool graphical user interface tool this is nothing but SQL Developer you can have any other tool also by using these tools you can create a connection and you can query this particular database or an example you can read the system schema you can query this HR schema you can query this course scheme or tapes so this tool we will collect as SQL Developer tool so we do have a different tools you heard about the stored for Oracle yes you can use stored for Oracle here and you can use SQL plus you can use you can use DB visualizer so any tools you can use not an issue whatever the tool you are going to use it the underlying databases one single database I hope you are clear as a first step download the software from the description once downloaded you'll be having this ZIP file you can unzip the file you'll be having this particular folder see right click on this particular software once we have we have given straight click and extract to this particular folder if you do not have WinRAR in your machine go to Google WinRAR download go to this particular link and click on download Windows so this is the authorized software only no need to worry about it and click on download Windows it will get downloaded once downloaded the exe file you can click on it and then install it it's very simple step since I have already installed I am not doing it again you can install it so first we are installing this in WinRAR or WinZip if you have then you can use it right click on this go to extract so once extracted you'll be having this particular folder double click on this folder click on this Oracle this folder go to disk one double click on the setup file thank you click on yes then it will be preparing to install this is a page you will be getting it this is the Oracle database 11g Express Edition click on next accept that license and terms and conditions click on next year so here this is what the destination for where it should be installed click on next year no need to do anything so this is admin password for the user sysr system so we have to carefully choose this so always make sure that you are remembering the password the enter password I am giving like admin password is admin confirm password as admin click on next click on install it will get installed it will take 5 to 10 minutes of time depends on your system speed we will wait for it once installed then we'll go for the next step once installation completed we'll be getting this particular wizard click on finish we have installed Oracle database and we will configure the connection in SQL Developer just to go to this SQL Developer folder double click go to this SQL Developer you can find SQL Developer icon if you want to have this icon in your desktop just to right click you can add to start or you can go to show more options and you can create a shortcut or you can create a send to a desktop then it will create a shortcut if you see this you'll be having this icon in the desktop so just to double click on the desktop next time it will open here even if you want you can download the latest version from the net and you can use this SQL Developer so very first time it will take one or two minutes you can give no if it is ask any dialog box you can give no and you can see here this is the one you can see so what we are going to do so from this SQL Developer we are going to establish the connection through SQL Developer we are going to create a connection so this system schema and we will unlock the HR schema schema will be unlocked State we will unlock it and we will create a new schema called core and you can use this schema for creating any number of tables just to open this SQL Developer you'll be seeing this page and this is the clean color icon just click on this icon connection name you can give any name just I'm going to give connection Ms admin username will be system the password is whatever the password you have given while installing you can see here password I have given us Advent so this is the username for system user and this is the password just you can mention this system.bin and you will be having a host name port number and this ID don't change this in your Real Time Project you'll be getting the details from your DBA or your from your team members by using that you can connect just a click on test it should be tested success you can click on connect so that means through SQL Developer we have established a connection from SQL Developer to system schema so very first time a charge schema will be unlocked State you have to unlock it how to unlock you can execute this particular statement I have given the statement in the description just to take that and use it alter user username HR identified by password research account unlock make sure that you are running this particular statement in this admin schema just execute take a chance schema will get altered we have unlocked it then click on this plus symbol name you can give HR schema username will be HR and password will be HR you can refer this particular picture this is a schema name username and password these are all the tables you can test it it should be tested success click on connect it will get connected and if you open this HR schema manually you can see the different objects right tables views indexes packages everything if you click on the tables you can find a different tables here so in your system you might be seeing a seven tables like employees departments all this if you want to manually check you can click on this table yes you can check the data and data model and constraints all this you can able to check here you can close it and we are going to create one more schema right we have to create one more schema called a code just you can use create user core this is the user schema okay identified by core this is what you can create a new schema just you can execute it a new schema will be created new user will be created after that you can use you have to provide the permissions you can use Grant connect comma resource to core so this is what you can use and just execute this you have to execute this one and you got execute then it will get executed these two statement I have given these three statement in the description make use of this then you can click on the plus symbol then you can use the name score and username is core password is code and you can test it it should be set success click on connect so we have created all this connections so you can create any tables here or an example I want to create a table in this particular it just give our code schema you can create it so create table name I want to create a table called Product so just you can open it product ID it's a number data type if you want you can give the constraints product name so just I'm creating with only two columns the same way you can create a number of tables and see here the product has been created the table has been created so you can check the description I have given all the SQL videos watch it and you can able to do the Oracle installation and start practicing it and if you have any queries you can post it on the comments I will respond to it thanks for watching if you haven't subscribed my Channel Please Subscribe the channel and click on the Bell icon so that you'll be getting all the notifications thank you

Channel: NIC IT ACADEMY

Views: 13,588

Keywords: oracle database installation on windows 10, oracle installation, oracle database 21c installation on windows, oracle 19c installation, oracle database tutorial, oracle database xe, oracle database, oracle database 19c tutorial, oracle database architecture, oracle database 21c, oracle database service, download oracle database 19c, install oracle 19c database, database, oracle db, oracle sql, oracle sql developer

Id: Jrefk1hOJQg

Length: 13min 36sec (816 seconds)

Published: Mon Mar 20 2023