The Practical SQL Handbook: Using SQL Variants, 4/e (Paperback)

Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky

  • 出版商: Addison Wesley
  • 出版日期: 2001-07-06
  • 售價: $2,217
  • 貴賓價: 9.5$2,106
  • 語言: 英文
  • 頁數: 512
  • 裝訂: Paperback
  • ISBN: 0201703092
  • ISBN-13: 9780201703092
  • 相關分類: SQL






This best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical applications. The Practical SQL Handbook, Fourth Edition includes expanded platform SQL coverage and extensive real world examples based on feedback from actual SQL users. Beginning with a step-by-step introduction to SQL basics, The Practical SQL Handbook then examines the issues involved in designing SQL-based database applications. Since this updated edition examines SQL's most popular implementations from industry leaders, students will learn how Oracle, Microsoft, Sybase, and Informix have implemented SQL.

Back to Top

Table Of Contents

1.SQL and Relational Database Management.
2. Designing Datases.
3. Creating and Filling a Database.
4. Selecting Data from the Database.
5. Sorting Data and Other Selection Techniques.
6. Grouping Data and Reporting from it.
7. Joining Tables for Comprehensive Data Analysis.
8. Structuring Queries with Subqueries.
9. Creating and Using Views.
10. Security, Transactions, Performance, and Integrity.
11. Solving Business Problems.
Appendix A: Syntax Summary for the SQL Used in This Book.
Appendix B: Industry SQL Equivalents.
Appendix C: Glossary.
Appendix D: The 'bookbiz' Sample Database.

Back to Top