I really like
this page. If you are looking for a 'quick reference'
type of thing, this probably isn't it, but its a good intro
and covers a lot of important topics. It's more about database
design than an SQL language reference.
Hope this helps,
-Mark
mlogan@ccs.neu.edu | [reply] |
I agree, philip greenspun definitely has some good resources, for sql and web design and programming. Other stuff by him is here
| [reply] |
toadi, I can't point you at a good book to teach you about database techniques in general, but if you elect to go with mySQL, I can highly recommend the Paul Dubois book from New Riders Press. I can also tell you that as good as most O'Reilly books are, the 'mSQL & MySQL' books is a complete and total waste of money.
I realize this wasn't the question you asked, but with the cost of technical books, I *hate* winding up with a bad book in my collection.
--Chris
e-mail jcwren | [reply] |
If you'd like to learn SQL online, here's a good course. At least I'm told it's good. I haven't actually taken it :)
Cheers,
Ovid | [reply] |
Thanx,
but I found that one to, but it's to beginner aimed. I'm looking for the more intermediate kind of thing.
Wel I can mak databases, connect to them make simple relation. But I want to be perfect and want to know what I'm doing wrong(maybe?) and what I can improve with some good literature.
--
My opinions may have changed,
but not the fact that I am right
| [reply] |
Surprisingly, I learned a lot about SQL from the mysql documentation.
http://www.mysql.com/documentation/index.html
If you want to learn to use it with DBI, you can get the ORA "DBI" book, or:
perldoc DBI | [reply] |
I must first say that I'm biased towards Oracle, but you might want to check out technet.oracle.com
if you EVER want to leverage Oracle on your site(s). You'll need access, though.
Some basic oracle specific design docs are at: www.technet.oracle.com
Just in case... | [reply] |