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

• 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)

This chapter highlights the more or less ANSI/ISO SQL Compliant features of PostgreSQL. It introduces the basic concepts of SQL. For those familiar with SQL already, it showcases some of the high-level ANSI SQL features that PostgreSQL supports that you would expect of an enterprise relational database.

Save 40% off on Third Edition of PostGIS In Action and other Manning published books Offer ends August 19th, 2022

pgRouting: A Practical Guide is available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.