Start reading SQL For Dummies (For Dummies (Computer/Tech)) on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books even without a Kindle device-with the FREE Kindle app for smartphones and tablets.
SQL For Dummies (For Dummies (Computer/Tech))
 
 

SQL For Dummies (For Dummies (Computer/Tech)) [Kindle Edition]

Allen G. Taylor
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: 21.99
Kindle Price: 6.17 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: 15.82 (72%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition 6.17  
Paperback 14.48  
Kid's and Teen books from £0.99 on Kindle
Browse our selection of top children's and teen title in our one week sale, with top titles from only £0.99.Browse the sale here


Product Description

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

From the Back Cover

Learn to: Build relational databases and pull useful information from them Create a database management system using SQL Secure your database and protect it from corruption Use all the latest SQL features Create 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 databases Speaking the language — learn the language of data definition, data manipulation, and data control Begin building — use a RAD tool to build a simple database, then move into multitable relational databases Do things with data — discover how to add, update, and retrieve data, and delete what you no longer need Find what you want — examine techniques for querying your database to retrieve exactly the data you're looking for Keep it safe — manage user access, make your data less vulnerable to corruption, and understand threats Alphabet soup — master ODBC and JDBC access, and use SQL on XML data Advanced SQL — explore adding procedural capabilities with persistent stored modules and handling errors Open the book and find: The wide array of data types How to use SQL on the Internet Tips for designing tables Ways to maintain data integrity What you should know about values and value expressions How to use subqueries and recursive queries All about using triggers Ten common mistakes to avoid

Product details


More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
Format:Paperback|Verified Purchase
This is an easy to read book. The information is given in bite size chunks and you progress through the book in a seamless and fluid manner. I recommend this book to the beginner through to the novice. If you only wish to dip your toe into the sea of SQL then this is the book to do just that.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.0 out of 5 stars  3 reviews
10 of 10 people found the following review helpful
1.0 out of 5 stars Not for SQL beginners or designers 17 Nov 2013
By David - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
They should really put in the sales description which people this book is for.....I found that after reading the first few chapters where they blatantly tell you this isn't really for beginners.
5 of 5 people found the following review helpful
3.0 out of 5 stars Good if you're looking for a programming guide for writing procedures, etc.; not really for ad-hoc query writing. 9 Dec 2013
By SF Fan - Published on Amazon.com
Format:Paperback|Verified Purchase
It's not that it's a "bad" book, but it isn't what I would expect from a "for Dummies" book. I was looking for something that would help me writing ad-hoc queries using SQL Developer for quick data analysis. Unfortunately, it's more a book for writing procedures, etc. While I don't dispute it's useful for that, b/c of the procedure focus, it doesn't have a lot of information specific to individual commands. I've been able to ferret out some information, but it's an effort to find what I'm looking for. Oh well. I'll probably stick to "trial & error" in most cases.
5.0 out of 5 stars Great Book 9 April 2014
By amos - Published on Amazon.com
Format:Paperback|Verified Purchase
This book gets to the point. It also points out differences in the old SQL and new SQL. This is a great tool for beginners and moderate SQL users.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


ARRAY(0xb0f58d08)