Today’s Training: SQL Queries Section 1 Review

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 the following:

• NULL
• Expressions
• Identity
• Aggregation
• Top, Ranking and Aggregation
• OUTPUT Clause
• Derived Tables
• MERGE Statement
• Set Operators
• Derived Tables
• Common Table Expressions
• Recursive Queries

Here is the download file for this week with all the TSQL query examples included.

Section 1 Review.zip

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!