书籍详情
SQL 傻瓜书 SQL For Dummies
作者：Allen G. Taylor 著
出版社：John Wiley & Sons
出版时间：2006-12-01
ISBN：9780470046524
定价：¥226.00
购买这本书可以去
内容简介
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
作者简介
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
目录
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
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
猜您喜欢
