SQL All-in-One For Dummies

SQL All-in-One For Dummies

by Allen G. Taylor
     
 

View All Available Formats & Editions

Want to be a database diva or the office's information oracle? Do it with SQL — here's how!

SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you're new to SQL or

See more details below

Overview

Want to be a database diva or the office's information oracle? Do it with SQL — here's how!

SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you're new to SQL or an old hand who wants to supercharge your database, find help in one of these minibooks!

  • The overview — Books I and II give you the nitty-gritty about SQL, relational databases, and the System Development Life Cycle
  • If you have queries — learn the fine points of making SQL retrieve exactly what you want from the database and no more
  • Safety first — discover the tools SQL provides to protect your vital data and handle any errors that occur
  • Integrating SQL with other languages — understand how SQL works with Visual Basic, Java, C++, and XML
  • Turbocharge your database — fine-tune and optimize your databases to keep them performing optimally

Visit the companion Web site at dummies.com/go/sqlaiofd2e to download a zip file that contains all the sample code used in this book

Open the book and find:

  • Details of how SQL works
  • SQL data types
  • Why the System Development Life Cycle matters
  • Directions for structuring SQL queries
  • Tips for protecting your database from user errors
  • Sample applications you can use
  • Ways to track down and eliminate bottlenecks
  • Definitions of common SQL terms

8 Books in 1

  • SQL Concepts
  • Relational Database Development
  • SQL Queries
  • Data Security
  • SQL and Programming
  • SQL and XML
  • Database Tuning Overview
  • Appendices

Read More

Product Details

ISBN-13:
9781118038659
Publisher:
Wiley
Publication date:
03/10/2011
Series:
For Dummies Series
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
744
Sales rank:
313,565
File size:
22 MB
Note:
This product may take a few minutes to download.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >