Cover image for SQL For Dummies, 8th Edition

SQL For Dummies, 8th Edition

Author Allen G. Taylor
Release Date: 2013/09/01
ISBN: 9781118657119
Topic:
0%
39
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

Uncover the secrets of SQL and start building better relational databases today!

This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it.

  • Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption

  • Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL

  • Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work

Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

Table of Contents

  1. Cover
  2. Title Page
  3. Table of Contents
  4. Introduction
  5. Part I: Getting Started with SQL
    1. Chapter 1: Relational Database Fundamentals
    2. Chapter 2: SQL Fundamentals
    3. Chapter 3: The Components of SQL
  6. Part II: Using SQL to Build Databases
    1. Chapter 4: Building and Maintaining a Simple Database Structure
    2. Chapter 5: Building a Multitable Relational Database
  7. Part III: Storing and Retrieving Data
    1. Chapter 6: Manipulating Database Data
    2. Chapter 7: Handling Temporal Data
    3. Chapter 8: Specifying Values
    4. Chapter 9: Using Advanced SQL Value Expressions
    5. Chapter 10: Zeroing In on the Data You Want
    6. Chapter 11: Using Relational Operators
    7. Chapter 12: Delving Deep with Nested Queries
    8. Chapter 13: Recursive Queries
  8. Part IV: Controlling Operations
    1. Chapter 14: Providing Database Security
    2. Chapter 15: Protecting Data
    3. Chapter 16: Using SQL within Applications
  9. Part V: Taking SQL to the Real World
    1. Chapter 17: Accessing Data with ODBC and JDBC
    2. Chapter 18: Operating on XML Data with SQL
  10. Part VI: Advanced Topics
    1. Chapter 19: Stepping through a Dataset with Cursors
    2. Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules
    3. Chapter 21: Handling Errors
    4. Chapter 22: Triggers
  11. Part VII: The Part of Tens
    1. Chapter 23: Ten Common Mistakes
    2. Chapter 24: Ten Retrieval Tips
    3. Appendix: SQL: 2011 Reserved Words
  12. About the Author
  13. Cheat Sheet
  14. Connect with Dummies
3.144.233.150