SmartSellTM - The New Way to Sell Online

Shop over a million Toys in our Huge New Range

SQL: A Beginner's Guide


Essential Skills--Made Easy!

Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.

Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Product Details

Table of Contents

PART I - Relational Databases and SQL Chapter 1. Introduction to Relational Databases and SQL Chapter 2. Working with the SQL Environment Chapter 3. Creating and Altering Tables Chapter 4. Enforcing Data Integrity Chapter 5. Creating SQL Views Chapter 6. Managing Database Security Part II - Data Access and Modification Chapter 7. Querying SQL Data Chapter 8. Modifying SQL Data Chapter 9. Using Predicates Chapter 10. Working with Functions and Value Expressions Chapter 11. Accessing Multiple Tables Chapter 12. Using Subqueries to Access and Modify Data Part III - Advanced Data Access Chapter 13. Creating SQL-Invoked Routines Chapter 14. Creating SQL Triggers Chapter 15. Using SQL Cursors Chapter 16. Managing SQL Transactions Chapter 17. Accessing SQL Data from Your Host Program Chapter 18. Working with XML Data Part IV - Appendices Appendix A: Answers to SelfTest Appendix B: SQL:2006 Keywords Appendix C: SQL Code Used in Try This Exercises Index

About the Author

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified. Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases

Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling SQL: A Beginner's Guide on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by, Inc.
Back to top