Table Expressions in SQL Server

Home/Development, SQL Server/Table Expressions in SQL Server

Table Expressions in SQL Server

$15.00 $4.00

In Transact-SQL (T-SQL), Table Expressions holds the query expressions as a relational table for data manipulation. This lab is divided into nine exercises explaining different scenarios where table expressions are useful.

Exercise 1: Derived Tables with Inline column aliases
Exercise 2: Derived Tables with Arguments
Exercise 3: Derived Tables with Multiple References
Exercise 4: Common Table Expressions with Inline column aliases
Exercise 5: Common Table Expressions with Arguments
Exercise 6: Common Table Expressions with Multiple References
Exercise 7: Recursive Common Table Expressions
Exercise 8: Self-Assessment
Exercise 9: T-SQL Challenge

Categories: ,

Description

In Transact-SQL (T-SQL), Table Expressions holds the query expressions as a relational table for data manipulation. This lab is divided into nine exercises explaining different scenarios where table expressions are useful.

Exercise 1: Derived Tables with Inline column aliases
Exercise 2: Derived Tables with Arguments
Exercise 3: Derived Tables with Multiple References
Exercise 4: Common Table Expressions with Inline column aliases
Exercise 5: Common Table Expressions with Arguments
Exercise 6: Common Table Expressions with Multiple References
Exercise 7: Recursive Common Table Expressions
Exercise 8: Self-Assessment
Exercise 9: T-SQL Challenge

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.