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
- Cover
- Title Page
- Table of Contents
- Introduction
- Part I: Getting Started with SQL
- Part II: Using SQL to Build Databases
-
Part III: Storing and Retrieving Data
- Chapter 6: Manipulating Database Data
- Chapter 7: Handling Temporal Data
- Chapter 8: Specifying Values
- Chapter 9: Using Advanced SQL Value Expressions
- Chapter 10: Zeroing In on the Data You Want
- Chapter 11: Using Relational Operators
- Chapter 12: Delving Deep with Nested Queries
- Chapter 13: Recursive Queries
- Part IV: Controlling Operations
- Part V: Taking SQL to the Real World
- Part VI: Advanced Topics
- Part VII: The Part of Tens
- About the Author
- Cheat Sheet
- Connect with Dummies
Product information
- Title: SQL For Dummies, 8th Edition
- Author(s):
- Release date: September 2013
- Publisher(s): For Dummies
- ISBN: 9781118607961
You might also like
book
SQL For Dummies, 9th Edition
Get ready to make SQL easy! Updated for the latest version of SQL, the new edition …
book
SQL For Dummies®, 7th Edition
Learn SQL the fun and easy way – no programming experience needed! SQL For Dummies, 7th …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …
book
SQL Cookbook, 2nd Edition
You may know SQL basics, but are you taking advantage of its expressive power? This second …