|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
database design/theory
Can anyone point to some good links on database design and theory. I'm broke, so right now I can't by books. I searched all over the web, but can't seem to find the resources I need.
I've developed some apps using php and mysql. I've read some post here on devshed regarding various databases whic have made me want to look deeper into really understanding db design. By no means am I stuck with mysql, it's just like all the beginners, this is what I started with. I read some posts where rycamor gives some good insightes into postgres -- things I know nothing about such as transactions, key contrains and the like.
__________________
Some day I'll create a smart quote to put here. |
|
#2
|
||||
|
||||
|
A good start, and an invaluable resource for any programmer is:
www.w3schools.com it gets the basic SQL blood pumping. Then try the more text heavy: http://www.firstsql.com/tutor.htm Transactions: http://www.firstsql.com/tutor5.htm Key constraints: http://www.firstsql.com/tutor6.htm#refer |
|
#3
|
||||
|
||||
|
Introduction to Data Modeling
http://www.utexas.edu/its/windows/d...e/datamodeling/ rudy http://r937.com/ |
|
#4
|
|||
|
|||
|
Nice link, rudy. Thanks!
|
|
#5
|
||||
|
||||
|
Nice links. My co-worker just lent me a nice database theory book. I will read it, along with the above resources. That should give me a little deeper understanding on database management/design. I will start reading as soon as I'm finished with Sendmail, fourth edition
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > database design/theory |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|