SQL 傻瓜书 SQL For Dummies

出版时间：2006-08-14  出版社：For Dummies  作者：Allen G. Taylor  页数：414  
Tag标签：无  

内容概要

See how SQL interfaces with today's environments　　Start building and using relational databases with SQL's newest features　　The 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

作者简介

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

书籍目录

IntroductionPart I: Basic Concepts　Chapter 1: Relational Database Fundamentals　Chapter 2: SQL Fundamentals　Chapter 3: The Components of SQLPart II: Using SQL to Build Databases　Chapter 4: Building and Maintaining a Simple Database Structure　Chapter 5: Building a Multitable Relational DatabasePart 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 QueriesPart IV: Controlling Operations　Chapter 13: Providing Database Security　Chapter 14: Protecting Data　Chapter 15: Using SQL within ApplicationsPart V: Taking SQL to the Real World　Chapter 16: Accessing Data with ODBC and JDBC　Chapter 17: Operating on XML Data with SQLPart VI: Advanced Topics　Chapter 18: Stepping through a Dataset with Cursors　Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules　Chapter 20: Handling ErrorsPart VII: The Part of Tens　Chapter 21: Ten Common Mistakes　Chapter 22: Ten Retrieval TipsPart VIII: AppendixesAppendix A: SQL:2003 Reserved WordsAppendix B: GlossaryIndex