?
Solved

Does SQL change much?

Posted on 2016-09-09
4
Medium Priority
?
52 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 1000 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 35

Assisted Solution

by:gr8gonzo
gr8gonzo earned 500 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 27

Assisted Solution

by:Zberteoc
Zberteoc earned 500 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

777 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