A Guide to SQL （9TH）

Pratt, Philip J./ Last, Mary Z.

Course Technology Ptr（2014/12発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 299 p.
• 言語 ENG
• 商品コード 9781111527273
• DDC分類 658

Full Description

A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle (R) and Microsoft (R) Access (R), and SQL Server throughout the text.

Contents

1. Introduction.2. Database Design Fundamentals.3. Creating Tables.4. Single-Table Queries.5. Multiple-Table Queries.6. Updating Data.7. Database Administration.8. SQL Functions and Procedures.Appendix A: A SQL Reference.Appendix B: How Do I Reference.Appendix C: Answers to Oddly Numbered Questions.