InnerWorkings Developer

InnerWorkings helps developers learn T-SQL activities such as making queries, sorting and filtering, and using table joins. It also gets you to practice control-of-flow language and using functions to manipulate data.

T-SQL topics covered include the following:

- 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

The product assumes 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).