• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Good book for MySQL queries ?

 
Ranch Hand
Posts: 529
19
Eclipse IDE MySQL Database Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 11604
178
Hibernate jQuery Eclipse IDE Spring MySQL Database AngularJS Tomcat Server Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE MySQL Database Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you Jeanne and Roel. Got MySQL Cookbook
 
Ranch Hand
Posts: 38
Android Ruby Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE MySQL Database Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic