1 00:00:00,570 --> 00:00:01,560 Hello, my name is Typhoon. 2 00:00:01,560 --> 00:00:03,420 Welcome to another lecture of our course. 3 00:00:03,420 --> 00:00:08,880 And in this section we will set up our coding environment. 4 00:00:08,880 --> 00:00:14,820 So let's begin by installing the resources we will need to complete the exercises in this course. 5 00:00:14,820 --> 00:00:20,430 And in this section you will install a text editor, download the example code and data, and then install 6 00:00:20,430 --> 00:00:26,850 the PostgreSQL database system and its companion graphical user interface, which is pgadmin. 7 00:00:26,850 --> 00:00:30,060 And I will also tell you how to get help if you need it. 8 00:00:30,060 --> 00:00:36,000 So when you are finished, your computer will have a robust environment for you to learn how to analyze 9 00:00:36,000 --> 00:00:38,250 data with SQL. 10 00:00:38,250 --> 00:00:41,370 So now let's install the text editor. 11 00:00:41,370 --> 00:00:44,490 Firstly, which is the source data you will need. 12 00:00:44,550 --> 00:00:50,940 Add two SQL databases typically stored in a multiple text files, often in a format called comma separated 13 00:00:50,940 --> 00:00:55,680 files, which is CSV, so comma separated values. 14 00:00:55,680 --> 00:01:00,520 So you will learn more about CSV format in next lectures, but. 15 00:01:01,210 --> 00:01:08,710 And for now, let's make sure you have a text editor that will let you open those files without inadvertently 16 00:01:08,710 --> 00:01:10,240 harming the data. 17 00:01:10,360 --> 00:01:13,200 So a common business application. 18 00:01:13,240 --> 00:01:19,660 Word processors and spreadsheet programs tend to introduce styles or hidden characters into files without 19 00:01:19,660 --> 00:01:25,540 asking, and that makes using them for the work problematic. 20 00:01:25,570 --> 00:01:29,870 And as data author expects data in precise formats. 21 00:01:29,890 --> 00:01:36,430 So, for example, if you put if you open a CSV file with Microsoft Excel, the program will automatically 22 00:01:36,430 --> 00:01:38,770 alter some data to make it more human readable. 23 00:01:38,770 --> 00:01:44,260 And it will assume, for example, that an item code of zero. 24 00:01:45,490 --> 00:01:46,360 Nine. 25 00:01:47,650 --> 00:01:51,660 Three is date and the format is 9th March. 26 00:01:51,670 --> 00:01:52,140 Right? 27 00:01:52,150 --> 00:01:57,880 So text editors deal exclusively with plain text with no embellishments such as formatting. 28 00:01:57,880 --> 00:02:05,680 And for that reason, programmers use them to edit files that hold source code data and software configurations. 29 00:02:05,710 --> 00:02:10,890 All cases where you want your text to be treated as text or nothing more. 30 00:02:10,900 --> 00:02:15,310 So any text editor should work for this course purpose. 31 00:02:15,310 --> 00:02:18,460 So if you have a favorite, feel free to use it. 32 00:02:18,460 --> 00:02:30,390 So here I have some examples which is open source and here free to use here which is notepad plus plus 33 00:02:31,040 --> 00:02:31,290 plus. 34 00:02:31,300 --> 00:02:34,540 So let's get started with installing notepad plus plus here. 35 00:02:34,540 --> 00:02:38,710 Just notepad plus plus and here you will get an. 36 00:02:39,890 --> 00:02:43,430 Um, notepad plus plus website which is here. 37 00:02:43,460 --> 00:02:49,190 Click on the notepad plus plus.org and here you will come to download sections. 38 00:02:49,220 --> 00:02:50,870 Download the last version of it. 39 00:02:51,540 --> 00:02:57,000 And here after that, select your operating system, which is in this case, my operating system is 40 00:02:57,000 --> 00:02:57,710 64 bit. 41 00:02:57,720 --> 00:02:59,400 That's why I will install the 64 bit. 42 00:02:59,400 --> 00:03:06,720 You can also install for 32 bit or you can install for arm 64 and so on. 43 00:03:07,900 --> 00:03:13,750 If you are using Linux, the default word processors will be okay for you. 44 00:03:14,020 --> 00:03:16,810 So here after that. 45 00:03:18,160 --> 00:03:18,990 We'll use. 46 00:03:19,030 --> 00:03:26,140 We will also install the Visual Studio code by Microsoft Visual Studio code. 47 00:03:26,170 --> 00:03:29,410 Here we double click it two times. 48 00:03:29,800 --> 00:03:40,660 And here I want this lecture too quick because we will wait and we will see more lectures in next. 49 00:03:42,250 --> 00:03:43,870 Sections of our course. 50 00:03:43,990 --> 00:03:46,720 And it's it's a basic task. 51 00:03:46,870 --> 00:03:50,740 And if you have any problems with installing these softwares, you can contact me. 52 00:03:50,980 --> 00:03:54,190 I will answer to your questions immediately. 53 00:03:54,190 --> 00:03:55,840 So let's download for Windows. 54 00:03:55,840 --> 00:04:02,140 In this case, you can also download for macOS Linux and other operating systems. 55 00:04:02,140 --> 00:04:08,410 And here we are also installing the VS code, Visual Studio code and here. 56 00:04:10,000 --> 00:04:13,020 Uh, more advanced users will prefer to work in a common line. 57 00:04:13,030 --> 00:04:18,130 May want to use um, text editors which are vim. 58 00:04:18,130 --> 00:04:25,120 And if you have Linux, in most cases, vim will come as a default. 59 00:04:25,270 --> 00:04:26,230 So. 60 00:04:27,710 --> 00:04:34,690 And now let's first now let's install the PostgreSQL and the PGADMIN. 61 00:04:34,700 --> 00:04:44,120 So in this lecture we will also install both the PostgreSQL database system and a companion graphical 62 00:04:44,120 --> 00:04:46,820 administrative tool, which is pgadmin. 63 00:04:47,060 --> 00:04:54,440 Like think of Pgadmin as a helpful visual workspace for managing your Postgres or SQL database so its 64 00:04:54,440 --> 00:05:02,120 interface lets you see your database objects, manage settings, import and export data and write queries, 65 00:05:02,120 --> 00:05:05,180 which is the code that retrieves data from your database. 66 00:05:05,300 --> 00:05:13,190 So one benefit of using PostgreSQL is that open source community has provided excellent guidelines that 67 00:05:13,190 --> 00:05:18,260 make it easy to get PostgreSQL up and running. 68 00:05:18,260 --> 00:05:27,050 So now I recommend you install the latest available version of PostgreSQL for your operations system 69 00:05:27,050 --> 00:05:32,730 to ensure that it's up to date on security patches and new features. 70 00:05:33,280 --> 00:05:43,340 So here let's come to the first result postgresql.org and click on download here. 71 00:05:43,360 --> 00:05:45,880 So now click on download. 72 00:05:47,210 --> 00:05:53,150 And here, as you can see, we have several options Linux, Mac OS, Windows, BSD and Solaris. 73 00:05:53,420 --> 00:05:57,350 And here in the in this case, our operating system is Windows. 74 00:05:57,350 --> 00:06:00,630 That's why we're going to click on the windows and install that. 75 00:06:00,650 --> 00:06:09,650 So here, as you can see here, PostgreSQL version is less, version is 15 and that's what we're going 76 00:06:09,650 --> 00:06:10,580 to install it. 77 00:06:10,580 --> 00:06:12,470 So here download the installer. 78 00:06:22,150 --> 00:06:24,760 And now we will install the latest version. 79 00:06:25,960 --> 00:06:26,710 For Windows. 80 00:06:30,720 --> 00:06:33,270 And your download should begin in a few seconds. 81 00:06:36,720 --> 00:06:38,430 It's almost 300MB. 82 00:06:38,460 --> 00:06:42,630 Since this is installing, we're going to firstly assign this. 83 00:06:42,720 --> 00:06:46,680 This PostgreSQL is downloading. 84 00:06:46,710 --> 00:06:49,800 We're going to install the Visual Studio code. 85 00:06:49,800 --> 00:06:53,340 It's just a very basic task you will see here now. 86 00:07:00,800 --> 00:07:01,310 Here. 87 00:07:01,520 --> 00:07:02,390 You can run. 88 00:07:06,900 --> 00:07:10,500 I accept their agreement after reading it. 89 00:07:13,760 --> 00:07:16,100 Next and create a desktop icon. 90 00:07:17,090 --> 00:07:19,400 Uh, next and lastly install. 91 00:07:19,700 --> 00:07:21,530 So let's see. 92 00:07:21,980 --> 00:07:24,020 Our download is downloading here. 93 00:07:24,020 --> 00:07:24,260 Yeah. 94 00:07:24,260 --> 00:07:30,800 As you can see here, PostgreSQL 15 .2.2, Windows 64 bit. 95 00:07:31,160 --> 00:07:34,190 And here our Visual Studio is installing. 96 00:07:55,880 --> 00:07:56,780 Click on finish. 97 00:08:07,510 --> 00:08:07,780 Here. 98 00:08:07,780 --> 00:08:08,560 It's opened. 99 00:08:17,140 --> 00:08:21,880 And now, as you can see, this is our starting screen. 100 00:08:21,880 --> 00:08:27,550 And here you can create a new file, open file, open folder, so you can actually open most of the 101 00:08:27,550 --> 00:08:28,480 text files. 102 00:08:28,630 --> 00:08:31,810 So here you can also select a language from here. 103 00:08:32,420 --> 00:08:39,230 Well, here you can also select batch C plus plus and so on is here. 104 00:08:39,290 --> 00:08:43,880 SQL As you can see, we also have the option from here, which we will use that. 105 00:08:44,330 --> 00:08:47,810 Let's actually increase this font a little bit here to see. 106 00:08:48,750 --> 00:08:51,900 Let's write things here and. 107 00:08:53,200 --> 00:08:53,590 Here. 108 00:08:54,100 --> 00:08:59,260 In order to increase the fonts here, you will go to preferences and settings. 109 00:09:00,710 --> 00:09:05,140 There was also several keyboard shortcuts for this here. 110 00:09:05,600 --> 00:09:06,740 Keyboard shortcuts. 111 00:09:06,740 --> 00:09:12,470 And here you can see all of the keyboard shortcuts in Visual Studio in the spec page. 112 00:09:12,470 --> 00:09:17,870 So you can also use the Visual Studio works like a browser, which is a makes it easy to work with. 113 00:09:17,870 --> 00:09:22,580 And here you can close this, come to different tabs. 114 00:09:23,800 --> 00:09:26,760 It just has a system like in browsers. 115 00:09:27,390 --> 00:09:30,990 Here, let's increase the font size and as you can see, oops. 116 00:09:32,250 --> 00:09:32,580 Here. 117 00:09:32,580 --> 00:09:37,760 As you can see here, our font size is increased, so let's actually make it 22. 118 00:09:37,770 --> 00:09:38,460 So it will. 119 00:09:39,720 --> 00:09:42,870 A more visible and that's it. 120 00:09:42,900 --> 00:09:43,560 Yeah. 121 00:09:43,800 --> 00:09:45,420 So it installed. 122 00:09:45,420 --> 00:09:51,270 Now let's go to as you can see, PostgreSQL is downloaded now click on Open It. 123 00:09:51,300 --> 00:09:53,490 We can close our browser now for now. 124 00:09:54,850 --> 00:09:55,240 And. 125 00:09:55,240 --> 00:09:55,600 Yeah. 126 00:09:57,590 --> 00:09:59,270 It will open right now. 127 00:10:02,710 --> 00:10:03,220 Here, click on. 128 00:10:03,220 --> 00:10:03,790 Yes. 129 00:10:04,580 --> 00:10:05,810 Oh, because we often. 130 00:10:05,960 --> 00:10:06,650 Twice. 131 00:10:09,730 --> 00:10:12,730 So we can close our Visual Studio code. 132 00:10:21,820 --> 00:10:25,720 I take some time, depending on your computer's performance. 133 00:10:26,140 --> 00:10:29,570 It will have to open this now. 134 00:10:29,590 --> 00:10:30,310 Here. 135 00:10:34,580 --> 00:10:40,010 Yeah, let's actually open this again and it might be some trouble with it starting. 136 00:10:53,200 --> 00:10:53,830 Perfect. 137 00:10:54,130 --> 00:10:55,480 Here we will close it. 138 00:10:57,640 --> 00:10:59,170 We see the logo here. 139 00:10:59,710 --> 00:11:01,060 Now it's disappeared. 140 00:11:03,750 --> 00:11:04,530 Yeah, perfect. 141 00:11:04,560 --> 00:11:07,320 Now click on Next Next here. 142 00:11:07,320 --> 00:11:12,210 As you can see, there's a components to get a detailed description, which is all of them. 143 00:11:12,390 --> 00:11:13,110 Click on next. 144 00:11:13,140 --> 00:11:13,980 Next. 145 00:11:14,500 --> 00:11:18,370 And you can also provide a password for the database user. 146 00:11:18,370 --> 00:11:21,610 In this case, I will put a password for one, two, three. 147 00:11:21,640 --> 00:11:22,840 One, two, three. 148 00:11:23,490 --> 00:11:24,300 That's it. 149 00:11:24,330 --> 00: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 150 00:11:30,360 --> 00:11:33,970 in this course here selected. 151 00:11:33,990 --> 00:11:38,460 Okay to be used new database cluster we will use default local. 152 00:11:39,200 --> 00:11:39,830 Next. 153 00:11:40,690 --> 00:11:41,440 And. 154 00:11:41,680 --> 00:11:42,710 Yeah, that's it. 155 00:11:53,440 --> 00:11:54,280 Yeah, that's installing. 156 00:12:03,710 --> 00:12:04,340 And I will. 157 00:12:04,340 --> 00:12:10,700 While waiting for this, I will stop the video and we'll continue when the installing is finished. 158 00:12:10,700 --> 00:12:13,100 And we'll see you later. 159 00:12:15,070 --> 00:12:16,600 Now it's almost installed. 160 00:12:16,780 --> 00:12:22,870 Now creating an installer because it also created the database cluster. 161 00:12:23,290 --> 00:12:25,390 Create a database and so on. 162 00:12:26,150 --> 00:12:28,870 Here, as you can see here, it's finished. 163 00:12:29,740 --> 00:12:31,450 So when the. 164 00:12:33,490 --> 00:12:35,290 Uh, here now. 165 00:12:35,290 --> 00:12:37,240 We will click on next. 166 00:12:38,230 --> 00:12:39,160 Of finish. 167 00:12:39,160 --> 00:12:41,980 And here you can see this. 168 00:12:41,980 --> 00:12:48,850 So we're going to click on as you can see, this wizard will help you to complete compliment your postures 169 00:12:49,360 --> 00:12:59,320 and enterprise DB Postgres plus installation and you will select this Postgres PostgreSQL 15 and click 170 00:12:59,320 --> 00:13:00,130 on Next. 171 00:13:01,010 --> 00:13:03,140 Now we will install some applications here. 172 00:13:03,380 --> 00:13:07,130 So now we will expand the spiral expansions menu. 173 00:13:07,790 --> 00:13:15,550 Spiral Extension's menu and select the Postgis Postgis. 174 00:13:15,620 --> 00:13:20,560 We will search for that Postgis file extensions here. 175 00:13:20,570 --> 00:13:23,930 As you can see, we will select on check. 176 00:13:23,960 --> 00:13:30,470 We will check the checkbox on postgis here and after that. 177 00:13:34,130 --> 00:13:37,850 You may see more than one listed here if you so choose. 178 00:13:37,850 --> 00:13:39,110 The newest version. 179 00:13:39,110 --> 00:13:41,690 In this case, we are seeing only one. 180 00:13:42,420 --> 00:13:45,090 So also expand the add ons. 181 00:13:45,120 --> 00:13:47,670 Add ons, tools and utilities. 182 00:13:47,670 --> 00:13:56,730 Here this and we will select the EDB language pack which installs support for programming languages, 183 00:13:56,730 --> 00:13:58,020 including Python. 184 00:13:58,380 --> 00:14:00,030 And here we will select. 185 00:14:02,000 --> 00:14:06,050 Last version and we will click through several times. 186 00:14:06,050 --> 00:14:11,090 We will need to wait while the installer downloads the additional components. 187 00:14:11,090 --> 00:14:15,620 That's it with the extensions and plugins. 188 00:14:15,770 --> 00:14:17,720 Now we can click on next. 189 00:14:18,960 --> 00:14:19,440 Here. 190 00:14:24,060 --> 00:14:25,380 Now it's downloading our. 191 00:14:26,410 --> 00:14:30,850 Exceptions, as you can see, is 77MB almost. 192 00:14:31,920 --> 00:14:36,150 To 7000kB, but it's 77MB, which you will learn. 193 00:14:36,330 --> 00:14:37,860 This next lectures. 194 00:14:38,280 --> 00:14:39,390 And here. 195 00:14:43,280 --> 00:14:45,620 The download just now. 196 00:14:51,410 --> 00:14:52,400 Almost done. 197 00:14:55,160 --> 00:14:58,250 Five, four, three, and then here. 198 00:15:00,040 --> 00:15:01,030 Now click on next. 199 00:15:02,630 --> 00:15:03,020 Oops. 200 00:15:19,000 --> 00:15:21,520 Now it will also several. 201 00:15:22,440 --> 00:15:23,290 The deals here. 202 00:15:28,230 --> 00:15:32,490 Now, all the installation files have been successfully downloaded. 203 00:15:32,670 --> 00:15:34,080 We'll click on next. 204 00:15:41,930 --> 00:15:42,830 Here, click on. 205 00:15:43,340 --> 00:15:43,570 Okay. 206 00:15:43,580 --> 00:15:45,080 You can choose the language here. 207 00:15:46,070 --> 00:15:46,490 Okay. 208 00:15:53,110 --> 00:15:54,190 And that's it. 209 00:15:54,220 --> 00:15:55,690 We're going to click on next. 210 00:15:55,720 --> 00:15:56,650 Next. 211 00:15:57,540 --> 00:15:58,920 Here since it's installing here. 212 00:16:04,590 --> 00:16:08,250 Now our language pack setup wizard is installed. 213 00:16:08,250 --> 00:16:11,430 Click on finish and here the complete opposite. 214 00:16:11,700 --> 00:16:12,600 Restart your computer. 215 00:16:12,600 --> 00:16:14,040 Would you like to restart now? 216 00:16:14,040 --> 00:16:14,820 Yes. 217 00:16:15,150 --> 00:16:17,760 And here we are restarting our computer. 218 00:16:19,910 --> 00: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 219 00:16:31,100 --> 00:16:32,790 you will learn in next lectures. 220 00:16:32,810 --> 00:16:33,740 See you later.