Getting Started w/ PostgreSQL! | Download, Install & Add Data

PostgreSQL is an open source relational database and is going to be one of the most common databases you’ll run into as a data engineer.

You’ll most often see it as the back end of a database or a source for your analytics platform but it’s also something that some companies may choose to build their entire data warehouse.

So in today’s video I’m going to walk you through step-by-step how to download and install Postgres on your local machine, create a database objects and finally write some queries to insert some data.

Thank you for watching!

New to data engineering? Check out some of my free Starter Guide PDFs – https://bit.ly/3mmxYQ5

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
0:00 – Intro
0:29 – Download & Install
2:25 – Connect w/ pgAdmin
3:18 – Create a Database
4:33 – Create a Table
5:18 – Insert Data w/ SQL

▬▬▬▬▬▬ Useful Links 🔗 ▬▬▬▬▬▬
► https://www.postgresql.org/

▬▬▬▬▬▬ Want to learn more? 📚 ▬▬▬▬▬▬
Data Engineering ► https://bit.ly/3TPNzXA
Data-Build-Tool (dbt) ► https://bit.ly/3HCS0ht
Snowflake ► https://bit.ly/3mTpqk0
GitHub ► https://bit.ly/331QnuJ

▬▬▬▬▬▬ Connect with me 🔄 ▬▬▬▬▬▬
Twitter ► https://www.twitter.com/kahandata
Newsletter ► https://www.kahandatasolutions.com/blog
Website ► https://www.kahandatasolutions.com

Getting Started w/ PostgreSQL! | Download, Install & Add Data
#kahandatasolutions #dataengineering #postgresql