| 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!
|
|
|
Machinery's Handbook 28th Larger Print Edition (Machinery's Handbook)
Celebrating nearly 100 years as The Bible of the Mechanical Industries , the 28th edition brings together volumes of knowledge, information and data gathered, revised and improved upon from experts throughout the mechanical industries. Extraordinarily comprehensive yet easy to use since it premiered, Machinery s Handbook provides mechanical... | | The Book of Webmin: Or How I Learned to Stop Worrying and Love UNIX
Webmin is a web-based graphical UNIX system administration tool written by Jamie Cameron in the Perl programming language that is designed to be lightweight, functional, and easily extensible. Webmin has been translated to over 20 languages and dialects at the time of this writing, and it has been embraced by a number of... | | JFK and the Unspeakable: Why He Died and Why It MattersBRAND NEW HARDBACKWe can know the essential truth of President John F. Kennedy's assassination. That truth can set us free.
Thanks to the pioneer investigators into President Kennedy's murder, the truth-telling of many witnesses, and a recent flood of documents through the JFK Records Act, the truth is available. Not only can the... |
|