Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

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
 

Related

Категории