Re: Can anyone make suggestions for training / learning resources wrt databases.

2016-09-18 Thread Chris Samuel via luv-main
On Sunday, 18 September 2016 10:54:06 AM AEST h via luv-main wrote: > I am NOT looking for specific answers to these problems, but rather > some teaching / groundwork information about relational databases / > sql / postgis concepts. I've seen this recommended as an introduction to PostGIS: http

Re: Can anyone make suggestions for training / learning resources wrt databases.

2016-09-17 Thread Russell Coker via luv-main
On Sunday, 18 September 2016 10:54:06 AM AEST h via luv-main wrote: > * Writing sql / script files > * Structuring tables either within a database, or on a server These seem like good topics for hands-on training at the Beginners' SIG meetings. H can you make it to those meetings? Would anyon

Re: Can anyone make suggestions for training / learning resources wrt databases.

2016-09-17 Thread Trish Fraser via luv-main
Hi Hugh, > I am a linux hobbyist. > I have been using postgis for a while, at a hobby level, > to provide data for web pages and for QGIS. Are you using psql, or some other means for scripting? Postgis appears to be an extender for Postgres, so you could try adding Postgres to your search quer

Re: Can anyone make suggestions for training / learning resources wrt databases.

2016-09-17 Thread Craig Sanders via luv-main
On Sun, Sep 18, 2016 at 10:54:06AM +1000, h wrote: > There are two areas I have been unable to find information on: > > * Writing sql / script files An sql script file is just a bunch of sql commands in a sequence. There are numerous ways to run such a script, including piping or redirecting it

Can anyone make suggestions for training / learning resources wrt databases.

2016-09-17 Thread h via luv-main
Hi, I am a linux hobbyist. I have been using postgis for a while, at a hobby level, to provide data for web pages and for QGIS. I am reasonably confident writing sql statements, and being able to find the information I need to get the data I am after. There are two areas I have been unable to