Steve dives into using CTEs instead of derived tables. What the benefit of CTEs Do CTEs over derived tables benefit performance? And a quick demo explanation Transcription of video: Now let’s take a look at some more complex examples of how to use a CTE instead of a derived table. Now use a CTE instead of a derived table, it’s …

Using CTEs Instead of Derived Tables Read more »

As part of our weekly free SQL Query Training, we have split the 70-461 curriculum into 4 sections to prepare everyone to take the certification test later in the year. Today’s session is to review the first 25% of the sessions, or the section 1 review as we are calling it. The review topics we will be covering today are …

Today’s Training: SQL Queries Section 1 Review Read more »

We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts every Thursday at 9:00am Pacific time. To celebrate the 25% mark, and to strengthen the training we have decided to do a review session on everything that we have covered so far. Null Expressions Identity …

Next Weekly Free SQL Training: A Review Read more »

The free SQL Server Queries weekly training is being presented by Steve Stedman and Aaron Buma. The name of the presentation started out as “OUTPUT Clause and Derived Tables“, however it evolved into “OUTPUT Clause Correlated Subqueries and Subquery Extensions” as we got further into it. Last week we covered some of the basics of Derived Tables or Subqueries, today we will …

Weekly SQL Training – OUTPUT Clause and Derived Tables Read more »

On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training provided by Steve Stedman and Aaron Buma to prepare for the Microsoft 70-461 SQL Queries exam. This week we will cover OUTPUT Clause and Derived Tables.  This is provided free of charge to give back …

Next Free SQL Query Training – OUTPUT Clause and Derived Tables Read more »

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 »

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 »