Forums Register Login

Good book for MySQL queries ?

+Pie Number of slices to send: Send
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 ?
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
 

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
+Pie Number of slices to send: Send
Thank you Jeanne and Roel. Got MySQL Cookbook
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
@ 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
Weeds: because mother nature refuses to be your personal bitch. But this tiny ad is willing:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 646 times.
Similar Threads
Info about - OCA (1Z0-007)
prepare Oracle OPCA ceterfication
comparison of dates
Java with PLSQL
Oracle or DB2
Thread Boost feature
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 04:05:56.