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.