1
00:00:00,480 --> 00:00:01,730
Hello and welcome.

2
00:00:01,770 --> 00:00:02,870
In this video.

3
00:00:03,070 --> 00:00:11,420
I'll be showing you how to connect to our core database using toad.

4
00:00:11,670 --> 00:00:17,280
So first thing to do is launch the toad for a call.

5
00:00:17,280 --> 00:00:24,150
Right click on the icon click on Run as Administrator.

6
00:00:24,150 --> 00:00:26,730
Make sure you run as administrator.

7
00:00:26,730 --> 00:00:30,300
Click on that and that will initialize.

8
00:00:30,300 --> 00:00:35,640
You may get a prompt for use I can't control click yes to that.

9
00:00:35,880 --> 00:00:42,130
We'll just keep it a few minutes to initialize and launch the application.

10
00:00:42,230 --> 00:00:51,030
So once the application launches you keep in this prompt here where you see the licence key the site

11
00:00:51,070 --> 00:00:57,000
message the expiration date so it will expire after 30 days.

12
00:00:57,180 --> 00:01:07,300
It shows you here gives your licence number addition for a call DP addition quantity is one seat remain

13
00:01:07,480 --> 00:01:11,160
in trials in court to expatriation date.

14
00:01:11,320 --> 00:01:12,550
Keep it to date.

15
00:01:12,780 --> 00:01:22,040
Once you've done just click Done hand it all initialise and lunch talk for Oracle.

16
00:01:22,610 --> 00:01:33,190
So once it launches you may hear more frog noise sawbones the software lunches so to come to record

17
00:01:33,200 --> 00:01:38,950
data bit we need to enter som details here in this box here.

18
00:01:39,000 --> 00:01:41,200
If you don't see this box are king.

19
00:01:41,270 --> 00:01:45,600
Im just going to close this for a minute so I can tell you how it came up.

20
00:01:45,620 --> 00:01:48,850
He good to database.

21
00:01:49,350 --> 00:01:55,740
Sorry could to session and click on new connection and I'll give you this dialogue box here.

22
00:01:55,920 --> 00:02:02,130
So we need to enter the credentials to connect to the database so Im going to connect to the sample

23
00:02:02,130 --> 00:02:02,600
scheme.

24
00:02:02,610 --> 00:02:03,540
You can see his call.

25
00:02:03,540 --> 00:02:10,290
Use a schema so you can type user name or scheme and name so the schema name is going to be here char

26
00:02:11,520 --> 00:02:17,940
in like case the password is also going to be here are in lower case.

27
00:02:17,940 --> 00:02:25,080
Now there are three ways you can connect DNS direct and held up as an elder.

28
00:02:25,140 --> 00:02:29,270
Are very common in corporate environment.

29
00:02:29,280 --> 00:02:36,630
So if you are in a low real low production environment DNS held will be more suitable for the purpose

30
00:02:36,690 --> 00:02:38,950
of this local lab.

31
00:02:38,970 --> 00:02:42,370
I'm going to click on direct So I'm going to be quite indirect.

32
00:02:42,390 --> 00:02:44,660
We need to end time host.

33
00:02:44,870 --> 00:02:53,480
My host will be typing in 1 2 7 0 0 1.

34
00:02:53,700 --> 00:02:59,910
Some of this information were provided during the installation of the Oracle database way give you the

35
00:03:00,360 --> 00:03:09,910
current set is the port that we are going to connect to is 1 5 to 1.

36
00:03:10,050 --> 00:03:13,320
Next we need to enter.

37
00:03:13,410 --> 00:03:25,650
He said All right so see here we are going to type in xy and we will be the name of the database.

38
00:03:26,700 --> 00:03:30,370
That's XY and here.

39
00:03:30,530 --> 00:03:33,650
He can see we are collecting as X here as well.

40
00:03:33,650 --> 00:03:39,330
It is possible to harbour multiple nations to different data bases.

41
00:03:39,570 --> 00:03:44,820
So when you in a corporate or production environment you may have different databases you connect to

42
00:03:44,820 --> 00:03:51,180
use in stood hand to differentiate databases you connect to your skin colour code them.

43
00:03:51,210 --> 00:03:53,430
Example Here I I'm going to Colo.

44
00:03:53,430 --> 00:03:55,370
Could these two be.

45
00:03:55,370 --> 00:03:56,290
See.

46
00:03:56,380 --> 00:03:57,270
Maybe blue.

47
00:03:57,660 --> 00:04:03,450
So I know that where my collection comes up and I see navy blue I know I'm connected to the hitch are

48
00:04:03,480 --> 00:04:04,340
scheme.

49
00:04:04,590 --> 00:04:10,700
So once you've entered all the relevant details just click on this contact option.

50
00:04:10,770 --> 00:04:18,330
If everything checks out the key issues connect you to the or call database to give it a few minutes

51
00:04:18,330 --> 00:04:22,420
to check out the credentials to make sure everything too.

52
00:04:23,670 --> 00:04:26,370
So we are waiting.

53
00:04:26,510 --> 00:04:27,050
Excellent.

54
00:04:27,050 --> 00:04:31,650
It looks good so far that we can see this screen here.

55
00:04:31,650 --> 00:04:33,920
This is the main edit.

56
00:04:34,140 --> 00:04:36,440
This is where you write your queries.

57
00:04:36,500 --> 00:04:41,240
You can see this then you have connected successfully to the database.

58
00:04:41,370 --> 00:04:50,370
It gives you some information here on how you connect it so to quickly test that we can communicate

59
00:04:50,430 --> 00:04:54,830
with some of the objects in the database like a table.

60
00:04:55,020 --> 00:04:57,480
You can quickly click on here.

61
00:04:57,540 --> 00:04:59,960
This option the scheme at browser.

62
00:05:00,210 --> 00:05:08,640
That he told show you the objects for laski can see here these are all the tables available for this

63
00:05:08,650 --> 00:05:10,170
page schema.

64
00:05:10,390 --> 00:05:19,710
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

65
00:05:19,710 --> 00:05:25,090
table here to what are to come here.

66
00:05:25,230 --> 00:05:27,460
Typing select.

67
00:05:31,360 --> 00:05:32,140
Star

68
00:05:34,660 --> 00:05:35,350
from

69
00:05:39,100 --> 00:05:46,180
employees So basically what this query is saying is I want to get all the data from this table called

70
00:05:46,240 --> 00:05:47,320
employees.

71
00:05:47,470 --> 00:05:54,070
So once I have done I just click on this here to execute this script or this.

72
00:05:54,070 --> 00:05:59,600
If you're wrong in a script then this is what you do is grybas gleave who goes several roster member

73
00:05:59,640 --> 00:06:02,700
moner Running a single line so I click on this one here.

74
00:06:02,920 --> 00:06:06,050
Alternatively you can just press F 9.

75
00:06:06,090 --> 00:06:15,010
So it turns talk is returned a total of four hundred and seven records from this table called employees.

76
00:06:15,010 --> 00:06:25,120
So this has given me any indication that I'm able to communicate with the database crew to interact

77
00:06:25,270 --> 00:06:26,650
with some data.

78
00:06:26,950 --> 00:06:35,900
So that's basically it for this video on connecting to under a cloud database using to.

79
00:06:36,070 --> 00:06:38,280
Thanks for watching and bye for now.
