Speaker A
Just a moment, right? Okay, now we will see. Now you will understand what is the database client, what is the database server, and what is SQL. This is very, very basic terminology. Okay, now how to install
This video explains Oracle database installation, client-server basics, and SQL tools like SQL Developer and SQL Plus for beginners.
Key Takeaways
- Oracle 11g is recommended for beginners due to lower system requirements and sufficient features.
- Oracle installation requires a free sign-up on the Oracle website to download the software.
- Two main clients for interacting with Oracle databases are SQL Developer (GUI) and SQL Plus (CLI).
- SQL Developer may need to be downloaded separately for Oracle 11g but comes bundled with 12c.
- Understanding system architecture (32-bit vs 64-bit) is essential for downloading the correct Oracle installer.
Summary
- Introduction to basic database terminology: database client, database server, and SQL.
- Step-by-step guidance on how to download and install Oracle database software from the official Oracle website.
- Explanation of different Oracle versions: 9i, 10g, 11g, and 12c, with a recommendation to use 11g for learning purposes.
- Details on choosing the correct Oracle installation file based on Windows 32-bit or 64-bit system.
- Instructions on signing up for a free Oracle account to download the software.
- Overview of Oracle installation time and the need to follow installation videos if needed.
- Description of the folders and files obtained after installation, focusing on application development tools.
- Introduction to Oracle clients: SQL Developer (GUI) and SQL Plus (command line interface).
- How to download SQL Developer separately if not included in the Oracle 11g installation.
- Basic explanation of connecting to a database using connection details like hostname.
Full Transcript — Download SRT & Markdown
Speaker A
Oracle. So go to the Oracle website. Just go to Google and just type Oracle. You will see the Oracle site. Just type Oracle download. You will navigate to the Oracle website. Okay, so here in the top downloads
Speaker A
page, you can see the database downloads, right? So just click on the database downloads. This is the latest version of Oracle. There is 9i, 10g, 11g, and 12c is the latest. Now you come to the database software
Speaker A
downloads. So here these are all Java kind of stuff, and this is the database. Exactly, this is the database. Now if you see here, it will show so many versions available. See this Oracle 10g Enterprise and Standard editions and Oracle 10g
Speaker A
Express Edition. So Express Edition is always a license-required. Express Edition requires a license. Okay, and you need to download this one, Oracle 11g Enterprise or Standard editions. Just click on this. Okay, if you see here, it will show
Speaker A
many. I'll copy this later. You can refer to this downloading Oracle. This is the link, right? So now go here, or else I'll copy this in MS Word. You can see the screenshots, right? So now here, okay, here you need
Speaker A
to... This is my URL. Okay, here you need to select this one in the database section. This is Oracle 11g Enterprise and Standard edition. Oracle 11g Express Edition, Express Edition is a license-based again, okay? And then you go for the database 11g
Speaker A
Enterprise and Standard edition. I'll take the screenshot and this go for this. Okay, okay, and then click on this and now we will get this. Okay, I think the latest downloads will be available. If you go for older ones also,
Speaker A
11g is also available, and better to download 11g because 12c requires a lot of space, which is not actually required. And also in 12c, there are a lot more advanced features we are not going to
Speaker A
learn those concepts actually, only for DBA perspective. Okay, but 11g is enough for us. So go here Oracle 11g release 2. Here if you go here, here Microsoft Windows. So again, Oracle can be installed on Windows or else we can install on Linux, Unix. It
Speaker A
supports all environments. Okay, so here go for Microsoft Windows. If your Windows is 64-bit, then you need to download this file 64-bit, and if your Windows is 32-bit, then you go for the first one. Usually now all the VM machines are
Speaker A
64-bit. Okay, so now we go here. Okay, copy this either 32-bit or 64-bit based upon your machine. How will you know whether your machine is 64-bit or 32-bit? Go to the computer and you can see the properties. Okay, just go to my
Speaker A
computer properties, computer properties. Now it will show here Windows 7 64-bit. If it is 32-bit, it will show x86 or something like this. Other than 64-bit, it will show anything else. That is 32-bit. Okay, so now based upon the
Speaker A
bit, you need to download that particular part, and you will get some installation, some zip kind of file. Okay, so if you already downloaded, then I'll put it in Google Drive. Okay, directly you can download from that. Okay, so now
Speaker A
I'll also send one video for installation. There are so many videos available on YouTube also, so just you can go to Google, YouTube, just type YouTube, go to YouTube and just
Speaker A
YouTube video install Oracle 11g database. Just type like this and directly you go for video, right? So they will show clearly step by step. Just you can follow them how to install database and see this. So same page, right? Whatever the
Speaker A
page I have shown, same page. So now they will download. This will take around one, one and a half hour time for installation of the database server. See this, but before that, the important point is if you want to download that particular
Speaker A
file, you have to sign up. Okay, it will ask your user ID and username and password and like so once you sign up, then only you can download this server. That is a free sign up. Okay,
Speaker A
that's what here it is showing. So you need to enter all the stuff. So see this Oracle installation Windows can go through some videos. See, see this, this is all installation process. They will show
Speaker A
the step-by-step process clearly. Just go through this. Okay, I'll send this link also. Installation steps. Installation will take a lot of time actually, maybe Oracle will take 40, 45 minutes, right? Now, so this is a downloading stuff.
Speaker A
Just you try to download or else I'll put it in Google Drive. Just you can unzip the file and just click on exe file. It will start installation, and if you have any doubts in between installation, just watch this video. That video will explain
Speaker A
very much clearly. Okay, now, so now once we install the database, what kind of file we will get? So you will get one folder like this. So I have 10g, 11g, something 11g. I have some clients. Okay, you will get the folder
Speaker A
like this. So if you expand this folder, you will get an application development. Application development, so this is very important for us. Okay, application development. Here in application developer, it will show you two clients. SQL Developer is a UI client, GUI client,
Speaker A
and SQL Plus is a command client. SQL Plus is a command line interface, as I said, right? So client is in two modes. Database client is used for interacting with the database. That is like an interface, and it can be a CLI or GUI
Speaker A
mode. So here even SQL Developer is also will come automatically. See this, here you go here. SQL Developer is also come automatically, right? So this is a SQL in 11g. If you download and install 11g, maybe SQL Developer you will not get, but
Speaker A
it is you are getting this default with 12c software, not with 11c, I don't think so. But if you don't get SQL Developer, what you can do is again go to the same site, again go to the same site,
Speaker A
here on the same site, go to the downloads again. Here SQL Developer you can see separate file. Just that is also one zip file. So we can go here developer tools. Here you can see the SQL Developer developer tool. This is the SQL
Speaker A
Developer. So you can just download only this and you can install. This is just like a, again, this is related to, again, Windows 64-bit or 32-bit. Just you can download, and this is simply exe file. Okay, so you can install this separate,
Speaker A
but if you install 12c, you will automatically get this. This is the client. This is required. Again, this is the GUI client. Okay, and some more days we will see completely on the GUI side, and
Speaker A
later time I'll explain even CLI also how we can run the commands using CLI. Okay, so now this is the installation and setting up process. Now once you install the Oracle software, you will get these folders under application development.
Speaker A
Under application development, you will see two clients, SQL Developer and SQL Plus. And if you install server, you will see other folders also, this and all. You will see Oracle installation products, everything you will see. And our intention is this is more intention,
Speaker A
application development is required here. If you want to interact with the database, if you want to write queries and everything in UI part, you can go for the SQL Developer or else go for the SQL Plus, right? Just to create the shortcut for SQL Developer
Speaker A
like this, right? Now what we can do here is just open this SQL Developer. I already opened this. One minute, we need to open this developer. Now I open the developer. So by default, just a moment, what I can do is I'll copy the
Speaker A
connection data. I'll try to connect to a remote database server actually. Okay, let me copy the connection details actually. So if I want to connect to the database, what I require is connecting, connecting to the
Speaker A
database. So if I want to connect to the database, either it can be local or remote location, I require some details for Oracle. What details are required? I require the host name. The first thing is the host name I require. So host name, what is a host name? Host is
Speaker A
nothing but wherever the database server is installed, that is called as a host name, that machine name every.
Speaker A
host name how we will know the host name go to the computer Again Properties so here you can see the computer name right this is the computer name so that name we should provide or if your database server is installed in your local
Speaker A
machine in your same laptop in that case you can provide simp Local Host host name can be this one or if it is a local directly you can put like local you can put like uh local local host you can put Local
Speaker A
Host if it is your same Mission or if it is a remote machion you need to copy the host name or IP address this is the first thing we require and then we need a port number is required for every
Speaker A
database these are the common details we need a port number is required this is required usually by default Oracle port number will be 1521 default port number and we need Sid or service name in both the Sid and
Speaker A
service name at least one we require and both are same actually so Sid will be the Oracle LNG and also service name if I want to provide service name like this we have to provide dot there will be
Speaker A
some URL like this this so this is become the service name again either we should provide Sid or service name Sid is nothing but service ID service ID this is S ID these are my database details okay and Sid can be
Speaker A
changed this is not static word actually Bas while installing the software that will ask you provide Sid that time whatever you provide the Sid that should be provided so installing the software you need to copy these details that is
Speaker A
very much important okay after installation is done so then you if you don't remember the Sid that is very much difficult later okay while installation itself you need to copy the data whatever data you are entering while installation you need to write the data
Speaker A
into some notebook or some text file okay once installation is completed you require these details to connect to the database that is more important right so host name is required host name refers to wherever the database server is
Speaker A
located and Port is required every database having a port that Port is required and Sid is only for Oracle Sid will not be there for other databases okay Sid is only for Oracle and apart from these three we need a username and
Speaker A
password username and password username and password let me check whether any other user is present or not a minute 1521 is a port if I use HR HR is present that is fine right HR is there okay now I'm
Speaker A
going to use a username called HR okay I created this user okay we can create our own users I'll tell you everything in later okay so now these are the connection details we required if you want to connect to the database right so
Speaker A
now what I can do here is close all SCH developer stuff now whatever the client comes from the database installation I'll open that SQL Developer CL application development under this we have SQL Developer right so go to this
Speaker A
SQL Developer it will ask for Java path actually so uh in latest version of SQL Developer it doesn't ask so what you can do is if you are SQL Developer first time you are invoking sometimes it will ask the Java
Speaker A
path because it requires some Java if you want this invoke otherwise sometimes by default it will get some Java okay so what you can do here is just you need to browse you need to browse so in your
Speaker A
machine somewhere the Java will be present go to the C drive and go to the program file is Java is there right so somewhere so go to the JRE and S bin go to the Java exe just open this just
Speaker A
click on okay uh install not okay go to some other location go to go here application development here browse this is only J we need jtk go to the Java 7 yes this one been jdk lip not Li okay Java version has not been set
Speaker A
only Java version is continue anyway just click on the S ver okay it this is older version actually this SK developer is older version but still no problem can continue with this click on yes now it start this is a little old version
Speaker A
actually it's 2012 it is open import preference not required no now yes so if you download the latest version of SQL Developer it will not ask anything because by default it will get the Java okay so now cancel this now see
Speaker A
this this is AQL developer UI when you open the first time you will get like this this is SQL Developer UI and this is a homepage close this okay by default you don't have any connections here this is a just client okay now I have a
Speaker A
client and now I have a database which is installed in the remote location and also I have some details here this is my connection details now I need to provide these details to connect to the database how to connect to the database just
Speaker A
right click on the connections or else just click on the plus button right so here give some connection name or some Oracle L it can be any name this is optional whatever name you want to put you can put this but other details
Speaker A
should be correct so here my username is HR password is HR and my Oracle is present on this particular machine this is remotely located and now by default Port is 1521 and what is my Sid my Sid is or LNG this
Speaker A
is my Sid now now if you want to save this password with the connection just select the password next time you don't need to enter the username password while connection this is onetime job okay just click on the test the test is
Speaker A
successful so connected so if you save what happens is it will add one more node here so next time onwards you don't need to enter all the details just click on the cancel so it added one node right
Speaker A
so next time onwards just you come here just right click and connect that's it inter just automatically it will connect to the database and also it will show all the tables views indexes packages which are all this see this these are
Speaker A
all the different kinds of tables which are present on the Oracle L database also different stuff is available these are all different stuff in the evng and also if you want to add so this is the window here we need to execute all the
Speaker A
SQL commands Okay so now if I want to disconnect this just right click on disconnect and close this window if you want to add one more node also I can add just click on here again add one more
Speaker A
stuff and again one more node it will add here this is the way to work with the SQL Developer and now just connect it opens the window right I have some tables here so here I have different kinds of tables which is
Speaker A
already created then how we interact suppose if I type font increase Just moment all right select suppose star from employee this is not case sensitive okay so you can type in small letters as well as you can type in capital letters it is
Speaker A
is not and also it should end with the semicolon this is a syntax so now if I give this command so this will give us the data which is retrieved from the database that is retrieved from the database so this is how we can interact
Speaker A
with the database through database client okay now this is a basic understanding of client okay now what I can do here is this is my connection details now we talk about SQL what is SQL SQL is a language used to communicate with the
Speaker A
database object so what type of commands are available under SQL there are different types of commands are available under SQL so what are those commands so SQL language commands it divided into again sub languages okay the first one is
Speaker A
ddl ddl what is data data definition language data definition language and the second thing is DML data manipulation language data manipulation language and third one DRL or dql what is DRL data retrieval language and based upon the kind of
Speaker A
commands see this if you want to create a table drop a table okay definition level so all the definition level commands are grouped together put it into one kind of category that is called ddl and if you want to manipulate some
Speaker A
data or if you want to insert or if you want to delete something so those kind of commands are group together and put it in one category and DRL and dql so data retrieving for data retrieving we will use only one command that is Select
Speaker A
command so that command is a part of DRL or dql so data retrieval l language data retrial language or or data query language data query language this is one category and another category is TCL transactional transactional or transaction
Speaker A
control language and one more category DCL data control language data control language so these are all different five categories the SQL is divided so SQL language is divided to based upon the activities so data definition it says it contains only
Speaker A
definition commands like creating command dropping the table creating a table so those kind of commands will be the ddl contents and DML means data manipulation so this these commands these set of commands will work on only on data like updating data or inserting
Speaker A
data or deleting the data so these kind of activities these kind of commands comes under the DML and DRL or dql data retrieval language or data query language so data retrieval in the sense already data is present just we are
Speaker A
getting the data so retrieving the data so we have a select command that comes under the DRL or tql there is another commands called TCL transaction control language what is transaction control language means suppose if you have a
Speaker A
table we are inserting 10 uh uh 10 records and we have updated some records and we need to save that particular at that particular point so for controlling the transactions so for that kind of activities we will use a TCL and
Speaker A
DCL data control language so data control language in the sense suppose I have a table with some data I want to give the table to the another user on the same database and also I want to give some permissions on my table then
Speaker A
he can use my table you can use select and you can get the data from my table until unless I provide permissions on on my table other users cannot access the table so also permissions I can give the
Speaker A
multiple levels I can give only select permission or else I can give only the update permission or I can give only the delete permission if I give delete permission what will happen the user can delete the table itself so I can give
Speaker A
only select permission so if I provide only select permission what will happen he can only select or view the data he cannot corrupt the data so that kind of activities we can do using commands those are all comes under the data
Speaker A
control language ddl DML DRL or dql TCL and DCL transaction control language and data control language so these are all the different types of commands are there under SQL under SQL now we will see what are the commands are there under this
Speaker A
category ddl data def definition language so the command itself says data definition so what is a data definition definition in the sense we need to Creation or alteration or deletion or renaming the table so those are called definition level activities right so it
Speaker A
has a certain commands create is a one command alter is a one command already we table is created but I want to alter something because I want to rename the column or want to add one more column to
Speaker A
the table so those are all definition level activities so alter is a one command and also if you want to drop or if you want to delete the complete table then we have a drop command and also we
Speaker A
have a truncate command also we have a rename command so these are all the commands which are all doing the same kind of activities so all together comes under the ddl data definition language and there is what is the use of ddl what
Speaker A
is the use of D ddl so it is a collection of five commands create alter drop tranet and rename using these commands we can do the definition level activities now one more category is DML data manipulation language so under this
Speaker A
what are the different commands will come data manipulation it says clearly data manipulation what is manipulation inserting or updating or deleting so these kind of activities comes under the DML right so here insert is one command used for
Speaker A
inserting the data so these all commands Works only on the data not definition okay so inserting the data so insert is a one command and if you want to update the data so that is update is a one
Speaker A
command and if you want to delete some rows or if you want to delete some kind of data we have a delete command Okay so these are all commands comes under the DML data manipulation language insert update and delete DML
Speaker A
operations these are called DML operations basically these commands are works on data now another command is DRL or dql DRL or dql commands so here we have only one command and in previous days people are called select is also part of
Speaker A
DML but that is a different kind of command so they have created one more category under DRL uker we have a select command so this is only for selecting the data from the database and apart from this we have a
Speaker A
TCL transaction control language we are going to learn all these commands Okay step by step so transaction control language so under transaction control language we have three commands commit is one command roll back these are all not case
Speaker A
sens you can give all small letters commands or you can give all capital letters or you can give mixed no issues one more command is roll back command and one more is save point save point so these three commands comes under the TCL
Speaker A
transaction control language and finally we have a DCL command Okay so D data control language so under data control language we have only two commands Grant and revoke as I said DCL commands are used for giving some permissions on
Speaker A
our tables to the different users granting the permission Grant is used for granting the some privileges or permissions on our tables or objects to the other users and if you want to take back permission from the other users
Speaker A
then we can go for the revo command whatever grants we have provided to the user if you want to get back to those grants we will use a Revo command so these are all commands are part of ddl
Speaker A
DML DRL or dql TCL or DCL data control language so these are all again part of SQL so learning SQL means learning all these commands how we can work with these commands Okay is it clear e
Topics:Oracle databaseOracle 11g installationSQL DeveloperSQL Plusdatabase clientdatabase serverOracle downloadOracle setupSDET QASQL basics
