[nfbcs] SQL training

[Bryan Schulz]

hi,

especially with that background, check out Aussie Kevin Yank's php/mysql 
site point books.

a.. PHP & MySQL: Novice to Ninja - SitePoint
www.sitepoint.com/store/php-mysql-novice-to-ninja/
? $29.00
a.. PHP & MySQL: Novice to Ninja, 5th Edition is a 500+ page book aimed at 
web ...
you'll come away with everything you need to start on your very own database
driven site! ... Kevin Yank is a world-renowned leader in web development.

a.. Build Your Own Database Driven Web Site Using PHP & MySQL ...
www.sitepoint.com/php-mysql-tutorial/
?Jul 2, 2009 ... If you're keen to learn more about PHP and MySQL, you may 
find this recent ...
Back in 2001, when I wrote the first edition of this book, readers were ... 
up until
that point, had been solvable only by expert programmers with corporate 
budgets
. ... Kevin began developing for the Web in 1995 and is a highly ...

they are frequently revised and the e-book is cheaper and doesn't use much 
"click here for...".
Bryan Schulz


----- Original Message ----- 
From: "Tracy Carcione via nfbcs" <nfbcs at nfbnet.org>
To: <nfbcs at nfbnet.org>
Cc: "Tracy Carcione" <carcione at access.net>
Sent: Wednesday, August 20, 2014 11:49 AM
Subject: Re: [nfbcs] SQL training


> Hi Bryan.
> I have been working with databases for 25 years.  Our current system uses
> VSAM, but the old one used IMS, which was a lot more powerful, mainly
> because I could add indices or even whole databases..  Anyway, I think I
> have a good understanding of that kind of database.  Are relational
> databases so different that a whole class would be useful?  I'm willing to
> take one if that's so, but if I can get the same info talking to a
> colleague for an hour or so...
> 12 hours quicker, ay?  Impressive!
> Tracy
>
>> hello tracy.  If you're interested in taking a class to learn SQL,
>> I suggest looking around for a class on an introduction to databases
>> in general with an emphasis on the particular database you're using at
>> work.  SQL syntax isn't that hard to learn from books and the like, but
>> gaining a broader understanding of database designs, structures and use
>> cases is.  Most database engines in common use today use SQL to 
>> manipulate
>> their controls and import and export data.  I would imagine, then, that
>> you
>> might find a class at a local community college entitled something like:
>> "A
>> practical introduction to databases using MYSQL" or something like
>> that.   Such a class would be exactly what you need to get started down
>> the path of becoming a database and SQL techie.  I can tell you from
>> experience that having a good understanding of how relational databases,
>> and this is what all of them are these days, is invaluable when it comes
>> to
>> learning and using SQL syntax effectively.  Early in my career a 
>> colleague
>> gave me a 10 minute lecture about how to construct queries against
>> relational databases.  I was able to take the knowledge gleaned from that
>> discussion and rewrite a report generator we used in a production
>> environment in such a way that its execution time was  reduced by 12
>> hours.
>> That's powerful medicine and it gave me a new respect for database
>> experts.
>> By the way, it's worth mentioning that it would probably be best if
>> you can get a class that uses the same database engine you use at work 
>> for
>> its practical exercises, but if you can't find one that's convenient or
>> workable, taking a class that teaches the general concepts but uses a
>> different software package will still provide you a valuable benefit. 
>> The
>> concepts will be directly transferable to the software you use at work.
>>
>> Good luck and let us know what you find.
>>
>> -Brian
>> On Aug 20, 11:09am, Tracy Carcione via nfbcs wrote:
>> } Subject: [nfbcs] SQL training
>> } I need to learn SQL.  I've got some time to do it.  I've been studying
>> } books and making some progress, but the boss has just offered to pay 
>> for
>> a
>> } course, if I find one that's worthwhile.
>> } Has anyone found a SQL course that was useful?  Or have people just
>> } learned from books and co-workers?
>> } Tracy
>> }
>> }
>> }
>> } _______________________________________________
>> } nfbcs mailing list
>> } nfbcs at nfbnet.org
>> } http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
>> } To unsubscribe, change your list options or get your account info for
>> nfbcs:
>> } http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/buhrow%40nfbcal.org
>>>-- End of excerpt from Tracy Carcione via nfbcs
>>
>>
>>
>> _______________________________________________
>> nfbcs mailing list
>> nfbcs at nfbnet.org
>> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
>> To unsubscribe, change your list options or get your account info for
>> nfbcs:
>> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/carcione%40access.net
>>
>
>
>
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/b.schulz%40sbcglobal.net