Topic -Complex Queries
Performing Complex Queries in SQL requires a solid knowledge of SQL and the operators that you will want to use to help with these queries. Complex queries make use of the operators in the required and reference reading.
Reading
Required
Data Manipulation Language - http://msdn.microsoft.com/en-us/library/ff848766.aspx - It is good to have a solid handle on all the operators that are available in DML.
Reference
Lectures
Lecture - Complex Queries with Registration System - Also using the registration system, demonstrates formulating a complex query
Topic - Function in Queries - Many complex queries are greatly simplified by adding the ability to embed functions.
Assignments
Comments (0)
You don't have permission to comment on this page.