best place(website) to practice Mysql database design ?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

best place(website) to practice Mysql database design ?

Post by PHPycho »

A very important topic:
For Dynamic site..Obviously when a good database design is done...almost more than 50% work is done..
Database design is the most important part in any dynamic site , i think so and so many of us...a thorough analysis
and Care should be given while designing database(optimization,performance etc)...Keeping this in mind...I (most of us)want to be very pro
in Mysql database design...for that i (we) need a best place to practice mysql database design...
I am searching a place ie website that gives us some project work to practice database design and we can see the solution to tally our design with existing solution in site...the website should contain a lots of various types project work to carry practices...
Note:By database design here i mean table design with appropriate fields with approriate interrelationship

I think this is very important question to all of us who want to carry life as dynamic web programmer.
I request all of Devnetworkians to share their knowledge, skills over here....Bythe way this is a forum by us ..for us..of us...isnt it?
(Please convey if i am not clear in my question)
Thanks in advance to all of YOU !!
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

Meh, every part is the most important part.

Practice on your own development server: I use Uniform Server, others use xampp or something like that.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

All that you seek can be gleaned from
  1. books
  2. the database's manual
  3. your own experiments
  4. asking us specific questions
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Moving this to the Databases forum.
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

Post by PHPycho »

I had a lot of books related to Mysql...
As i mentioned earlier...i need such website which gives some scenario of project
and its solution also(not required) and from that scenario we can design a database...
I think this is the best way to implement the database design...Books only give the concept
of queries n a bit more....
One cant be practicle and pro without going into real field ie without designing
database for a project..To be a pro one need a lot of practices...
Hope you got my point..
Again awaiting for help..
Thanks in advance..
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

Post by PHPycho »

Hello ....
Knock Knock.........
anybodys there.......
i am unable to get the required answer....
again Knock Knock......
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

you already got the required answer.
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

Post by PHPycho »

Pardon me.....
i am looking for a website which fulfills my requirements and so do of many.......
again awaiting for the help...
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

feyd wrote:All that you seek can be gleaned from
  1. books
  2. the database's manual
  3. your own experiments
  4. asking us specific questions
Post Reply