The T-SQL Training Guide is designed to train users that have either no SQL or database background or those who have some basic experience working with SQL and databases. Not sure if this is for you? With a 30-day money-back guarantee if you aren’t satisfied, what do you have to lose?!
Why should you learn SQL?
1) Because you can earn really good money.
This point shouldn’t be too hard to sell; most people would love to be able to make a little more hard-earned cash. If you learn SQL, this is a great way to do boost your income. The average SQL Developer salary, according to Indeed.com, was $92,000! SQL DBAs (Database Administrators – the people who make sure the databases are running properly and performing as best they can) have an average salary of $97,000! Considering that the United States median household income is around $52,000, an income nearly twice that of the median household income signifies a pretty good living.
2) Because SQL is one of the most sought-after skills by hiring employers.
Employers are seeking out those individuals who know SQL. It’s one thing to be able to earn a high salary (see point #1), but employers know the value that someone skilled in SQL brings to their company and want to employ these individuals. If you are looking to change employers, learning SQL makes you a highly sought after prospect.
3) Because you can get an answer to any question you ask.
Think of all the questions you ask about your data on a regular basis. What were our sales last year? What is our average customer satisfaction rating? At what rate have we reduced expenses since last summer? These are all questions that can be answered if you learn SQL. Once you identify the database that stores the data you seek to explore, SQL empowers you to answer your own questions. You no longer need to rely on overly simplified, pre-built reports or emailing co-workers to track down data. SQL enables you to become a more self-sufficient employee.
4) Because you no longer have to deal with Excel crashing.
Ever crashed Excel because you had a ton of rows in a spreadsheet? Relational databases are designed to store millions and millions of rows of data (even billions of rows). SQL allows you perform operations on this vast amount of data without having to worry about crashing a program not designed for that amount of information. Microsoft Excel is a great tool; it just isn’t meant to perform operations on tens of millions of rows at once. Relational databases are designed for those larger operations, and SQL is the language that allows you complete them.
5) Because you won’t ever have to ask yourself, “How did I make that report again?”.
SQL queries can be easily saved and re-used at any point in time. SQL code can also be edited with comments, so you can include clear descriptions directly in your query. When you work with Excel, you might be stuck doing a long multi-step process. First, you might have to export data from some standard report, then sort it, then add headers, then filter out certain values, and on, and on, and on, and on…
With SQL code, you simply write the code once, save it, re-open it, and re-run it if you ever need to produce a report twice. Think of the hours – even DAYS – that you could get back each month by not having to manually produce reports that could easily be automated.
There are three main parts to the training guide. Part one consists of sections one through eleven. This part is geared towards those with no or limited prior SQL background. Certainly, those with some prior background would benefit from the lessons and practice problems contained in the first part of the guide, however the main emphasis is on the foundation of T-SQL querying.
Part two contains sections twelve through seventeen. This can be classified as the “Intermediate SQL Training” section. It contains lessons and practice problems associated with intermediate concepts such as: common table expressions, derived tables, subqueries and more advanced aggregations and pivoting.
The final part of the guide, part three, is the “Advanced SQL Programming and Control Flow” area of the guide. This guide intentionally only briefly explores some the advanced T-SQL concepts like variables and control flow. Sections eighteen and nineteen comprise the advanced component of this guide.
Each section will contain a learning subsection and a set of lab questions based on the AdventureWorks2012 database (Microsoft’s default training database). This will give you the opportunity to practice in a test environment without the stress of impacting production servers before working in a live setting.
Enjoy and good luck learning the foundation of Microsoft SQL Server, the T-SQL language!