Search Images Maps Play YouTube News Gmail Drive More »
My library | Help | Advanced Book Search | Web History | Sign in

Books

SQL All-in-One For Dummies

Front Cover
1 Review
John Wiley & Sons, Mar 10, 2011 - Computers - 744 pages
The soup-to-nuts guide on all things SQL!

SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You’ll get the goods on relational database design, development, and maintenance, enabling you to start working with SQL right away!

  • Provides an overview of the SQL language and examines how it is integral for the storage and retrieval of database information
  • Includes updates to SQL standards as well as any new features
  • Explores SQL concepts, relational database development, SQL queries, data security, database tuning, and more
  • Addresses the relationship between SQL and programming as well as SQL and XML

If you’re looking for an up-to-date sequel to the bestelling first edition of SQL All-in-One For Dummies, then this is the book for you!

  

What people are saying - Write a review

User Review - Flag as inappropriate

Nice Book

Related books

Selected pages

Contents

Introduction
1
SQL Concepts
7
Understanding Relational Databases
9
Modeling a System
29
Getting to Know SQL
51
SQL and the Relational Model
63
Knowing the Major Components of SQL
73
Drilling Down to the SQL NittyGritty
95
Protecting Against User Errors and Conflicts
367
Assigning Access Privileges
395
Error Handling
407
SQL and Programming
423
Database Development Environments
425
Interfacing SQL to a Procedural Language
431
Using SQL in an Application Program
437
Designing a Sample Application
451

Relational Database Development
125
System Development Overview
127
Building a Database Model
143
Balancing Performance and Correctness
161
Creating a Database with SQL
193
SQL Queries
205
Values Variables Functions and Expressions
207
SELECT Statements and Modifying Clauses
231
Querying Multiple Tables with Subqueries
275
Querying Multiple Tables with Relational Operators
303
Cursors
323
Data Security
335
Protecting Against Hardware Failure and External Threats
337
Building an Application
469
Understanding SQLs Procedural Capabilities
485
Connecting SQL to a Remote Database
501
SQL and XML
515
Using XML with SQL
517
Storing XML Data in SQL Tables
541
Retrieving Data from XML Documents
561
Database Tuning Overview
577
Tuning the Database
579
Tuning the Environment
591
Finding and Eliminating Bottlenecks
611
Appendices
641
Copyright

Other editions - View all

Common terms and phrases

About the author (2011)

Allen G. Taylor lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. Among his more than 20 books are all editions of SQL For Dummies and Database Development For Dummies.

Bibliographic information