Advanced CTEs Slides and Sample Queries

My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions.

Here is the outline for the session.

1. Hierarchical Recursive CTEs
2. Manipulating Data
3. Common Use Cases
4. CTE Performance Considerations

Download the presentation and samples here:  Advanced CTEs.zip

See Also:

Introduction to CTEs presentation

Introduction to CTEs Slides and Sample Queries

Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session:

Introduction

Here is the abstract:

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions session.

This session will include the following topics:

  • 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

At 10:45 I will be giving the Advanced Common Table Expressions Session.

Download the presentation here:  Introduction to CTEs.zip

Related Posts:

Advanced CTEs Slides and Samples

Today I presented on Advanced CTEs at SQL Saturday Denver.
sqlsat190_speaking

Here are my slides and sample code for download: Advanced CTEs Denver

Thanks to everyone who attended, I hope you enjoyed the presentation.

Don’t forget to try out the Database Health Reports.  Here is what some people are saying about it:  Raving Fans

In Denver for SQL Saturday

I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions.  This presentation should be a lot of fun.  I will be covering all the advanced and fun CTE features that I haven’t had time to fit into my introduction to CTE session in the past.

sqlsat190_speaking

Here is the outline of the session:

1.Recursive CTEs.
2.Hierarchical CTEs.
3.Manipulating Data.
4.Common Use Cases.
5.CTE Performance Considerations.
I will also be giving away a couple signed copies of my book on Common Table Expressions book.
Paperback Kindle
See you there!

What is a Common Table Expression – Video

 

Related Common Table Expression Links

You can also find more CTE examples on the TSQL Wiki.

If you enjoyed these Common Table Expression 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.

End of June Summary

June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being CTE Month at SteveStedman.com to mark the release of my Common Table Expressions book.

CTE Month Summary

CTE Month postings started with the basics on June 1st, and grew throughout the month to include more advanced CTE content.

Since June is CTE month, here are some links to other CTE articles on my blog:

You can also find more CTE examples on the TSQL Wiki.

If you enjoyed these Common Table Expression 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.

Other Posts for June