Hello, my name is Typhoon.
Welcome to another lecture of our course.
And in this section we will set up our coding environment.
So let's begin by installing the resources we will need to complete the exercises in this course.
And in this section you will install a text editor, download the example code and data, and then install
the PostgreSQL database system and its companion graphical user interface, which is pgadmin.
And I will also tell you how to get help if you need it.
So when you are finished, your computer will have a robust environment for you to learn how to analyze
data with SQL.
So now let's install the text editor.
Firstly, which is the source data you will need.
Add two SQL databases typically stored in a multiple text files, often in a format called comma separated
files, which is CSV, so comma separated values.
So you will learn more about CSV format in next lectures, but.
And for now, let's make sure you have a text editor that will let you open those files without inadvertently
harming the data.
So a common business application.
Word processors and spreadsheet programs tend to introduce styles or hidden characters into files without
asking, and that makes using them for the work problematic.
And as data author expects data in precise formats.
So, for example, if you put if you open a CSV file with Microsoft Excel, the program will automatically
alter some data to make it more human readable.
And it will assume, for example, that an item code of zero.
Nine.
Three is date and the format is 9th March.
Right?
So text editors deal exclusively with plain text with no embellishments such as formatting.
And for that reason, programmers use them to edit files that hold source code data and software configurations.
All cases where you want your text to be treated as text or nothing more.
So any text editor should work for this course purpose.
So if you have a favorite, feel free to use it.
So here I have some examples which is open source and here free to use here which is notepad plus plus
plus.
So let's get started with installing notepad plus plus here.
Just notepad plus plus and here you will get an.
Um, notepad plus plus website which is here.
Click on the notepad plus plus.org and here you will come to download sections.
Download the last version of it.
And here after that, select your operating system, which is in this case, my operating system is
64 bit.
That's why I will install the 64 bit.
You can also install for 32 bit or you can install for arm 64 and so on.
If you are using Linux, the default word processors will be okay for you.
So here after that.
We'll use.
We will also install the Visual Studio code by Microsoft Visual Studio code.
Here we double click it two times.
And here I want this lecture too quick because we will wait and we will see more lectures in next.
Sections of our course.
And it's it's a basic task.
And if you have any problems with installing these softwares, you can contact me.
I will answer to your questions immediately.
So let's download for Windows.
In this case, you can also download for macOS Linux and other operating systems.
And here we are also installing the VS code, Visual Studio code and here.
Uh, more advanced users will prefer to work in a common line.
May want to use um, text editors which are vim.
And if you have Linux, in most cases, vim will come as a default.
So.
And now let's first now let's install the PostgreSQL and the PGADMIN.
So in this lecture we will also install both the PostgreSQL database system and a companion graphical
administrative tool, which is pgadmin.
Like think of Pgadmin as a helpful visual workspace for managing your Postgres or SQL database so its
interface lets you see your database objects, manage settings, import and export data and write queries,
which is the code that retrieves data from your database.
So one benefit of using PostgreSQL is that open source community has provided excellent guidelines that
make it easy to get PostgreSQL up and running.
So now I recommend you install the latest available version of PostgreSQL for your operations system
to ensure that it's up to date on security patches and new features.
So here let's come to the first result postgresql.org and click on download here.
So now click on download.
And here, as you can see, we have several options Linux, Mac OS, Windows, BSD and Solaris.
And here in the in this case, our operating system is Windows.
That's why we're going to click on the windows and install that.
So here, as you can see here, PostgreSQL version is less, version is 15 and that's what we're going
to install it.
So here download the installer.
And now we will install the latest version.
For Windows.
And your download should begin in a few seconds.
It's almost 300MB.
Since this is installing, we're going to firstly assign this.
This PostgreSQL is downloading.
We're going to install the Visual Studio code.
It's just a very basic task you will see here now.
Here.
You can run.
I accept their agreement after reading it.
Next and create a desktop icon.
Uh, next and lastly install.
So let's see.
Our download is downloading here.
Yeah.
As you can see here, PostgreSQL 15 .2.2, Windows 64 bit.
And here our Visual Studio is installing.
Click on finish.
Here.
It's opened.
And now, as you can see, this is our starting screen.
And here you can create a new file, open file, open folder, so you can actually open most of the
text files.
So here you can also select a language from here.
Well, here you can also select batch C plus plus and so on is here.
SQL As you can see, we also have the option from here, which we will use that.
Let's actually increase this font a little bit here to see.
Let's write things here and.
Here.
In order to increase the fonts here, you will go to preferences and settings.
There was also several keyboard shortcuts for this here.
Keyboard shortcuts.
And here you can see all of the keyboard shortcuts in Visual Studio in the spec page.
So you can also use the Visual Studio works like a browser, which is a makes it easy to work with.
And here you can close this, come to different tabs.
It just has a system like in browsers.
Here, let's increase the font size and as you can see, oops.
Here.
As you can see here, our font size is increased, so let's actually make it 22.
So it will.
A more visible and that's it.
Yeah.
So it installed.
Now let's go to as you can see, PostgreSQL is downloaded now click on Open It.
We can close our browser now for now.
And.
Yeah.
It will open right now.
Here, click on.
Yes.
Oh, because we often.
Twice.
So we can close our Visual Studio code.
I take some time, depending on your computer's performance.
It will have to open this now.
Here.
Yeah, let's actually open this again and it might be some trouble with it starting.
Perfect.
Here we will close it.
We see the logo here.
Now it's disappeared.
Yeah, perfect.
Now click on Next Next here.
As you can see, there's a components to get a detailed description, which is all of them.
Click on next.
Next.
And you can also provide a password for the database user.
In this case, I will put a password for one, two, three.
One, two, three.
That's it.
The port we're going to use and we're going to we will listen for you will learn all of these concepts
in this course here selected.
Okay to be used new database cluster we will use default local.
Next.
And.
Yeah, that's it.
Yeah, that's installing.
And I will.
While waiting for this, I will stop the video and we'll continue when the installing is finished.
And we'll see you later.
Now it's almost installed.
Now creating an installer because it also created the database cluster.
Create a database and so on.
Here, as you can see here, it's finished.
So when the.
Uh, here now.
We will click on next.
Of finish.
And here you can see this.
So we're going to click on as you can see, this wizard will help you to complete compliment your postures
and enterprise DB Postgres plus installation and you will select this Postgres PostgreSQL 15 and click
on Next.
Now we will install some applications here.
So now we will expand the spiral expansions menu.
Spiral Extension's menu and select the Postgis Postgis.
We will search for that Postgis file extensions here.
As you can see, we will select on check.
We will check the checkbox on postgis here and after that.
You may see more than one listed here if you so choose.
The newest version.
In this case, we are seeing only one.
So also expand the add ons.
Add ons, tools and utilities.
Here this and we will select the EDB language pack which installs support for programming languages,
including Python.
And here we will select.
Last version and we will click through several times.
We will need to wait while the installer downloads the additional components.
That's it with the extensions and plugins.
Now we can click on next.
Here.
Now it's downloading our.
Exceptions, as you can see, is 77MB almost.
To 7000kB, but it's 77MB, which you will learn.
This next lectures.
And here.
The download just now.
Almost done.
Five, four, three, and then here.
Now click on next.
Oops.
Now it will also several.
The deals here.
Now, all the installation files have been successfully downloaded.
We'll click on next.
Here, click on.
Okay.
You can choose the language here.
Okay.
And that's it.
We're going to click on next.
Next.
Here since it's installing here.
Now our language pack setup wizard is installed.
Click on finish and here the complete opposite.
Restart your computer.
Would you like to restart now?
Yes.
And here we are restarting our computer.
And after all of this installed and here right P SQL and you are able to see this SQL command line which
you will learn in next lectures.
See you later.