SmartSellTM - The New Way to Sell Online

Shop over 1.5 Million Toys in our Huge New Range

SQL All-In-One for Dummies, 2nd Edition


Product Description
Product Details

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 Relational Operators. Chapter 5: Cursors. 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 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.

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 .

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling SQL All-In-One for Dummies, 2nd Edition on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top