In this module you’ll get an overview of the SQL Server types of statements, other statement elements, and the basic SELECT statements.

This module describes DISTINCT, aliases, scalar functions and CASE, using JOIN and MERGE; filtering and sorting data, and NULL values.

This module introduces data types, data type usage, converting data types, and understanding SQL Server function types.

In this module you’ll learn about aggregate functions, GROUP BY and HAVING clauses, and subqueries; self-contained, correlated and EXISTS; views, and inline-table valued functions, and derived tables.

In this module you’ll find out about SET operators, Windows functions, and GROUPING sets (PIVOT, UNPIVOT, CUBE, ROLLUP).

This module covers INSERT, UPDATE, and DELETE statements, and the use of defaults, constraints, and triggers, and OUTPUT.

In this module, you’ll learn about using T-SQL programming elements, implementing error handling, and understanding and implementing transactions.

This module explains querying system catalogs and dynamic management views, creating and executing stored procedures, and improving SQL Server query performance.

Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into Querying Microsoft SQL Server 2012 Databases at your own pace.