Chapter 22. Advanced SQL Topics
During this hour, you are introduced to some advanced SQL topics 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. By the end of the hour, you should understand the concepts behind cursors, stored procedures, triggers, dynamic SQL, direct versus embedded SQL, and SQL generated from SQL. These advanced topics are features available in many implementations, all of which provide enhancements to the parts of SQL discussed so far.
The highlights of this hour include:
What cursors are
Using stored procedures
What triggers are
Basics of dynamic SQL
Using SQL to generate SQL
Direct SQL versus embedded ...
Get Sams Teach Yourself SQL 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.
