Background: a company came to us with a request: they had a lot of smart people who wanted to learn the basics of T-SQL in a day. Could we build an intro-to-T-SQL course that didn’t suck? Well, sure – as long as we could give it away free on the site. So here it is:
You work for a company that’s got a lot of data in Microsoft SQL Server, and you want to work with it – but you’re not sure how to start. You’re also afraid that your queries might be “bad,” and you don’t want to cause problems on someone else’s server – even when you need to work with a lot of data.
In this one-day self-paced course, we’re going to cover:
- How to write a SELECT query to get data out of one table
- How to filter the data to find just what we want
- How to sort data
- How to join multiple tables together
- How to tell if our query will be slow before we run it
- What books, videos, and web sites to use for learning more
To explain it all, we’re going to use the StackOverflow.com site, database, and their open-source Data Explorer (it’s like a web-based SSMS). You’ll learn the basics of the StackOverflow database, look at a page on StackOverflow.com, and then write a query to deliver similar data.
Head on over and get started, and let us know what you think.