Advanced 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.
Note
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.
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
