WEBVTT 00:00.570 --> 00:01.560 Hello, my name is Typhoon. 00:01.560 --> 00:03.420 Welcome to another lecture of our course. 00:03.420 --> 00:08.880 And in this section we will set up our coding environment. 00:08.880 --> 00:14.820 So let's begin by installing the resources we will need to complete the exercises in this course. 00:14.820 --> 00:20.430 And in this section you will install a text editor, download the example code and data, and then install 00:20.430 --> 00:26.850 the PostgreSQL database system and its companion graphical user interface, which is pgadmin. 00:26.850 --> 00:30.060 And I will also tell you how to get help if you need it. 00:30.060 --> 00:36.000 So when you are finished, your computer will have a robust environment for you to learn how to analyze 00:36.000 --> 00:38.250 data with SQL. 00:38.250 --> 00:41.370 So now let's install the text editor. 00:41.370 --> 00:44.490 Firstly, which is the source data you will need. 00:44.550 --> 00:50.940 Add two SQL databases typically stored in a multiple text files, often in a format called comma separated 00:50.940 --> 00:55.680 files, which is CSV, so comma separated values. 00:55.680 --> 01:00.520 So you will learn more about CSV format in next lectures, but. 01:01.210 --> 01:08.710 And for now, let's make sure you have a text editor that will let you open those files without inadvertently 01:08.710 --> 01:10.240 harming the data. 01:10.360 --> 01:13.200 So a common business application. 01:13.240 --> 01:19.660 Word processors and spreadsheet programs tend to introduce styles or hidden characters into files without 01:19.660 --> 01:25.540 asking, and that makes using them for the work problematic. 01:25.570 --> 01:29.870 And as data author expects data in precise formats. 01:29.890 --> 01:36.430 So, for example, if you put if you open a CSV file with Microsoft Excel, the program will automatically 01:36.430 --> 01:38.770 alter some data to make it more human readable. 01:38.770 --> 01:44.260 And it will assume, for example, that an item code of zero. 01:45.490 --> 01:46.360 Nine. 01:47.650 --> 01:51.660 Three is date and the format is 9th March. 01:51.670 --> 01:52.140 Right? 01:52.150 --> 01:57.880 So text editors deal exclusively with plain text with no embellishments such as formatting. 01:57.880 --> 02:05.680 And for that reason, programmers use them to edit files that hold source code data and software configurations. 02:05.710 --> 02:10.890 All cases where you want your text to be treated as text or nothing more. 02:10.900 --> 02:15.310 So any text editor should work for this course purpose. 02:15.310 --> 02:18.460 So if you have a favorite, feel free to use it. 02:18.460 --> 02:30.390 So here I have some examples which is open source and here free to use here which is notepad plus plus 02:31.040 --> 02:31.290 plus. 02:31.300 --> 02:34.540 So let's get started with installing notepad plus plus here. 02:34.540 --> 02:38.710 Just notepad plus plus and here you will get an. 02:39.890 --> 02:43.430 Um, notepad plus plus website which is here. 02:43.460 --> 02:49.190 Click on the notepad plus plus.org and here you will come to download sections. 02:49.220 --> 02:50.870 Download the last version of it. 02:51.540 --> 02:57.000 And here after that, select your operating system, which is in this case, my operating system is 02:57.000 --> 02:57.710 64 bit. 02:57.720 --> 02:59.400 That's why I will install the 64 bit. 02:59.400 --> 03:06.720 You can also install for 32 bit or you can install for arm 64 and so on. 03:07.900 --> 03:13.750 If you are using Linux, the default word processors will be okay for you. 03:14.020 --> 03:16.810 So here after that. 03:18.160 --> 03:18.990 We'll use. 03:19.030 --> 03:26.140 We will also install the Visual Studio code by Microsoft Visual Studio code. 03:26.170 --> 03:29.410 Here we double click it two times. 03:29.800 --> 03:40.660 And here I want this lecture too quick because we will wait and we will see more lectures in next. 03:42.250 --> 03:43.870 Sections of our course. 03:43.990 --> 03:46.720 And it's it's a basic task. 03:46.870 --> 03:50.740 And if you have any problems with installing these softwares, you can contact me. 03:50.980 --> 03:54.190 I will answer to your questions immediately. 03:54.190 --> 03:55.840 So let's download for Windows. 03:55.840 --> 04:02.140 In this case, you can also download for macOS Linux and other operating systems. 04:02.140 --> 04:08.410 And here we are also installing the VS code, Visual Studio code and here. 04:10.000 --> 04:13.020 Uh, more advanced users will prefer to work in a common line. 04:13.030 --> 04:18.130 May want to use um, text editors which are vim. 04:18.130 --> 04:25.120 And if you have Linux, in most cases, vim will come as a default. 04:25.270 --> 04:26.230 So. 04:27.710 --> 04:34.690 And now let's first now let's install the PostgreSQL and the PGADMIN. 04:34.700 --> 04:44.120 So in this lecture we will also install both the PostgreSQL database system and a companion graphical 04:44.120 --> 04:46.820 administrative tool, which is pgadmin. 04:47.060 --> 04:54.440 Like think of Pgadmin as a helpful visual workspace for managing your Postgres or SQL database so its 04:54.440 --> 05:02.120 interface lets you see your database objects, manage settings, import and export data and write queries, 05:02.120 --> 05:05.180 which is the code that retrieves data from your database. 05:05.300 --> 05:13.190 So one benefit of using PostgreSQL is that open source community has provided excellent guidelines that 05:13.190 --> 05:18.260 make it easy to get PostgreSQL up and running. 05:18.260 --> 05:27.050 So now I recommend you install the latest available version of PostgreSQL for your operations system 05:27.050 --> 05:32.730 to ensure that it's up to date on security patches and new features. 05:33.280 --> 05:43.340 So here let's come to the first result postgresql.org and click on download here. 05:43.360 --> 05:45.880 So now click on download. 05:47.210 --> 05:53.150 And here, as you can see, we have several options Linux, Mac OS, Windows, BSD and Solaris. 05:53.420 --> 05:57.350 And here in the in this case, our operating system is Windows. 05:57.350 --> 06:00.630 That's why we're going to click on the windows and install that. 06:00.650 --> 06:09.650 So here, as you can see here, PostgreSQL version is less, version is 15 and that's what we're going 06:09.650 --> 06:10.580 to install it. 06:10.580 --> 06:12.470 So here download the installer. 06:22.150 --> 06:24.760 And now we will install the latest version. 06:25.960 --> 06:26.710 For Windows. 06:30.720 --> 06:33.270 And your download should begin in a few seconds. 06:36.720 --> 06:38.430 It's almost 300MB. 06:38.460 --> 06:42.630 Since this is installing, we're going to firstly assign this. 06:42.720 --> 06:46.680 This PostgreSQL is downloading. 06:46.710 --> 06:49.800 We're going to install the Visual Studio code. 06:49.800 --> 06:53.340 It's just a very basic task you will see here now. 07:00.800 --> 07:01.310 Here. 07:01.520 --> 07:02.390 You can run. 07:06.900 --> 07:10.500 I accept their agreement after reading it. 07:13.760 --> 07:16.100 Next and create a desktop icon. 07:17.090 --> 07:19.400 Uh, next and lastly install. 07:19.700 --> 07:21.530 So let's see. 07:21.980 --> 07:24.020 Our download is downloading here. 07:24.020 --> 07:24.260 Yeah. 07:24.260 --> 07:30.800 As you can see here, PostgreSQL 15 .2.2, Windows 64 bit. 07:31.160 --> 07:34.190 And here our Visual Studio is installing. 07:55.880 --> 07:56.780 Click on finish. 08:07.510 --> 08:07.780 Here. 08:07.780 --> 08:08.560 It's opened. 08:17.140 --> 08:21.880 And now, as you can see, this is our starting screen. 08:21.880 --> 08:27.550 And here you can create a new file, open file, open folder, so you can actually open most of the 08:27.550 --> 08:28.480 text files. 08:28.630 --> 08:31.810 So here you can also select a language from here. 08:32.420 --> 08:39.230 Well, here you can also select batch C plus plus and so on is here. 08:39.290 --> 08:43.880 SQL As you can see, we also have the option from here, which we will use that. 08:44.330 --> 08:47.810 Let's actually increase this font a little bit here to see. 08:48.750 --> 08:51.900 Let's write things here and. 08:53.200 --> 08:53.590 Here. 08:54.100 --> 08:59.260 In order to increase the fonts here, you will go to preferences and settings. 09:00.710 --> 09:05.140 There was also several keyboard shortcuts for this here. 09:05.600 --> 09:06.740 Keyboard shortcuts. 09:06.740 --> 09:12.470 And here you can see all of the keyboard shortcuts in Visual Studio in the spec page. 09:12.470 --> 09:17.870 So you can also use the Visual Studio works like a browser, which is a makes it easy to work with. 09:17.870 --> 09:22.580 And here you can close this, come to different tabs. 09:23.800 --> 09:26.760 It just has a system like in browsers. 09:27.390 --> 09:30.990 Here, let's increase the font size and as you can see, oops. 09:32.250 --> 09:32.580 Here. 09:32.580 --> 09:37.760 As you can see here, our font size is increased, so let's actually make it 22. 09:37.770 --> 09:38.460 So it will. 09:39.720 --> 09:42.870 A more visible and that's it. 09:42.900 --> 09:43.560 Yeah. 09:43.800 --> 09:45.420 So it installed. 09:45.420 --> 09:51.270 Now let's go to as you can see, PostgreSQL is downloaded now click on Open It. 09:51.300 --> 09:53.490 We can close our browser now for now. 09:54.850 --> 09:55.240 And. 09:55.240 --> 09:55.600 Yeah. 09:57.590 --> 09:59.270 It will open right now. 10:02.710 --> 10:03.220 Here, click on. 10:03.220 --> 10:03.790 Yes. 10:04.580 --> 10:05.810 Oh, because we often. 10:05.960 --> 10:06.650 Twice. 10:09.730 --> 10:12.730 So we can close our Visual Studio code. 10:21.820 --> 10:25.720 I take some time, depending on your computer's performance. 10:26.140 --> 10:29.570 It will have to open this now. 10:29.590 --> 10:30.310 Here. 10:34.580 --> 10:40.010 Yeah, let's actually open this again and it might be some trouble with it starting. 10:53.200 --> 10:53.830 Perfect. 10:54.130 --> 10:55.480 Here we will close it. 10:57.640 --> 10:59.170 We see the logo here. 10:59.710 --> 11:01.060 Now it's disappeared. 11:03.750 --> 11:04.530 Yeah, perfect. 11:04.560 --> 11:07.320 Now click on Next Next here. 11:07.320 --> 11:12.210 As you can see, there's a components to get a detailed description, which is all of them. 11:12.390 --> 11:13.110 Click on next. 11:13.140 --> 11:13.980 Next. 11:14.500 --> 11:18.370 And you can also provide a password for the database user. 11:18.370 --> 11:21.610 In this case, I will put a password for one, two, three. 11:21.640 --> 11:22.840 One, two, three. 11:23.490 --> 11:24.300 That's it. 11:24.330 --> 11:30.360 The port we're going to use and we're going to we will listen for you will learn all of these concepts 11:30.360 --> 11:33.970 in this course here selected. 11:33.990 --> 11:38.460 Okay to be used new database cluster we will use default local. 11:39.200 --> 11:39.830 Next. 11:40.690 --> 11:41.440 And. 11:41.680 --> 11:42.710 Yeah, that's it. 11:53.440 --> 11:54.280 Yeah, that's installing. 12:03.710 --> 12:04.340 And I will. 12:04.340 --> 12:10.700 While waiting for this, I will stop the video and we'll continue when the installing is finished. 12:10.700 --> 12:13.100 And we'll see you later. 12:15.070 --> 12:16.600 Now it's almost installed. 12:16.780 --> 12:22.870 Now creating an installer because it also created the database cluster. 12:23.290 --> 12:25.390 Create a database and so on. 12:26.150 --> 12:28.870 Here, as you can see here, it's finished. 12:29.740 --> 12:31.450 So when the. 12:33.490 --> 12:35.290 Uh, here now. 12:35.290 --> 12:37.240 We will click on next. 12:38.230 --> 12:39.160 Of finish. 12:39.160 --> 12:41.980 And here you can see this. 12:41.980 --> 12:48.850 So we're going to click on as you can see, this wizard will help you to complete compliment your postures 12:49.360 --> 12:59.320 and enterprise DB Postgres plus installation and you will select this Postgres PostgreSQL 15 and click 12:59.320 --> 13:00.130 on Next. 13:01.010 --> 13:03.140 Now we will install some applications here. 13:03.380 --> 13:07.130 So now we will expand the spiral expansions menu. 13:07.790 --> 13:15.550 Spiral Extension's menu and select the Postgis Postgis. 13:15.620 --> 13:20.560 We will search for that Postgis file extensions here. 13:20.570 --> 13:23.930 As you can see, we will select on check. 13:23.960 --> 13:30.470 We will check the checkbox on postgis here and after that. 13:34.130 --> 13:37.850 You may see more than one listed here if you so choose. 13:37.850 --> 13:39.110 The newest version. 13:39.110 --> 13:41.690 In this case, we are seeing only one. 13:42.420 --> 13:45.090 So also expand the add ons. 13:45.120 --> 13:47.670 Add ons, tools and utilities. 13:47.670 --> 13:56.730 Here this and we will select the EDB language pack which installs support for programming languages, 13:56.730 --> 13:58.020 including Python. 13:58.380 --> 14:00.030 And here we will select. 14:02.000 --> 14:06.050 Last version and we will click through several times. 14:06.050 --> 14:11.090 We will need to wait while the installer downloads the additional components. 14:11.090 --> 14:15.620 That's it with the extensions and plugins. 14:15.770 --> 14:17.720 Now we can click on next. 14:18.960 --> 14:19.440 Here. 14:24.060 --> 14:25.380 Now it's downloading our. 14:26.410 --> 14:30.850 Exceptions, as you can see, is 77MB almost. 14:31.920 --> 14:36.150 To 7000kB, but it's 77MB, which you will learn. 14:36.330 --> 14:37.860 This next lectures. 14:38.280 --> 14:39.390 And here. 14:43.280 --> 14:45.620 The download just now. 14:51.410 --> 14:52.400 Almost done. 14:55.160 --> 14:58.250 Five, four, three, and then here. 15:00.040 --> 15:01.030 Now click on next. 15:02.630 --> 15:03.020 Oops. 15:19.000 --> 15:21.520 Now it will also several. 15:22.440 --> 15:23.290 The deals here. 15:28.230 --> 15:32.490 Now, all the installation files have been successfully downloaded. 15:32.670 --> 15:34.080 We'll click on next. 15:41.930 --> 15:42.830 Here, click on. 15:43.340 --> 15:43.570 Okay. 15:43.580 --> 15:45.080 You can choose the language here. 15:46.070 --> 15:46.490 Okay. 15:53.110 --> 15:54.190 And that's it. 15:54.220 --> 15:55.690 We're going to click on next. 15:55.720 --> 15:56.650 Next. 15:57.540 --> 15:58.920 Here since it's installing here. 16:04.590 --> 16:08.250 Now our language pack setup wizard is installed. 16:08.250 --> 16:11.430 Click on finish and here the complete opposite. 16:11.700 --> 16:12.600 Restart your computer. 16:12.600 --> 16:14.040 Would you like to restart now? 16:14.040 --> 16:14.820 Yes. 16:15.150 --> 16:17.760 And here we are restarting our computer. 16:19.910 --> 16:31.100 And after all of this installed and here right P SQL and you are able to see this SQL command line which 16:31.100 --> 16:32.790 you will learn in next lectures. 16:32.810 --> 16:33.740 See you later.