Sessions

Querying with Transact-SQL: (00) Course Introduction

Querying with Transact-SQL: (00) Course Introduction

2 years ago
Want create site? Find Free WordPress Themes and plugins.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. Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (01) Introduction to Transact-SQL

Querying with Transact-SQL: (01) Introduction to Transact-SQL

2 years ago
Want create site? Find Free WordPress Themes and plugins.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 queries that return data from tables in a database. Did you find […]
Querying with Transact-SQL: (02) Querying Tables with SELECT

Querying with Transact-SQL: (02) Querying Tables with SELECT

2 years ago
Want create site? Find Free WordPress Themes and plugins.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.​ ​ Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (03) Querying Multiple Tables with Joins

Querying with Transact-SQL: (03) Querying Multiple Tables with Joins

2 years ago
Want create site? Find Free WordPress Themes and plugins.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. Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (04) Using Set Operators

Querying with Transact-SQL: (04) Using Set Operators

2 years ago
Want create site? Find Free WordPress Themes and plugins.Learn how to combine sets of data returned by queries by using the UNION operator.​ Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (05) Using Functions and Aggregating Data

Querying with Transact-SQL: (05) Using Functions and Aggregating Data

2 years ago
Want create site? Find Free WordPress Themes and plugins.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.​ Did you find apk for android? You can find new Free Android Games and […]
Querying with Transact-SQL: (06) Using Subqueries and APPLY

Querying with Transact-SQL: (06) Using Subqueries and APPLY

2 years ago
Want create site? Find Free WordPress Themes and plugins.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.​ Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (07) Using Table Expressions

Querying with Transact-SQL: (07) Using Table Expressions

2 years ago
Want create site? Find Free WordPress Themes and plugins.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). Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (08) Grouping Sets and Pivoting Data

Querying with Transact-SQL: (08) Grouping Sets and Pivoting Data

2 years ago
Want create site? Find Free WordPress Themes and plugins.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 data between column-oriented and row-oriented. Did you find apk for […]
Querying with Transact-SQL: (09) Modifying Data

Querying with Transact-SQL: (09) Modifying Data

2 years ago
Want create site? Find Free WordPress Themes and plugins.Get the details on modifying data in tables by using the INSERT, UPDATE, and DELETE statements. Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (10) ​Programming with Transact-SQL

Querying with Transact-SQL: (10) ​Programming with Transact-SQL

2 years ago
Want create site? Find Free WordPress Themes and plugins.Learn to create Transact-SQL scripts that include programmatic constructs, such as conditional logic and loops. Did you find apk for android? You can find new Free Android Games and apps.
Querying with Transact-SQL: (11) Error Handling and Transactions

Querying with Transact-SQL: (11) Error Handling and Transactions

2 years ago
Want create site? Find Free WordPress Themes and plugins.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. Did you find apk for android? You can find new Free Android Games and apps.