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.
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!