On 01/23/2013 04:19 PM, John R Pierce wrote:
> On 1/23/2013 2:56 PM, Scott Ribe wrote:
>> For a client who needs to learn how to query the db:
>>
>> - No SQL knowledge at all; needs to start from square 1.
>>
>> - Smart, capable person, who will be in this position for a long time,
>> using this db for a long time.
>>
>> - No chance in hell this db will be moved off PG, so PG-centric is fine
>
>
> I can't recommend any specific book as I've not read any of them (and
> been doing SQL too long). But what I *can* recommend is creating a 'sql
> cookbook', maybe on an internal wiki or blog, with a bunch of sample
> queries specific to YOUR database schema that solve the sorts of
> problems your user base including this client are likely to come up
> against. start with the simplest things and move up to more complex.
> have a paragraph or two explaining each query, and example output.
>
>
I recommend the company find the cash and time to have this person go to
an SQL class. These have proven very helpful when in-house training
would put a large dent in an sql-savvy person's productivity.