Title:

  • Intro to PostgreSQL with Spatial Analysis Extensions

Code:

  • OGU001

Dates:

  • 24, 25, and 26 October, 2011

Location:

  • San Diego, CA

Cost:

  • $1975 per student
  • Early bird special - $1775 until August 30, 2011
  • Includes “Bootstrap Support”(tm) - up to 2 hours phone/email support on covered material during 30 days after course completion


Space is Limited -- Sign Up Now (Please indicate course title and code on the request form)


Description:

  • Students will learn the fundamentals of databases using PostgreSQL, geospatial database management using the PostGIS extensions to PostgreSQL, and basic data processing techniques using the PL/R extension which allows stored procedures to be written using R, a popular statistical computing language. Graduates will also receive bundled “Bootstrap Support”(tm), to help accelerate them through the initial learning curve when they leave the class.


Prerequisites:

  • An understanding of relational database fundamentals, including the ability to write SQL queries.
  • Basic familiarity with (or willingness to learn) the Linux command line.


Topics:

  • PostgreSQL History and Overview
  • System architecture, requirements, installation
  • Practical Exercise: build/install PostgreSQL from source
  • SQL syntax and data types, queries
  • Finding help and Introduction to various tools
  • Concurrency Control, Locking
  • Triggers/Rules
  • Indexes
  • Query Plans
  • Query Tuning
  • Functions
  • Server-side languages
  • Extending PostgreSQL
  • Practical Exercise: build/install PL/R from source
  • Writing functions with PL/pgSQL and PL/R
  • GIS Fundamentals
  • Introduction to PostGIS
  • Installing PostGIS
  • Creating a PostGIS Enabled Database
  • Creating PostGIS Tables, Views, & Indexes
  • Loading GIS Data
  • PostGIS Queries (Simple Features for SQL)


Space is Limited -- Sign Up Now (Please indicate course title and code on the request form)