Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 22. Advanced SQL Topics
The advanced SQL topics discussed this hour are those that extend beyond the basic operations that you have learned so far, such as querying data from the database, building database structures, and manipulating data within the database. These advanced topics are features available in many implementations , all of which provide enhancements to the parts of SQL discussed so far.
Not all topics are ANSI SQL, so you must check your particular implementation for variations in syntax and rules. A few major vendors ' syntax is shown here for comparison. Additionally, many of the topics covered in this hour are not supported by MySQL.