SQL All-in-One For Dummies

SQL All-in-One For Dummies

by Allen G. Taylor

Paperback

$35.99 $39.99 Save 10% Current price is $35.99, Original price is $39.99. You Save 10%.
View All Available Formats & Editions
Want it by Thursday, November 15 Order now and choose Expedited Shipping during checkout.

Product Details

ISBN-13: 9780470929964
Publisher: Wiley
Publication date: 03/29/2011
Series: For Dummies Series
Pages: 752
Sales rank: 487,667
Product dimensions: 7.40(w) x 9.20(h) x 1.70(d)

About the Author

Allen G. Taylor lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. Among his more than 20 books are all editions of SQL For Dummies and Database Development For Dummies.

Table of Contents

Introduction.

Book I: SQL Concepts.

Chapter 1: Understanding Relational Databases.

Chapter 2: Modeling a System.

Chapter 3: Getting to Know SQL.

Chapter 4: SQL and the Relational Model.

Chapter 5: Knowing the Major Components of SQL.

Chapter 6: Drilling Down to the SQL Nitty-Gritty.

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 RelationalOperators.

Chapter 5: Cursors.

Book IV: Data Security.

Chapter 1: Protecting Against Hardware Failure and ExternalThreats.

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 an Application.

Chapter 6: Understanding SQL's Procedural Capabilities.

Chapter 7: Connecting SQL to a Remote Database.

Book VI: SQL and XML.

Chapter 1: Using XML with SQL.

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: Appendices.

Appendix A: SQL:2008 Reserved Words.

Appendix B: Glossary.

Index.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews