Re: [CODE4LIB] Learning Microsoft SQL
Hi Bill, A google search limited to US universities' sites like sql basics site:.edu turned up some nice results, including: http://www.suu.edu/it/admin/summit2007/cdsite/color/BTechnical/1414/1414.pdf http://myweb.brooklyn.liu.edu/gnarra/database/downloads/SQLTutorial.pdf Michael H -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Wilfred Drew Sent: 16 March 2012 18:31 To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] Learning Microsoft SQL I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
I would add that I learned a lot of SQL from this forum http://www.sqlteam.com/forums/ Sometimes the blunt criticism when someone shows you how only to see four replies don't do it like that, that's totally stupid, what did you learn that in a WROX book? helped me a lot early on. ___ Michael Friscia Manager, Digital Library Programming Services Yale University Library (203) 432-1856 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Michael Hopwood Sent: Monday, March 19, 2012 6:31 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Learning Microsoft SQL Hi Bill, A google search limited to US universities' sites like sql basics site:.edu turned up some nice results, including: http://www.suu.edu/it/admin/summit2007/cdsite/color/BTechnical/1414/1414.pdf http://myweb.brooklyn.liu.edu/gnarra/database/downloads/SQLTutorial.pdf Michael H -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Wilfred Drew Sent: 16 March 2012 18:31 To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] Learning Microsoft SQL I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
I can't resist saying that, for truly free (as in freedom), you might want to work with something like PostgreSQL. I wrote up an Introduction to SQL focused on PostgreSQL Evergreen a few years ago and released it under a CC-BY-SA license (per http://coffeecode.net/archives/212-Introduction-to-SQL-for-Evergreen-administrators.html ); the source for the introduction is at http://bzr.coffeecode.net/intro_to_sql/introduction_to_sql.txt Even though there are some PostgreSQL-specifics in the introduction, most of the same principles apply. Maybe it will be of use to you or someone else! Dan Wilfred Drew dr...@tc3.edu 3/16/2012 2:31 PM I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
If you do continue down the MS SQL road, bear in mind that MS SQL is basically a fork of Sybase, and they share Transact SQL. So most of the Sybase Transact-SQL documentation will apply. You can find the Sybase Transact-SQL User's Guide at: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/title.htm -Tod On Mar 19, 2012, at 11:18 AM, Dan Scott wrote: I can't resist saying that, for truly free (as in freedom), you might want to work with something like PostgreSQL. I wrote up an Introduction to SQL focused on PostgreSQL Evergreen a few years ago and released it under a CC-BY-SA license (per http://coffeecode.net/archives/212-Introduction-to-SQL-for-Evergreen-administrators.html ); the source for the introduction is at http://bzr.coffeecode.net/intro_to_sql/introduction_to_sql.txt Even though there are some PostgreSQL-specifics in the introduction, most of the same principles apply. Maybe it will be of use to you or someone else! Dan Wilfred Drew dr...@tc3.edu 3/16/2012 2:31 PM I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
I generally find the w3schools stuff a pretty good starting point to help wrap my head around something I don't know: I've used w3schools a fair bit in the past too, as they rank pretty highly in Google, but have recently been made aware of advice that they aren't necessarily to be relied on, e.g. http://w3fools.com/ David
Re: [CODE4LIB] Learning Microsoft SQL
Hi Bill, For years I have always found the HTML Goodies people to be great for quick and accessible reference, and I think they are good for getting people started in plain English (they are probably very similar to the Dummies books). http://www.htmlgoodies.com/primers/database/article.php/3478051 Best, Arianna Schlegel *Library Web Applications Developer Central Connecticut State University * On Fri, Mar 16, 2012 at 2:31 PM, Wilfred Drew dr...@tc3.edu wrote: I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
I have been working with relational databases for over 2 decades. ;-) That is one reason I went with the book I bought. I just have no experience with Microsoft SQL or any version of SQL. The HTML Goodies stuff looks really good and I will look it over. My first exposure to relational databases was James Wetherbe's book Systems Analysis and Design: Traditional, Structured, and Advanceed Concepts and Techniques- 2nd Editon in a systems analysis course at the library school at Drexel university in 1984. Keep the suggestions coming, please. Bill Drew -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of arianna Sent: Friday, March 16, 2012 2:48 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Learning Microsoft SQL Hi Bill, For years I have always found the HTML Goodies people to be great for quick and accessible reference, and I think they are good for getting people started in plain English (they are probably very similar to the Dummies books). http://www.htmlgoodies.com/primers/database/article.php/3478051 Best, Arianna Schlegel *Library Web Applications Developer Central Connecticut State University * On Fri, Mar 16, 2012 at 2:31 PM, Wilfred Drew dr...@tc3.edu wrote: I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
Qw Sent from my iPhone On Mar 16, 2012, at 2:57 PM, Wilfred Drew dr...@tc3.edu wrote: I have been working with relational databases for over 2 decades. ;-) That is one reason I went with the book I bought. I just have no experience with Microsoft SQL or any version of SQL. The HTML Goodies stuff looks really good and I will look it over. My first exposure to relational databases was James Wetherbe's book Systems Analysis and Design: Traditional, Structured, and Advanceed Concepts and Techniques- 2nd Editon in a systems analysis course at the library school at Drexel university in 1984. Keep the suggestions coming, please. Bill Drew -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of arianna Sent: Friday, March 16, 2012 2:48 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Learning Microsoft SQL Hi Bill, For years I have always found the HTML Goodies people to be great for quick and accessible reference, and I think they are good for getting people started in plain English (they are probably very similar to the Dummies books). http://www.htmlgoodies.com/primers/database/article.php/3478051 Best, Arianna Schlegel *Library Web Applications Developer Central Connecticut State University * On Fri, Mar 16, 2012 at 2:31 PM, Wilfred Drew dr...@tc3.edu wrote: I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]
Re: [CODE4LIB] Learning Microsoft SQL
I generally find the w3schools stuff a pretty good starting point to help wrap my head around something I don't know: http://www.w3schools.com/sql/default.asp -Ross. On Mar 16, 2012, at 2:31 PM, Wilfred Drew wrote: I am setting up my laptop to teach myself Microsoft SQL. I am installing SQL Express. I purchased Microsoft SQL Server 2008 All-in-one desk reference for Dummies. Any suggestions on other tools to add to my laptop to learn SQL? Preferably free. Bill Drew Web: BillTheLibrarian.com Voice/SMS/: 607-745-4461 Email: bill.d...@gmail.com G+: gplus.to/BillDrew Twitter/Skype: BillDrew4 Web Design, Social Media, New Tech, Assessment, Change Management, Innovation, Mobile Tech, and more. [cid:image001.png@01CD0381.754C6DA0]