LESSON 19Temporary Tables, Stored Procedures, Triggers, and Cursors

Over the course of the past 18 lessons, you have examined every major topic used to write powerful queries to retrieve data from a database. You have also briefly explored aspects of database design and database security. This lesson’s objective is to cover advanced SQL topics, which include the following:

• Temporary tables

• Cursors

• Stored procedures

• Triggers

• Embedded SQL

Get Sams Teach Yourself SQL in One Hour a Day, Fifth 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.