Practical book on relational databases with SQL

[ZeGato]

Hello,

I'm looking for a book on relational databases, that uses SQL, that is practical with lots of examples, and the least possible amount of jargon. Specifically, I have issues understanding how to translate the E/R model into the relational model (relations to tables), and the book that I have right now has lots of text but no structured examples to learn from.

Thank you for any help!

 

[jedishrfu]

This may answer your ER model question:

https://www.tutorialspoint.com/dbms/er_model_to_relational_model.htm

There are other online references on this site too. O'reilly has some SQL books that are good references but won't necessarily teach you how to use it effectively or conceptually.

Other onlines are:

https://www.google.com/search?newwi...3i10j0i13i30j0i22i10i30j0i8i13i30.CwSQl7e2X_w

There H2Database.com which is a java based database as a single jar file that can do a lot of SQL commands for experimentation.

http://h2database.com/html/main.html

It has a command line or web based access. It can run standalone of connected to an application with other apps accessing it via JDBC api. And is quite cool.

 

[verty]

Hello,

I'm looking for a book on relational databases, that uses SQL, that is practical with lots of examples, and the least possible amount of jargon. Specifically, I have issues understanding how to translate the E/R model into the relational model (relations to tables), and the book that I have right now has lots of text but no structured examples to learn from.

Thank you for any help!

Can I steer you away from this mentality? You want the best, most accurate database model possible so that it works the way you expect. And it needs to be laid out the right way or you could run into problems later when you do more complicated stuff. So I agree with the authors who write about the theory because it's only when you know the theory that you will understand what is good and what is bad. Otherwise you will have a recipe to follow without understanding it and that is no good, IMHO.