SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs

The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam.

Next week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live session will be with Google On Air Broadcasts Thursday Feb 12th at 9:00am (pacific). This is a FREE SQL Training available to anyone who would like to attend.

This one will be even more fun for me, as I will be presenting on CTEs. CTE stands for Common Table Expression which is a way to have a temporary result set similar to a subquery or derived table in SQL Server.  I have spent a great deal of time studying CTEs over the last several years, and in 2013 I published a book on Common Table Expressions.

The CTE part of the presentation will include the following:

• Introduction to Memory Tables and CTEs
• Simple CTE
• CTE Instead of a Derived Table
• Multiple CTE in a Query
• Data Paging
• CTEs in Stored Procedures, Functions and Views
• Introduction To Recursive CTEs

CTE Related Posts:

• Writing Your First Common Table Expression with SQL Server
• Video: Writing Your First CTE with SQL Server
• Common Table Expressions – Terminating the Previous Statement
• CTE Scope
• Introduction to Recursive CTEs
• Recursive CTE for Dates In A Year
• Expanding on Recursive Dates CTE
• Multiple CTEs in a Query
• Nested CTEs
• Nested CTE’s Gone Wild – The Video
• CTE Data Paging
• CTE Data Paging in a Procedure
• Using a CTE in a Function to Split Up a Query String

• Using a CTE to Split a String Into Rows
• Can we use CTEs use in SSRS?
• CTE Hierarchy compared to the alternative
• Calculating Factorials with a Recursive CTE
• CTE – With An Insert Statement
• Fibonacci Sequence
• Generating a Tree Path with a CTE
• CTE Query Performance
• Multiple CTE’s in a single Query
• Recursive CTE’s

Common Table Expressions Book

If you enjoyed this posting, and want to learn more about common table expressions, please take a look at my book on CTE’s at Amazon.com. The book is titled Common Table Expressions – Joes 2 Pros® – A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!