Amazon cover image
Image from Amazon.com
Image from Google Jackets

SQL : a beginner's guide / Andy Oppel, Robert Sheldon.

By: Contributor(s): Material type: TextTextPublication details: New York : McGraw-Hill, c2009.Edition: 3rd edDescription: xviii, 534 p. : ill. ; 23 cmISBN:
  • 9780071548649
  • 0071548645
Subject(s): DDC classification:
  • 005.7565   22
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.
Summary: 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 skills Notes--Extra information related to the topic being covered Self-Tests--Chapter-ending quizzes to test your knowledge Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Copy number Status Date due Barcode
Books Books Main library General Stacks 005.7565 / OP.S 2009 (Browse shelf(Opens below)) 1 Available 011608
Browsing Main library shelves, Shelving location: General Stacks Close shelf browser (Hides shelf browser)
005.7565 / AN.H 2007 How to do everything with Microsoft Office Access 2007 / 005.7565 / AN.M 2007 Microsoft Office Access 2007 : 005.7565 / OP.S 2009 SQL : 005.7565 / OP.S 2009 SQL : 005.758 / TH.W 2000 Web data management and electronic commerce / 005.7585 / FE.O 2009 Oracle PL/SQL programming / 005.7585 LE.M / 2009 Mastering SQL server 2008 /

Includes index.

Previous ed.: Robert Sheldon's name appeared first on t.p.

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.

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 skills Notes--Extra information related to the topic being covered Self-Tests--Chapter-ending quizzes to test your knowledge Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

1

There are no comments on this title.

to post a comment.