Larry Watson, the author of Montana 1948 and many other fine novels, has just published Let Him Go, his latest foray into literary fiction. Let Him...
Continue »
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
Synopsis:
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.
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.
Product details
480 pages
For Dummies -
English9781118607961
Reviews:
"Synopsis"
by Wiley,
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.
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.
