PostGIS in Action: Appendix C - SQL primer

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

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.

	Direct from the Publishers (Buy E-Book or Hard Copy) PostgreSQL 9.0 High Performance PostgreSQL 9.0 Admin Cookbook OpenStreetMap OpenLayers 2.10 Beginner's Guide