Name: SQL All-in-One Desk Reference For Dummies By Allen G. Taylor
SKU: 9780470119280
Price: 26.99 USD
Availability: InStock

SQL All-in-One Desk Reference For Dummies Summary

SQL All-in-One Desk Reference For Dummies by Allen G. Taylor

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

About Allen G. Taylor

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 25 books, including SQL For Dummies, Crystal Reports 10 For Dummies, Database Development For Dummies, Access 2003 Power Programming with VBA, and SQL Weekend Crash Course. He lectures internationally on databases, networks, innovation, and entrepreneurship. He also teaches database development through a leading online education provider and teaches microprocessor design at Portland State University. For the latest news on Allen's activities, check out www.DatabaseCentral.Info. You can contact Allen at [email protected].

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.

Additional information

Sku

GOR011015466

ISBN 13

9780470119280

ISBN 10

0470119284

Title

SQL All-in-One Desk Reference For Dummies by Allen G. Taylor

Author

Allen G. Taylor

Condition

Used - Like New

Binding type

Paperback

Publisher

John Wiley and Sons Ltd

Year published

20070717

Number of pages

720

Prizes

N/A

Cover note

Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

Note

The book has been read, but looks new. The book cover has no visible wear, and the dust jacket is included if applicable. No missing or damaged pages, no tears, possible very minimal creasing, no underlining or highlighting of text, and no writing in the margins

SQL All-in-One Desk Reference For Dummies Allen G. Taylor

SQL All-in-One Desk Reference For Dummies by Allen G. Taylor

Summary

SQL All-in-One Desk Reference For Dummies Summary

SQL All-in-One Desk Reference For Dummies by Allen G. Taylor

About Allen G. Taylor

Table of Contents

Additional information

Customer Reviews - SQL All-in-One Desk Reference For Dummies