3 ms·
And please remember, you cannot "read" yourself to better knowledge. Download a sql server (postgres if you ask me) and play around... The big leap is imho, th
by svennek 14y ago
And please remember, you cannot "read" yourself to better knowledge. Download a sql server (postgres if you ask me) and play around...
The big leap is imho, the difference between procedural (do-this-do-that code like most programming languages) and declarative syntax (I want "xxxx" and I don't care how you get it) which is how SQL works... And thinking in sets...
- subrat_rout 14y agoApart from postgres site, is there any good book with hands on practice exercises available on Postgres?
- EEGuy 14y agoCelko's SQL Puzzles and Answers: http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-ebook/dp/B0014AG7S4/ http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-eb...
- EEGuy 14y ago++Postgres; ++Celko; ++play around; Recommend Postgres' own concise tutorial: http://www.postgresql.org/docs/9.2/static/tutorial-sql.html http://www.postgresql.org/docs/9.2/static/tutorial-sql.html for starters. Also, after you've cracked joins, learn the 'WITH' clause ( http://www.postgresql.org/docs/9.0/static/queries-with.html http://www.postgresql.org/docs/9.0/static/queries-with.html ), it's good: 'WITH' restructures the more difficult 'middle-outward' subquery syntax to a top-down 'detail-to-summary' structure. Far easier to build, debug, and re-grok 6 months later.