In this first epsiode of this Arduino Basics video series I will talk about the main functions of the ATmega328P Arduino boards and the fundamental code commands that you will need to create very basic Arduino sketches.
Hello Everyone! Today in this video I am going to step by step guide you How to install PostgreSQL for Relational DataBase Management System (RDBMS) on Windows 10. Windows (64-bit).
Then we will install pgAdmin 4 for using PostgreSQL in a Graphical User Interface (GUI). You can also use PostgreSQL Command-line Interface if you wish.
The PostgreSQL installers created by EnterpriseDB are designed to make it quick and simple to install PostgreSQL on your computer. The installer provides:
– A distribution-independent PostgreSQL installation.
– The popular open-source PostgreSQL administration tool, pgAdmin.
– The StackBuilder package manager (used to download and install drivers, tools, and applications to complement your PostgreSQL installation).
In my previous video, I’ve shown How to install Eclipse IDE on your Windows 10.
Link: https://youtu.be/Prv9xbtBPvU
Geeky Script (
@GeekyScript) is Computer Science – Educational Videos Creator 🎉
You can support by buying a coffee ☕️ here — https://www.buymeacoffee.com/geekyscript
✻ I really hope you find this video useful. ♥
✻ Please click on the CC button to read the subtitles of this video.
Now our main question is How to Install PostgreSQL & pgAdmin 4 on Windows 10?
So let’s begin…
Step 1. First You need to download PostgreSQL. For that, just follow the following link. https://www.postgresql.org/download/windows/
This page will lead to the PostgreSQL download on Windows 10. So just click on download and it will start downloading automatically.
Step 2. After downloading just double-click on the installation file for installing Postgresql on your Windows 10 OS. 64 bit. In my video, I have shown you step by step on how to install Postgresql. Just follow that if you are facing any issues.
Step 3. Now after installing PostgreSQL on your Windows 10 OS, it’s time to download pgAdmin 4. So for that just follow the following link to download pgAdmin 4 on your windows 10 os.
link: https://www.pgadmin.org/download/pgadmin-4-windows/
Step 4. After downloading pgAdmin 4, now just simply double click on it for installation. If you face any difficulty just follow my video. There I have shown each and every step one by one. So just follow that.
Step 5. After installing pgAdmin 4 just click on launch. Then you need to give the password. You should give the password that you have used during the installation of your PostgreSQL on your windows 10 64bit os.
Step 6. After your password verified you should get to see the pgAdmin graphical user interface (GUI). So here just create a new database to check if everything is just working fine.
Step 7. After creating a new database now it’s time to create a new table where we will store data. So follow my video to know how to create a table on the PostgreSQL database.
So that’s all my friends! In my following videos, I’m looking forward to posting videos on how to connect your PostgreSQL with eclipse ide and how to run java applications by connecting with PostgreSQL. Thanks a lot once again for watching this video! Do Subscribe 🙂
Topics addressed in this tutorial:
How To Download And Install PostgreSQL and pgAdmin On Windows 10 64 bit OS
Install PostgreSQL on Windows 10
How to Install PostgreSQL and Get Started
Install pgAdmin 4 on Windows 10
How to Install pgAdmin 4 and Get Started
PostgreSQL installation windows 10
—————————————————————————
THANK YOU so much for watching!
Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos 🙂
When writing T-SQL, Microsoft’s take on the SQL database language, the commands have to come in a certain order. This is:
– SELECT (selecting data)
– FROM (stating which table to get data from)
– WHERE (any filtering conditions)
– GROUP BY (specifying any aggregation to perform)
– HAVING (any filtering to perform on aggregated data)
– ORDER BY (which order to display the final rows in)
It is vital that you put these commands in the right order, otherwise you’ll get a syntax error. The acronym for the commands is SFWGHO, so it’s really just a question of finding a way to remember this series of letters.
Solutions
When he first met this problem, the author of this article trawled the Internet for acronyms. I found one site which was running a competition, with one entrant:
Slippery Fish Will Garnish Hungry Orcas
Surely there must be better acronyms than that! A little reflection came up with the following ideas:
Six Fat Wives Gross Husbands Out
Sweaty Feet Will Give Horrible Odours
Out of these, the second seems better (it’s certainly in better taste!). So here is our recommendation for how to remember the order of commands in SQL:
SWEATY or SELECT
FEET or FROM
WILL or WHERE
GIVE or GROUP BY
HORRIBLE or HAVING
ODOURS or ORDER BY
So now there’s no excuse for getting the order of SQL commands wrong, we just need to find a way to remember to put commas in the right place all the time…
