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