SQL

Right, I am looking to finally come to terms with SQL.

Can anyone recommend a good guide? The ones I've found are either written for complete novices and don't actually do anything more then adding a new database, while the rest seem to be for specific objects and assume a decent level of knowledge.

I am looking to make a database of people with basic attirbutes that I can then run queries on through a webpage. Any good guides on such a thing? I have Apache, PHP and MySQL installed on a box.

Sparks

Well, for a start, there are libraries that will help, like MDB2. After that, for the basic SQL stuff itself, to be honest any of the basic tutorials are okay to start with, and the tutorial in MySQL manual itself is even reasonably good.

Cheers, most of the basic stuff seems stop at:

Now you've installed MySQL, just intall wordpress and you are set to go.

PixelPixie

I find "Beginning MySQL Database Design and Optimization" by J.Stephens and C.Russel (APRESS) to be excellent. It starts with the MySQL basics, and goes on to Column and Table types, keys, indexes and normalization, Operators, branching, functions, joins, temporary tables, transactions and MySQL programming in subsequent chapters.
I'd recommend it highly.

TinCool

The w3schools website is an extremely useful reference. It covers all the basics giving various examples.

PixelPixie

TinCool wrote: »

The w3schools website is an extremely useful reference. It covers all the basics giving various examples.

I second that! W3schools has excellent tutorials on all aspects of web scripting and programming from (x)html to JavaScript to PHP to SQL. I recommend it to my web authoring students.
However, you can't beat a good book for those times when you're connectionless or can't use your laptop. A good book is invaluable imo.:)