| 
View
 

Topic - Complex Queries

Page history last edited by Dr. Ron Eaglin 11 years, 7 months ago

 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.