Hour 22. Advanced SQL Topics

Team-Fly

---

 

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents
	Part VIII.  Applying SQL Fundamentals in Today's World

---

Hour 22. Advanced SQL Topics

During this hour, you are introduced to some advanced SQL topics. 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.

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 SQL

• Call-level interface

---

Team-Fly

Top