• SQL For Dummies See large image

    SQL For Dummies (For Dummies) (Paperback) By (author) Allen G. Taylor

    $22.21 - Save $13.18 37% off - RRP $35.39 Free delivery worldwide Available
    Dispatched in 2 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

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


Other books

Other books in this category
Showing items 1 to 11 of 11

 

Reviews | Bibliographic data
  • Full bibliographic data for SQL For Dummies

    Title
    SQL For Dummies
    Authors and contributors
    By (author) Allen G. Taylor
    Physical properties
    Format: Paperback
    Number of pages: 480
    Width: 188 mm
    Height: 231 mm
    Thickness: 28 mm
    Weight: 635 g
    Language
    English
    ISBN
    ISBN 13: 9781118607961
    ISBN 10: 1118607961
    Classifications

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 05
    B&T Modifier: Continuations: 02
    LC subject heading:
    B&T Modifier: Text Format: 01
    LC subject heading:
    B&T General Subject: 227
    B&T Merchandise Category: COM
    Warengruppen-Systematik des deutschen Buchhandels: 26320
    LC subject heading:
    Ingram Subject Code: XL
    LC subject heading:
    Libri: I-XL
    BIC subject category V2: UMT
    LC subject heading:
    B&T Approval Code: A93603281
    BISAC V2.8: COM051170, COM021000
    DC22: 005.7585, 005.75/85
    LC subject heading:
    DC23: 005.7585
    LC classification: QA76.73.S67 T39 2013
    Thema V1.0: UN, UMT
    Edition
    8, Revised
    Edition statement
    8th Revised edition
    Publisher
    John Wiley & Sons Inc
    Imprint name
    John Wiley & Sons Inc
    Publication date
    20 September 2013
    Publication City/Country
    New York
    Author Information
    Allen G. Taylor is a 30-year veteran of the computer industry. He lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. He has written more than 20 books, including all editions of SQL For Dummies .
    Back cover copy
    Learn to: Build relational databases and pull useful information from themCreate a database management system using SQLSecure your database and protect it from corruptionUse all the latest SQL featuresCreate more powerful databases and easily access information -- the secret is SQL!Our world runs on data -- more now than ever before. All that data must be stored in a logical way, secure and easily accessible. SQL is the language you use to create database management systems, implement database design, and manage data access. This guide takes you step by step through understanding and applying the latest version of SQL to help you take control of your data like a pro.The basic stuff -- understand the fundamentals of SQL and relational databasesSpeaking the language -- learn the language of data definition, data manipulation, and data controlBegin building -- use a RAD tool to build a simple database, then move into multitable relational databasesDo things with data -- discover how to add, update, and retrieve data, and delete what you no longer needFind what you want -- examine techniques for querying your database to retrieve exactly the data you're looking forKeep it safe -- manage user access, make your data less vulnerable to corruption, and understand threatsAlphabet soup -- master ODBC and JDBC access, and use SQL on XML dataAdvanced SQL -- explore adding procedural capabilities with persistent stored modules and handling errors"Open the book and find: The wide array of data typesHow to use SQL on the InternetTips for designing tablesWays to maintain data integrityWhat you should know about values and value expressionsHow to use subqueries and recursive queriesAll about using triggersTen common mistakes to avoid
    Table of contents
    Introduction 1 Part I: Getting Started with SQL 3 Chapter 1: Relational Database Fundamentals 5 Chapter 2: SQL Fundamentals 21 Chapter 3: The Components of SQL 51 Part II: Using SQL to Build Databases 79 Chapter 4: Building and Maintaining a Simple Database Structure 81 Chapter 5: Building a Multitable Relational Database 105 Part III: Storing and Retrieving Data 137 Chapter 6: Manipulating Database Data 139 Chapter 7: Handling Temporal Data 157 Chapter 8: Specifying Values 171 Chapter 9: Using Advanced SQL Value Expressions 197 Chapter 10: Zeroing In on the Data You Want 211 Chapter 11: Using Relational Operators 243 Chapter 12: Delving Deep with Nested Queries 267 Chapter 13: Recursive Queries 285 Part IV: Controlling Operations 295 Chapter 14: Providing Database Security 297 Chapter 15: Protecting Data 313 Chapter 16: Using SQL within Applications 333 Part V: Taking SQL to the Real World 347 Chapter 17: Accessing Data with ODBC and JDBC 349 Chapter 18: Operating on XML Data with SQL 359 Part VI: Advanced Topics 381 Chapter 19: Stepping through a Dataset with Cursors 383 Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules 393 Chapter 21: Handling Errors 411 Chapter 22: Triggers 423 Part VII: The Part of Tens 429 Chapter 23: Ten Common Mistakes 431 Chapter 24: Ten Retrieval Tips 435 Appendix: SQL: 2011 Reserved Words 439 Index 443