SQL: A BEGINNER'S GUIDE 3/E

Be the first to write a review

Overview

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...

See more details below
Paperback (Original)
$25.46
BN.com price
(Save 39%)$42.00 List Price
Other sellers (Paperback)
  • All (19) from $3.99   
  • New (11) from $19.96   
  • Used (8) from $3.99   
SQL: A Beginner's Guide, Third Edition: A Beginner's Guide, Third Edition

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$42.00
BN.com price

More About This Book

Overview

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 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
Read More Show Less

Product Details

  • ISBN-13: 9780071548649
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 8/8/2008
  • Series: Beginner's Guide Series
  • Edition description: Original
  • Edition number: 3
  • Pages: 534
  • Sales rank: 323778
  • Product dimensions: 7.30 (w) x 9.00 (h) x 1.20 (d)

Meet 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

Read More Show Less

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
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)