Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, "Understanding the Definition of a Database," and by the last Tip, "Displaying Image Data Stored Within a SQL Table," you will have covered all aspects of SQL.

Covers all aspects of SQL!

*Increasing Security and Simplifying Multiple Table Queries with Views
*Maintaining Data Integrity with Primary and Foreign Key Constraints
*Automating Tasks with Stored Procedures and Triggers
*Treating Multiple Update, Delete, and Insert Statements as a Single Transaction
*Using a Trigger to Send an Email Message
*Implementing Database Security by Controlling Access Rights to Database Objects
*Creating Indexes to Speedup Database Query Execution
*Writing a Visual Basic Application to Work with Database Data
Building Dynamic Web Pages
*Using Queries to Generate Recordsets and Updateable Cursors
*Using Nested Queries to Work with Multiple Tables
*Implementing a Backup Strategy and Using Transaction Logs to Restore a Database
*Changing Values in Multiple Rows at Once
*Executing Dynamic SQL Statements
*Combining the Results of Multiple Queries, and Much, Much More!
Download