Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports. Thank you, Eva Radding Librarian Facing History and Ourselves 16 Hurd Road Brookline, MA 02445 617-735-1680 Eva_Radding@facing.org This email and any information attached to it may be confidential. If you are not the intended recipient, any use or dissemination of the information is prohibited. Please notify the sender that you received the email in error and delete any record of this message.
I find the "For Dummies " books are usually pretty good for getting started. I have the one for SQL Server 2008 and I expect there's one for MySQL. Andrew Buxton IDS, Brighton, UK From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Eva Radding Sent: 09 November 2010 15:49 To: koha@lists.katipo.co.nz Subject: [Koha] Learning SQL Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports. Thank you, Eva Radding Librarian Facing History and Ourselves 16 Hurd Road Brookline, MA 02445 617-735-1680 Eva_Radding@facing.org This email and any information attached to it may be confidential. If you are not the intended recipient, any use or dissemination of the information is prohibited. Please notify the sender that you received the email in error and delete any record of this message. This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914
I found the Mysql manual tutorial section very helpful. It is based on the Menangerie database which comes with the manual and then there are the examples of advanced queries at the end. T Alfred Vahau Physics Division SNPS, UPNG Papua New Guinea On Tue, 2010-11-09 at 16:10 +0000, Andrew Buxton wrote:
I find the “For Dummies “ books are usually pretty good for getting started. I have the one for SQL Server 2008 and I expect there’s one for MySQL.
Andrew Buxton
IDS, Brighton, UK
From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Eva Radding Sent: 09 November 2010 15:49 To: koha@lists.katipo.co.nz Subject: [Koha] Learning SQL
Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports.
Thank you,
Eva Radding Librarian Facing History and Ourselves 16 Hurd Road Brookline, MA 02445 617-735-1680 Eva_Radding@facing.org
This email and any information attached to it may be confidential. If you are not the intended recipient, any use or dissemination of the information is prohibited. Please notify the sender that you received the email in error and delete any record of this message.
This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Eva, Back in September there was a similar question. I kept the answers and here were the titles that 4 people here suggested: 1. I found (and continue to find) this website very helpful for writing basic SQL reports: http://www.thundersoftware.com/churchdb/sqltutorial/sql_tutorial.html I tried a few books, but nothing really stood out for me. The books probably have info on some of the more complicated queries, but I was able to create the majority of our necessary reports based on the info from the Thunder Software site. That, and posting an occasional question on this list. The LibLime folks helped me compose a few of the tough ones-thank goodness!! 2. I use the MYSQL in a Nutshell book which has been helpful to me remembering the different sort and join commands. 3. I'm definitely still learning, but in the beginning I interlibrary loaned as many SQL books as possible and then purchased the ones that had helped me (I was starting from scratch) The titles I now have in my office are * Head First SQL * Beginning SQL queries * SQL fundamentals * SQL queries for mere mortals They all give me different things. I also use google searches for various SQL training materials. And I attended KohaCon 2009 and heard at least one of the sessions there. I also use the SQL Reports Library ( http://wiki.koha-community.org/wiki/SQL_Reports_Library <http://wiki.koha-community.org/wiki/SQL_Reports_Library> ) and ask on the mailing lists. ---- 4. There are some presentations from KohaCon last year on SlideShare (http://www.slideshare.net/group/koha-ils) that cover reports. Also, I often refer to the database structure in git (http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/ data/mysql/kohastructure.sql;hb=HEAD) when I need to find out what tables/fields are available for querying. As for learning MySQL, I learned that hands on cause I suck at learning from a book so I can't recommend any good reads - except the MySQL manual which I refer to all the time when I'm trying to remember who to query a specific date format or something like that. From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Eva Radding Sent: Tuesday, November 09, 2010 10:49 AM To: koha@lists.katipo.co.nz Subject: [Koha] Learning SQL Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports. Thank you, Eva Radding Librarian Facing History and Ourselves 16 Hurd Road Brookline, MA 02445 617-735-1680 Eva_Radding@facing.org This email and any information attached to it may be confidential. If you are not the intended recipient, any use or dissemination of the information is prohibited. Please notify the sender that you received the email in error and delete any record of this message. =
Eva Radding writes
Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports.
If your are runnig mySQL, you may want to install phpmyadmin, then play around with it's web interface. There you see the sql command as they are being sent to the server. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
participants (5)
-
Andrew Buxton -
Eva Radding -
Kurt Bodling -
T Alfred Vahau -
Thomas Krichel