SQL 傻瓜书 SQL For Dummies

作　者：	Allen Taylor
出版社：	John Wiley & Sons
丛编项：
版权说明：	本书为公共版权或经版权方授权，请支持正版图书
标　签：	暂缺

ISBN	出版时间	包装	开本	页数	字数
未知	暂无	暂无	未知	0	暂无

作者简介

　　Allen G. Taylor is a 30-year veteran of the computer industry and the author of 24 books， including Crystal Reports 10 For Dummies， Database Development For Dummies， Access Power Programming with VBA， and SQL Weekend Crash Course. He lectures internationa

内容简介

See how SQL interfaces with today's environmentsStart building and using relational databases with SQL's newest featuresThe database may be the twenty-first century filing cabinet， but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL， you'll soon be whipping up relational databases， using SQL with XML to power data-driven Web sites， and more！Discover how to* Use SQL in a client/server system* Build a multitable relational database* Construct nested and recursive queries* Set up database security* Use SQL within applications* Map SQL to XML

图书目录

Introduction

Part I: Basic Concepts

　Chapter 1: Relational Database Fundamentals

　Chapter 2: SQL Fundamentals

　Chapter 3: The Components of SQL

Part II: Using SQL to Build Databases

　Chapter 4: Building and Maintaining a Simple Database Structure

　Chapter 5: Building a Multitable Relational Database

Part III: Storing and Retrieving Data

　Chapter 6: Manipulating Database Data

　Chapter 7: Specifying Values

　Chapter 8: Using Advanced SQL Value Expressions

　Chapter 9: Zeroing In on the Data You Want

　Chapter 10: Using Relational Operators

　Chapter 11: Delving Deep with Nested Queries

　Chapter 12: Recursive Queries

Part IV: Controlling Operations

　Chapter 13: Providing Database Security

　Chapter 14: Protecting Data

　Chapter 15: Using SQL within Applications

Part V: Taking SQL to the Real World

　Chapter 16: Accessing Data with ODBC and JDBC

　Chapter 17: Operating on XML Data with SQL

Part VI: Advanced Topics

　Chapter 18: Stepping through a Dataset with Cursors

　Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules

　Chapter 20: Handling Errors

Part VII: The Part of Tens

　Chapter 21: Ten Common Mistakes

　Chapter 22: Ten Retrieval Tips

Part VIII: Appendixes

Appendix A: SQL:2003 Reserved Words

Appendix B: Glossary

Index