gigifarrow
asked on
What is a good free website to learn SQL?
At my job I was required to make simple queries in Microsoft Access. Now they are asking me to do more complex queries. where is a good site that is free, and helps you learn how to do more advanced queries?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will LOVE this book ... I promise.
BOOKS! definitely a good place to start - I don't know the book above - and it may be terrific. However just a word of caution, the SQL used by Microsoft Access is different in many ways to ANSI standard SQL.
2 site's I would consider
http://sqlzoo.net/
http://www.w3schools.com/sql/sql_intro.asp
and another 2 that will be of great use at some point once you get going:
http://poorsql.com/
http://sqlfiddle.com/
please look at these previous answers also
https://www.experts-exchange.com/questions/24528121/Best-websites-books-and-resources-for-learning-TSQL-and-MS-SQL-Server.html
https://www.experts-exchange.com/questions/27458575/Do-you-know-of-any-good-websites-to-learn-SQL-for-use-with-MS-Access-2003.html
https://www.experts-exchange.com/questions/20788254/beginner-for-sql.html
2 site's I would consider
http://sqlzoo.net/
http://www.w3schools.com/sql/sql_intro.asp
and another 2 that will be of great use at some point once you get going:
http://poorsql.com/
http://sqlfiddle.com/
please look at these previous answers also
https://www.experts-exchange.com/questions/24528121/Best-websites-books-and-resources-for-learning-TSQL-and-MS-SQL-Server.html
https://www.experts-exchange.com/questions/27458575/Do-you-know-of-any-good-websites-to-learn-SQL-for-use-with-MS-Access-2003.html
https://www.experts-exchange.com/questions/20788254/beginner-for-sql.html
" and it may be terrific. "
It is :-)
"the SQL used by Microsoft Access is different in many ways to ANSI standard SQL."
Yes ... that is clearly pointed out in John's book.
Your sites are certainly good, however ... it does not appear that any deal with 'Access' SQL ... and since this is the Access zone .... those will come in handy if one goes beyond Access SQL.
i highly recommend you also check out John's book ... as all platforms are covered and include examples (in dbs) for each platform.
mx
It is :-)
"the SQL used by Microsoft Access is different in many ways to ANSI standard SQL."
Yes ... that is clearly pointed out in John's book.
Your sites are certainly good, however ... it does not appear that any deal with 'Access' SQL ... and since this is the Access zone .... those will come in handy if one goes beyond Access SQL.
i highly recommend you also check out John's book ... as all platforms are covered and include examples (in dbs) for each platform.
mx
point taken regarding Access zone :)
I'll pass on the book though - think I might not really need it :), but if I was in the market for one I'd happily take your enthusiastic recommendation.
I do fully agree with use of books of course.
Cheers, Paul
I'll pass on the book though - think I might not really need it :), but if I was in the market for one I'd happily take your enthusiastic recommendation.
I do fully agree with use of books of course.
Cheers, Paul
ASKER