PostGIS in Action (2nd)
Where the adventure begins
Translate:



PostGIS in Action: (ed. #2) Appendix C - SQL primer

1st Edition Chapters    PostGIS In Action 2nd Edition Chapters

  • Information Schema
  • Basic SQL functions available in most relational databases
  • JOINS (INNER, OUTER, LEFT, RIGHT, FULL, INTERSECT, EXCEPT)
  • Doing SELECTS, INSERTS, UPDATES, and DELETES
  • Using Aggregates
  • Using subselects
  • Window functions and Window aggregates
  • Common Table Expressions (CTEs)