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!
Look forward to it
Hi Steve
Looking forward to this! I was wondering if you’d also be recording the session?
Thanks
Martyn