Solved

Does SQL change much?

Posted on 2016-09-09
4
50 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 43

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 35

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 27

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

732 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