SQL All-in-One Desk Reference For Dummies

Allen G. Taylor

  • 出版商: Hungry Minds
  • 出版日期: 2007-07-02
  • 售價: $1,430
  • 貴賓價: 9.5$1,359
  • 語言: 英文
  • 頁數: 720
  • 裝訂: Paperback
  • ISBN: 0470119284
  • ISBN-13: 9780470119280
  • 相關分類: SQL
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

Description

SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.

Book I: SQL Concepts

Book II: Relational Database Development

Book III: SQL Queries

Book IV: Data Security

Book V: SQL and Programming

Book VI: SQL and XML

Book VII: Database Tuning Overview

Book VIII: Appendixes

Table of Contents

Introduction.

Book I: SQL Concepts.

Chapter 1: Relational Database Basics.

Chapter 2: Modeling a System.

Chapter 3: SQL Overview.

Chapter 4: SQL and the Relational Model.

Chapter 5: The Major Components of SQL.

Chapter 6: SQL Characteristics.

Book II: Relational Database Development.

Chapter 1: System Development Overview.

Chapter 2: Building a Database Model.

Chapter 3: Balancing Performance and Correctness.

Chapter 4: Creating a Database with SQL.

Book III: SQL Queries.

Chapter 1: Values, Variables, Functions, and Expressions.

Chapter 2: SELECT Statements and Modifying Clauses.

Chapter 3: Querying Multiple Tables with Subqueries.

Chapter 4: Querying Multiple Tables with Relational Operators.

Book IV: Data Security.

Chapter 1: Protecting Against Hardware Failure and External Threats.

Chapter 2: Protecting Against User Errors and Conflicts.

Chapter 3: Assigning Access Privileges.

Chapter 4: Error Handling.

Book V: SQL and Programming.

Chapter 1: Database Development Environments.

Chapter 2: Interfacing SQL to a Procedural Language.

Chapter 3: Using SQL in an Application Program.

Chapter 4: Designing a Sample Application.

Chapter 5: Building a Sample Application.

Chapter 6: SQL’s Procedural Capabilities.

Chapter 7: Connecting to a Remote Database.

Book VI: SQL and XML.

Chapter 1: XML/SQL Basics.

Chapter 2: Storing XML Data in SQL Tables.

Chapter 3: Retrieving Data from XML Documents.

Book VII: Database Tuning Overview.

Chapter 1: Tuning the Database.

Chapter 2: Tuning the Environment.

Chapter 3: Finding and Eliminating Bottlenecks.

Book VIII: Appendixes.

Appendix A: SQL:2003 Reserved Words.

Appendix B: Glossary.

Index.