Arduino Basics 101: Hardware Overview, Fundamental Code Commands

Previous video:
Make your own Coilgun:
DIY Buck/Boost Converter (Flyback) || How to step up/down DC voltage efficiently:
Support me for more videos:

You can get Arduino boards here (affiliate links):
Arduino Uno:
Arduino Nano:
Arduino Pro Mini:
FTDI board:
Arduino Uno:
Arduino Nano:
Arduino Pro Mini:
FTDI board:
Arduino Uno:
Arduino Nano:
Arduino Pro Mini:
FTDI board:

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.

2011 Lookalike by Bartlebeats
Ecstatic Wave, Jens Kiilstofte



How to Install PostgreSQL 13 & pgAdmin 4 on Windows 10 [ 2021 Update ] Complete guide

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.

Geeky Script (
@GeekyScript) is Computer Science – Educational Videos Creator 🎉
You can support by buying a coffee ☕️ here —

✻ 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.
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.

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 🙂

#postgreSQL #PostgresqlInstallation #Windows10 #postgreSQLforbeginners #SQL #sqlQueries #SQLforbeginners #RDBMS

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

✻ All about Android Studio:
✻ All about PostgreSQL:
✻ All about MongoDB:
✻ All about MySQL:
✻ All about WordPress:
✻ All about Java Spring:
✻ All about Maven:
✻ All about eBook:

THANK YOU so much for watching!
Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos 🙂

✻ Website:
✻ LinkedIn:
✻ Twitter:
✻ Email:
✻ YouTube channel:
Song: Jarico – Island
Music promoted by #BackgroundMusicWithoutLimitations
Free Download:



SFWGHO – A Way to Remember the Order of Commands in SQL

The Problem – SFWGHO

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.


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:







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…

Source by Andy J Brown