SQL For Dummies

Front Cover
John Wiley & Sons, Jan 7, 2010 - Computers - 456 pages

Learn SQL the fun and easy way – no programming experience needed!

SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008.

  • The latest update of the perennial bestselling SQL For Dummies, which has sold more than 210,000 units in six editions.
  • SQL is the most popular database language in the world
  • Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL.
  • Includes new content on using SQL with XML to power data-driven web sites and using SQL with Access 2010

Whether you're daunted by database development or a system admin star, SQL For Dummies, 7th Dummies will have you working your web site in no time at all.

 

What people are saying - Write a review

User Review - Flag as inappropriate

A good foundation

Contents

Introduction
1
The Part of Tens 409
4
Relational Database Fundamentals
7
SQL Fundamentals
23
The Components of SQL
53
Using SQL to Build Databases
81
Building a Multitable Relational Database
107
Storing and Retrieving Data
137
Controlling Operations
275
Protecting Data
293
Using SQL within Applications
313
Taking SQL to the Real World
327
Taking SQL to the Real World 327 Chapter 16 Accessing Data with ODBC and JDBC
329
Operating on XML Data with SQL
339
Advanced Topics
361
Persistent Stored Modules
373

Specifying Values
157
Using Advanced SQL Value Expressions
183
Zeroing In on the Data You Want
197
Using Relational Operators
223
Delving Deep with Nested Queries
247
Recursive Queries
265
Handling Errors
391
Triggers
403
Ten Common Mistakes
411
SQL2008 Reserved Words
419
Copyright

Other editions - View all

Common terms and phrases

About the author (2010)

Allen G. Taylor is a nationally known lecturer and educator in the field of database development. A 30-year veteran of the computer industry, he has written more than 20 books. Through the magic of the Internet, Allen teaches computer architecture both at Portland State University and in Shanghai.

Bibliographic information