SQL

Is SQL difficult to learn? I have been playing with VB.net for months now. Just  curiosity . Want to hear all experts think... any advices is greatly appreciated
VBdotnet2005Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
sql is not difficult to learn if you get the concept of the data types (which is the same as for the other programming languages) and more important, to understand the with sql, you work with sets of data mainly, and not with single values.
bruintjeCommented:
Hello VBdotnet2005,

there are tutorials all over just google sql :-)

besids that, you can make things as difficult as you want, but overall sql is relatively simple in comparison to programming applications. you just need to be specific about what information you want out of a database and then translate that question to sql

you start of with a simple question like

how many people are there with their first name being peter which translates to select count(*) from table1 where firstname = 'peter'

later you can add other tables with info connected by a personsid etc, which leads to more complex queries

so to learn sql is to learn a bit of database design because that will simplify your quest for the correct query a lot

hope this helps a bit
bruintje
VBdotnet2005Author Commented:
any good books and links for beginner?
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

bruintjeCommented:
one online tutorial that gives you hands on samples to do something
http://sqlzoo.net/
dalsymDirector of ITCommented:
I started here when I needed to learn SQL:

http://www.w3schools.com

InteractiveMindCommented:
Yup, I can recommend w3schools also.

As it goes: during it's development, SQL's developer wanted to make it as easy as possible.

And as soon as you understand the general concept behind it, you will certainly agree that he achieved this.
jhanceCommented:
I can recommend an excellent book:


Special Edition Using SQL by Rafe Colburn
jhanceCommented:
Btw, you asked if SQL is difficult.  I say yes and no.  Firstly remember that it's NOT a procedural language like VB where you program by giving a "procedure" to perform a function.  

SQL is a "declarative" language where you essentially use the language to tell the database server what to do and it sends back some result.  This is often (for me at least) the most difficult part of SQL since I'm used to thinking procedurably.

It's also pretty easy to do a lot of stuff in SQL, simply SELECTs, UPDATEs, INSERTs, and DELETEs will get you a long way especially when you combine them with procedural code in your VB application.  You can gain a lot of efficiency and performance by using the power of SQL and the database engine to get you exactly what you want before the data gets to your VB code.  In general the more you do in SQL the less there is to do in VB.  Most database engines are much better and processing data in the database that VB code.

I certainly don't consider myself a SQL guru and I often like to read the Experts Exchange "Databases" topic.  There are lots of interesting things to do in SQL and I often learn something I had no idea was possible.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SilentBob42Commented:
Also, what you need to keep in mind is where you want to do what. I mean lots of people like SQL so much they code complete applications with stored procedures. Others dislike SQL and try to do everything in vb or whatever language. I try to stay somewhere in the middle :)

If you're done with the basic SQL-stuff and still hungy, try this one:
http://www.amazon.com/gp/product/0201700468/104-0741548-5443169?v=glance&n=283155

its packed with exactly those things jhance and lots of others (including me) never thought was possible.
SilentBob42Commented:
whoops! I bet that would be great book aswell, but I actually meant this one:
http://www.amazon.com/gp/product/0201615762/104-0741548-5443169?v=glance&n=283155
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.