By Posted on Posted in Classes No Comments Tagged with , , ,

Here is the agenda for this weeks free SQL training covering  Set Operators, Derived Tables and CTEs – Presentation to prepare for the 70-461 exam: —Set Operators —Derived Tables —Common Table Expressions This session is presented by Aaron Buma and myself. Here is a quick overview of the slides: Set operators – derived tables and CTEs from Steve Stedman This is …

Set Operators, Derived Tables and CTEs – Presentation downloads Read more »

By Posted on Posted in Analytic TSQL, SQL Sunday No Comments Tagged with , , , , , , ,

SQL Server – TSQL Analytics Word Search   Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED   Download the Printable PDF of the Word Search. See Also TSQL Queries – Using NTILE TOP, Ranking, NTILE, and Aggregate Functions TSQL Analytics FREE …

SQL Sunday Word Scramble Read more »

By Posted on Posted in 70-461 Training No Comments Tagged with , ,

NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare for the Microsoft 70-461 queries exam. Here is a video presentation on using the TSQL NTILE function. And here is the sample code associated with the presentation. Feel free to copy and paste to SSMS …

TSQL Queries – Using NTILE Read more »

By Posted on Posted in 70-461 Training, Classes, CTE, SQL Server 2 Comments Tagged with , , ,

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 …

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

By Posted on Posted in Analytic TSQL, Classes No Comments Tagged with , , ,

  Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query training.     Here is the video of the training on TOP, Ranking, NTILE, and Aggregate Functions today. The first half was presented by Aaron Buma, and the second half I presented. The following topics …

TOP, Ranking, NTILE, and Aggregate Functions Read more »

By Posted on Posted in Analytic TSQL, Classes, Query Certification No Comments Tagged with , , , ,

As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on myYouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will …

Downloads for this weeks SQL Training Read more »

By Posted on Posted in Classes, Query Certification No Comments Tagged with , , , , ,

This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on my YouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will start off …

This Weeks SQL Server Queries Training Read more »