• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Good book for MySQL queries ?

 
Ganish Patil
Ranch Hand
Posts: 529
19
Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Netbeans IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to use MySQL database soI need to know SQL which is used for MySQL because I read SQL/PL SQL by ivan bayros a couple of years ago, I found SQL for Oracle & MySQL is little different so I will use MySQL in company, want to learn SQL for MySQL database till that depth so I'll be able to deal with more than 100000 records in database. Please any book suggestion ?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL doesn't vary that much across databases. PL/SQL is Oracle specific, but SQL is pretty similar. MySQL is free so I recommend you download it and start writing code.
 
Roel De Nijs
Sheriff
Posts: 10665
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ganish Patil wrote:want to learn SQL for MySQL database till that depth so I'll be able to deal with more than 100000 records in database. Please any book suggestion ?

You don't need to know SQL in depth to handle 100K records in a database. From a database perspective that's very few records...

This wiki book is probably a good starting point and it's free And the title of this article is very promising as well: 12 Best MySQL Database Books for Your Library
 
Ganish Patil
Ranch Hand
Posts: 529
19
Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Netbeans IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Jeanne and Roel. Got MySQL Cookbook
 
Marc Laffan
Greenhorn
Posts: 26
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Unless you're a database administrator you're not going to need to know MySQL 100% inside and out.

For example, knowing the difference between WHERE and HAVING is probably never going to come up in your work (They result in the same data, but WHERE filters at the source while HAVING filters the data once you've received it all).

On the other hand, you'll definitely need to know basic stuff like the CRUD statements (select, update, etc), the various joins involved in SQL, UNION, concatenation of strings, date/time manipulation, prepared statements and I'm sure some other things that I can't quite recall at the moment.

Your milage may vary of course, as I'm sure I have limited experience in MySQL when compared to other Ranchers.

Also, I should mention that I've never owned an SQL book outside of the absolutely most basic introductory books on the subject.
 
Ganish Patil
Ranch Hand
Posts: 529
19
Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Netbeans IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@ Marc yes I just need to know how to make efficient queries like using joins and all ( I won't remember all of them now as I had read few years ago ) so I could fetch my data in proper manner. I found some site I can't mention here as per rule which teaches basic things except procedures, triggers like those things. I did programs of procedure and triggers long time ago but don't know its usage. Anyway will learning start by today. Thank you for help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic