PostGIS in Action (3rd)
Where the adventure begins
Translate:



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

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st Edition Chapters

This is one of the free download chapters of the book, you can get your free copy from Appendix C SQL Primer free download

  • 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