Solved

Does SQL change much?

Posted on 2016-09-09
4
42 Views
Last Modified: 2016-09-09
I've decided I'm only going to law school if I get a full ride, I can't really justify spending a lot of money on a JD with the legal market the way it is.

So I want to get SQL down well and I checked out SQL Visual Quickstart Guide, 3rd Edition from the library.

The copyright is in 2008, I'm assuming SQL doesn't change as much as PHP. So this book should be good right?
0
Comment
Question by:burnedfaceless
4 Comments
 
LVL 42

Accepted Solution

by:
zephyr_hex (Megan) earned 250 total points
ID: 41791781
The basics of SQL don't change.  However, there are features that are added in newer versions that at some point would be good to know.  But for a first book to get started, it looks like it contains the fundamentals (I read the reviews on Amazon).
0
 
LVL 34

Assisted Solution

by:gr8gonzo
gr8gonzo earned 125 total points
ID: 41791815
SQL is a generic language that changes based on the type of database that you use.

In that sense, it's very much like how English is a language but it is spoken differently in different countries. For example, the question, "What color is the sky?" is simple enough that it will likely be asked the same way whether you are in the United States or Canada or England or Ireland, etc...

However, asking "Where is the bathroom?" means one thing in the United States (you're looking for a restroom with a toilet), while in England it means you're likely looking for a room with a bath or shower.

Again, this is very similar to SQL. The SQL language defines the generally-accepted way of speaking to a database. Then each database takes it a little bit further. In MySQL, if you want to only grab the first 10 records of a query, you might say:

SELECT * FROM table LIMIT 10;

Whereas in Microsoft SQL Server (MSSQL), you would do this:

SELECT TOP 10 * FROM table;

The "SQL" part, meanwhile, simply defines "SELECT <data> FROM <source> WHERE <criteria>".

Generally speaking, even when new versions of databases come out and they introduce new features, they are USUALLY not deprecating old features. That means that most of what you learn from a book in 2008 will still work today.

More often than not, a book will make references to visual tools like SQL Management Studio or Enterprise Manager or PHPMyAdmin, and those tools will change far more than the underlying database will. For example, older versions of MSSQL used Enterprise Manager, but that's since been largely replaced by SQL Management Studio. Of course, those are all just optional "helper" tools. Even if they change the location or appearance of a button, they are still doing the same operations to the database.

New database versions are usually introducing new features that add on to what's already there in the database language, and of course, a book from 2008 won't cover features that were invented/added after it was published. If you're learning SQL from scratch, it'll usually be a while before you get to a point where you need to use any of the newer features because the basics still make up 99% of what you'll need to do.
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 125 total points
ID: 41791865
SQL language is the most stable among all languages. It is practically the same for about 50 years now. It gets some new features but not in regards to the main features and not that often. 2008 edition is safe.
0
 

Author Closing Comment

by:burnedfaceless
ID: 41792131
Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now