×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

SQL: A BEGINNER'S GUIDE 3/E / Edition 3
     

SQL: A BEGINNER'S GUIDE 3/E / Edition 3

by Robert Sheldon, Andy Oppel
 

See All Formats & Editions

ISBN-10: 0071548645

ISBN-13: 9780071548649

Pub. Date: 08/08/2008

Publisher: McGraw-Hill Professional Publishing

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

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

Product Details

ISBN-13:
9780071548649
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/08/2008
Series:
Beginner's Guide Series
Edition description:
Original
Pages:
534
Sales rank:
1,392,157
Product dimensions:
7.30(w) x 9.00(h) x 1.20(d)

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

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews