Jan,
There are a lot of resources available. Each database program has a different dialect of SQL, and I find the PostgreSQL on-line manual has an excellent introduction of SQL and even some theoretical issues. I would start there (its free and directly applicable to using PostgreSQL).
Searching on the web will yield some tutorials but these tend to be pretty brief. There is a discussion group at DbForums that has some information. There are also occasional subject specific articles, such as on data modeling.
Many books are available for download. Joe Celko is a well respected author and just about anything with his name on it is good. Here are some specific suggestions.
An introduction to database vocabulary and terms:
Date, C.J. (2006). The relational database dictionary. Sebastopol, CA: O"Reilly
Database design and concepts:
Hernandez, M.J. (2003). Database design for mere mortals (2nd ed.). New York: Addison-Wesley.
Bagui, S. & Earp, R. (2003). Database design using entity-relationship diagrams. New York: Auerbach Publications.
Celko, J. (1999). Joe Celko's data and databases: concepts in practice. San Francisco: Morgan Kaufman.
SQL
Celko, J. (2005). Joe Celko's SQL programming style. Amsterdam: Elsevier.
Gulutzan, P., & Peltzer, T. (2002). SQL performance tuning. New York: Addison Wesley.
Faroult, S., & Robson, P. (2006). The are ot SQL. Sebastopol, CA: O'Reilly.
Tow, D. (2003). SQL tuning. Sebastopol, CA: O'Reilly.
----- Original Message -----
Sent: Wednesday, February 07, 2007 9:43 PM
Subject: [GENERAL] SQL textbook
Hello,
I would like to ask for a hint for a good SQL textbook. I don't want just a
reference manual but real textbook with a theoretical background so I could
to design my databases following the general rules as normal forms and so
on.
I mean something on the net of course.
Thank you
Jan Mura
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
