SQL: A Beginner's Guide

0.0

Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow resource teaches database professionals and programmers how to use SQL. Learn how to retrieve, insert,update, and delete database data, and perform management and administrative functions. The book covers new features, including SQL/XML, and contains updated screen shots showing the latest RDBMS software versions such as SQL Server 2008 and Oracle Database 11g.

0.0

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. Robert Sheldon is a consultant and technical writer. 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 DataChapter 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