Querying with Transact-SQL: (11) Error Handling and Transactions
[MP4] [0:54:10] [2015/03/26]Find out how to create Transact-SQL code that includes error handling. Learn about concept of a transaction and how to implement explicit transactions in Transact-SQL code.
Querying with Transact-SQL: (10) Programming with Transact-SQL
[MP4] [0:28:45] [2015/03/26]Learn to create Transact-SQL scripts that include programmatic constructs, such as conditional logic and loops.
Querying with Transact-SQL: (09) Modifying Data
[MP4] [0:42:01] [2015/03/26]Get the details on modifying data in tables by using the INSERT, UPDATE, and DELETE statements.
Querying with Transact-SQL: (08) Grouping Sets and Pivoting Data
[MP4] [0:26:31] [2015/03/26]Find out how to use the GROUPING SET subclause of the GROUP BY clause to specify multiple groupings in a single query. Then, see how to use the PIVOT and UNPIVOT operators to switch the orientation of…
Querying with Transact-SQL: (07) Using Table Expressions
[MP4] [0:36:48] [2015/03/26]Learn various techniques that can be used to create tabular structures in Transact-SQL, including views, temporary tables, table variables, table-valued functions, and common table expressions (CTEs).
Querying with Transact-SQL: (06) Using Subqueries and APPLY
[MP4] [0:18:00] [2015/03/26]Get the details on including subqueries within a query, and see how to work with correlated subqueries and the APPLY operator to use the results from one query in another.
Querying with Transact-SQL: (05) Using Functions and Aggregating Data
[MP4] [0:48:34] [2015/03/26]Get to know commonly used built-in functions, and find out how to use them. Learn to use aggregate functions to summarize data, and work with the GROUP BY clause to retrieve grouped aggregations.
Querying with Transact-SQL: (04) Using Set Operators
[MP4] [0:22:55] [2015/03/26]Learn how to combine sets of data returned by queries by using the UNION operator.
Querying with Transact-SQL: (03) Querying Multiple Tables with Joins
[MP4] [0:39:06] [2015/03/26]Explore the concept of joins in relational database queries, and then hear how to implement inner, outer, cross, and self joins by using the JOIN clause.
Querying with Transact-SQL: (02) Querying Tables with SELECT
[MP4] [0:43:20] [2015/03/26]Build on the basic SELECT syntax discussed in the previous module to learn how to sort and filter query results with the ORDER BY and WHERE clauses.
Querying with Transact-SQL: (01) Introduction to Transact-SQL
[MP4] [0:57:24] [2015/03/26]Find out how to set up a sample database in Microsoft Azure SQL Database to use in the supplementary labs for this course. Then, learn how to use the SELECT statement in Transact-SQL to create basic…
Querying with Transact-SQL: (00) Course Introduction
[MP4] [0:14:42] [2015/03/26]Learn about the goals of the course and how to set up an Azure SQL Database environment for the labs that you will complete during subsequent modules.