Re: [GENERAL] seeking SQL book recommendation
On Thu, 24 Jan 2013, Bruno Wolff III wrote: For a client who needs to learn how to query the db: I found the postgresql documentation very useful for learning SQL. Two more suggestions: Rick van der Lans' 'Introduction to SQL, 4th Edition' for its comprehensiveness and extensive discussion on temporal queries. And, Joe Celko's 'SQL for Smarties' at whichever edition is current to learn some of the non-syntactical aspects that effect database development and use. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
On Wed, Jan 23, 2013 at 3:56 PM, Scott Ribe scott_r...@elevated-dev.com 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 ;-) OReilley's Learning SQL and SQL Cookbook are good places to start. After he has his footing, SQL Antipatterns, The Art of SQL,and SQL for Smarties are all good choices. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
I can recommend SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL as a good general SQL book. From: Scott Ribe scott_r...@elevated-dev.com To: Postgresql General pgsql-general@postgresql.org Sent: Wednesday, 23 January 2013, 22:56 Subject: [GENERAL] seeking SQL book recommendation 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 ;-) -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
On Wed, Jan 23, 2013 at 15:56:10 -0700, Scott Ribe scott_r...@elevated-dev.com 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 found the postgresql documentation very useful for learning SQL. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] seeking SQL book recommendation
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 ;-) -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
Scott Ribe wrote on 23.01.2013 23:56: 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 ;-) Not a book, but I like http://sqlzoo.net/ You can switch between different DBMS - including PostgreSQL - when doing the exercises -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
John R Pierce wrote on 24.01.2013 00:19: - 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. Speaking of cookbook: The DB2 SQL Cookbook is quite nice actually. http://mysite.verizon.net/graeme_birchall/id1.html Even though it's for DB2 most of it (except e.g. the XQuery stuff) can be used for PostgreSQL as well. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seeking SQL book recommendation
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general