SQL For Dummies

Купить бумажную книгу и читать

Название: SQL For Dummies

Автор: Taylor A.G.

Издательство: Wiley

Год: 2013

Страниц: 480

ISBN: 1118607961, 9781118607961

Формат: PDF

Размер: 14 Mб

Язык: английский

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.

Contents:

Introduction

Getting Started with SQL

Relational Database Fundamentals

SQL Fundamentals

The Components of SQL

Using SQL to Build Databases

Building and Maintaining a Simple Database Structure

Building a Multitable Relational Database

Storing and Retrieving Data

Manipulating Database Data

Handling Temporal Data

Specifying Values

Using Advanced SQL Value Expressions

Zeroing In on the Data You Want

Using Relational Operators

Delving Deep with Nested Queries

Recursive Queries

Controlling Operations

Providing Database Security

Protecting Data

Using SQL within Applications

Taking SQL to the Real World

Accessing Data with ODBC and JDBC

Operating on XML Data with SQL

Advanced Topics

Stepping through a Dataset with Cursors

Adding Procedural Capabilities with Persistent Stored Modules

Handling Errors

Triggers

The Part of Tens

Ten Common Mistakes

Ten Retrieval Tips

Appendix: SQL: 2011 Reserved Words

Index