neulatuntimittari.2.04 PostgreSQL
26.10.08
Tutorials?
PostgreSQL online resources, Postgresql.org
- PostgreSQL Primer for Busy People, Zaiste.net
- last updated 2017
- PostgreSQL Tutorial, Neon.com
26.10.11
SQL
https://sqlbolt.com/
Before learning the SQL syntax, it’s important to have a model for what a relational database actually is. A relational database represents a collection of related (two-dimensional) tables. Each of the tables are similar to an Excel spreadsheet, with a fixed number of named columns (the attributes or properties of the table) and any number of rows of data.
All future SQL related matters, even notes to this tutorial: 05 SQL
PostgreSQL
https://github.com/dwyl/learn-postgresql
[!NOTE] This tutorial covers 5 areas
- What is PostgreSQL?
- How do I get started with PostgreSQL? (a fully functioning example!)
- What is Structured Query Language (SQL)? (lots of example queries!)
- How do I write my own SQL Queries?
- How do I deploy my own PostgreSQL-based Application?
Once you have covered these areas, you will know if PostgreSQL is “right” for your needs, or if you need to keep looking for a different way to store data.