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

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

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!

Timestamps:
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

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

[KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

[denizalkan]

This was super useful! Thank you so much! I was trying to install PostgreSQL and I didn't know how to "start" things and I searched for hours, only ended up running into very long and complicated terminal commands that I had to run that kept giving me errors. Nowhere did it say I had to use pgAdmin to start things up. Thanks again for this clear and concise video!

[duckmanhannibal]

great video, took me a while but the last stage with the 'select * from public', I kept getting an error of 'error at or near select'. I had to highlight JUST the select query then run it for it to be successful