Hello and welcome.
In this video.
I'll be showing you how to connect to our core database using toad.
So first thing to do is launch the toad for a call.
Right click on the icon click on Run as Administrator.
Make sure you run as administrator.
Click on that and that will initialize.
You may get a prompt for use I can't control click yes to that.
We'll just keep it a few minutes to initialize and launch the application.
So once the application launches you keep in this prompt here where you see the licence key the site
message the expiration date so it will expire after 30 days.
It shows you here gives your licence number addition for a call DP addition quantity is one seat remain
in trials in court to expatriation date.
Keep it to date.
Once you've done just click Done hand it all initialise and lunch talk for Oracle.
So once it launches you may hear more frog noise sawbones the software lunches so to come to record
data bit we need to enter som details here in this box here.
If you don't see this box are king.
Im just going to close this for a minute so I can tell you how it came up.
He good to database.
Sorry could to session and click on new connection and I'll give you this dialogue box here.
So we need to enter the credentials to connect to the database so Im going to connect to the sample
scheme.
You can see his call.
Use a schema so you can type user name or scheme and name so the schema name is going to be here char
in like case the password is also going to be here are in lower case.
Now there are three ways you can connect DNS direct and held up as an elder.
Are very common in corporate environment.
So if you are in a low real low production environment DNS held will be more suitable for the purpose
of this local lab.
I'm going to click on direct So I'm going to be quite indirect.
We need to end time host.
My host will be typing in 1 2 7 0 0 1.
Some of this information were provided during the installation of the Oracle database way give you the
current set is the port that we are going to connect to is 1 5 to 1.
Next we need to enter.
He said All right so see here we are going to type in xy and we will be the name of the database.
That's XY and here.
He can see we are collecting as X here as well.
It is possible to harbour multiple nations to different data bases.
So when you in a corporate or production environment you may have different databases you connect to
use in stood hand to differentiate databases you connect to your skin colour code them.
Example Here I I'm going to Colo.
Could these two be.
See.
Maybe blue.
So I know that where my collection comes up and I see navy blue I know I'm connected to the hitch are
scheme.
So once you've entered all the relevant details just click on this contact option.
If everything checks out the key issues connect you to the or call database to give it a few minutes
to check out the credentials to make sure everything too.
So we are waiting.
Excellent.
It looks good so far that we can see this screen here.
This is the main edit.
This is where you write your queries.
You can see this then you have connected successfully to the database.
It gives you some information here on how you connect it so to quickly test that we can communicate
with some of the objects in the database like a table.
You can quickly click on here.
This option the scheme at browser.
That he told show you the objects for laski can see here these are all the tables available for this
page schema.
I'm just going to quickly write a key query to check some data in a table so I'm going to use this Employees
table here to what are to come here.
Typing select.
Star
from
employees So basically what this query is saying is I want to get all the data from this table called
employees.
So once I have done I just click on this here to execute this script or this.
If you're wrong in a script then this is what you do is grybas gleave who goes several roster member
moner Running a single line so I click on this one here.
Alternatively you can just press F 9.
So it turns talk is returned a total of four hundred and seven records from this table called employees.
So this has given me any indication that I'm able to communicate with the database crew to interact
with some data.
So that's basically it for this video on connecting to under a cloud database using to.
Thanks for watching and bye for now.