PostgreSQL tutorial for beginners 2021: setup postgreSQL and pgAdmin | postgreSQL .csv import

Watch a postgreSQL tutorial for beginners designed by Railsware Academy. Setup postgreSQL & pgAdmin from scratch, create servers, databases, schemas, and tables. Learn how to import data from .csv to postgreSQL in just a few clicks!
Use a practice sheet designed by Railsware Academy: https://bit.ly/3eEli0w

What you will need to download:
postgreSQL for Mac: https://postgresapp.com/
postgreSQL for Windows: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
pgAdmin: https://www.pgadmin.org/download/

Learn more about localhost: https://bit.ly/3fLbJxX
Discover how schemas work: https://www.postgresql.org/docs/current/ddl-schemas.html

Timestamps:
00:42 – Download and setup postgreSQL (Mac example)
01:37 – Download and setup pgAdmin
02:26 – pgAdmin structure
02:59 – Localhost server in postgreSQL
03:58 – Create a database in postgreSQL
04:21 – What is a schema? Public schema in postgreSQL
05:23 – How to create a table in postgreSQL
06:10 – How to create fields, select data types, and set SQL constraints in postgreSQL
08:42 – Import data from csv to postgreSQL

💌 Contact Railsware to build your software product http://bit.ly/contactrailsware
🤝 Join Railsware team http://bit.ly/railswarecareers
✅ Subscribe to Railsware and learn the most efficient data analytics tools with us!
🧐 Try Coupler.io – a tool for safe data imports from various tools to GSheets: https://bit.ly/3fMhSdk
🔌 Download Coupler.io in GSuite marketplace: https://bit.ly/2OFM4Lp