If you’ve been following InnerWorkings and our monthly content releases, you’ll know that this SQL Drill has been waiting in the wings for quite some time. I’ve seen it hovering around the latter part of our roadmap for many months like a nervous teenager about to MEET THE PARENTS for the first time. So SQL has finally brushed its hair, studied current affairs, and arrived at the door with an orchid corsage.

I know a good number of developers and customers will be happy to see this fresh-faced new arrival in the InnerWorkings catalog. Now why did we start with Transact-SQL in the first place? Well, let me quote MSDN for a moment: “Transact-SQL is central to the use of Microsoft SQL Server. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application’s user interface.” So there! Don’t argue with the MSDN robot.

Our first Drill on Transact-SQL caters to C# developers (VB to follow soon) and it covers fundamental T-SQL activities such as making queries, sorting and filtering, and using table joins. It also delves into control-of-flow language and using functions to manipulate data. Does that not satisfy your curiosity? Let me tell you more about what InnerWorkings has packed into this 3 hour learning feast:

• Using the basic T-SQL statements SELECT, UPDATE, INSERT, and DELETE
• Sorting and filtering data using T-SQL
• Combining records from two tables
• Using different types of joins
• Changing the name of a result set column
• Performing a calculation on a set of values
• Returning a single value using an aggregate function
• Controlling the execution flow of T-SQL statements
• Using built-in string and system scalar functions

We assume that you’re already familiar with basic programming concepts, language syntax, and have a working knowledge of SQL and SQL Server (or general database fundamentals, at least). If that’s the case, what are you waiting for - visit our catalog to get started. First person to sign-up gets an orchid for taking our T-SQL Drill out on a date.

In the old tradition of walking before you run, the next item on the developer wish list is Advanced Transact-SQL. Stay tuned for further updates on that release soon.

Add this post to: