Whats the best resource you refer to learn database design, mysql conepts

#1

Post by rajusykam » Fri, Mar 12, 2010, 11:31 AM UTC

hi frnds,

Please suggest me some e-book or online resource where can i learn

1. database design 2. normalization 3. indexing - types 4. performance issues 5. mysql queries - with examples

in simple and complete.

Re: Whats the best resource you refer to learn database design, mysql conepts

#2

Post by barredo » Fri, Mar 12, 2010, 11:45 AM UTC

4. performance issues

"High Performance MySQL" ByJeremy D. Zawodny, Derek J. Balling — It's been very helpful to me

http://oreilly.com/catalog/9780596003067 http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...

Re: Whats the best resource you refer to learn database design, mysql conepts

#3

Post by rajusykam » Fri, Mar 12, 2010, 11:55 AM UTC

barredo wrote: post #2

4. performance issues "High Performance MySQL" ByJeremy D. Zawodny, Derek J. Balling — It's been very helpful to me http://oreilly.com/catalog/9780596003067 http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...

Thank you, can you refer me some online resources which are free.

Re: Whats the best resource you refer to learn database design, mysql conepts

#4

Post by bgraves » Fri, Mar 12, 2010, 3:31 PM UTC

http://en.wikibooks.org/wiki/Structured_Query_Language

http://en.wikibooks.org/wiki/MySQL

Re: Whats the best resource you refer to learn database design, mysql conepts

#5

Post by barredo » Fri, Mar 12, 2010, 7:36 PM UTC

rajusykam wrote: post #3

barredo wrote: post #2

4. performance issues "High Performance MySQL" ByJeremy D. Zawodny, Derek J. Balling — It's been very helpful to me http://oreilly.com/catalog/9780596003067 http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...

Thank you, can you refer me some online resources which are free.

The authors of the book also have a blog: http://www.mysqlperformanceblog.com/ it has lots of good reads

Re: Whats the best resource you refer to learn database design, mysql conepts

#6

Post by rajusykam » Wed, Mar 17, 2010, 6:34 AM UTC

bgraves wrote: post #4

http://en.wikibooks.org/wiki/Structured_Query_Language http://en.wikibooks.org/wiki/MySQL

Thanks for the great Links.!

Re: Whats the best resource you refer to learn database design, mysql conepts

#7

Post by rajusykam » Wed, Mar 17, 2010, 6:37 AM UTC

barredo wrote: post #5

rajusykam wrote: post #3

Earlier quoted context omitted.

Thank you, can you refer me some online resources which are free.

The authors of the book also have a blog: http://www.mysqlperformanceblog.com/ it has lots of good reads

once again thanks for that...