SQL: A Beginner's Guide, Third Edition: A Beginner's Guide, Third Edition [NOOK 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, ...

See more details below
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

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: 9780071548656
  • Publisher: McGraw-Hill Education
  • Publication date: 8/10/2008
  • Series: Beginner's Guide
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 3
  • Pages: 575
  • Sales rank: 766,207
  • File size: 5 MB

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


Andrew J. (Andy) Oppel is a proud graduate of The Boys’ Latin School of Maryland and of Transylvania University (Lexington, KY) where he earned a BA in computer science in 1974. Since then he has been continuously employed in a wide variety of information technology positions, including programmer, programmer/analyst, systems architect, project manager, senior database administrator, database group manager, consultant, database designer, and data architect. In addition, he has been a part-time instructor with the University of California (Berkeley) Extension for over 20 years, and received the Honored Instructor Award for the year 2000. His teaching work included developing three courses for UC Extension, “Concepts of Database Management Systems”, “Introduction to Relational Database Management Systems”, and "Data Modeling and Database Design." He also earned his Oracle 9i Database Associate certification in 2003. He is currently employed as a senior data modeler for Blue Shield of California. Aside from computer systems, Andy enjoys music (guitar and vocals), amateur radio (Pacific Division Vice Director, American Radio Relay League) and soccer (Referee Instructor, U.S. Soccer).

Andy has designed and implemented hundreds of databases for a wide range of applications, including medical research, banking, insurance, apparel manufacturing, telecommunications, wireless communications, and human resources. He is the author of Databases Demystified (McGraw-Hill/Osborne, 2004) and SQL Demystified (McGraw-Hill/Osborne, 2005). His database product experience includes IMS, DB2, Sybase, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, 9i, and 10g).
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
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)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

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