| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Complex Queries

Page history last edited by Dr. Ron Eaglin 11 years 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.