SQL for dummies

Allen G. Taylor - Collection For Dummies

426 pages, parution le 21/08/2003 (5^eme édition)

Ajouter à une liste

Indisponible

Résumé

SQL is the international standard database language used to create, access, manipulate, maintain, and store information in a relational database management system (DBMS)-a vital tool for database programmers and Web developers
The new SQL standard due for release in summer 2003 is the first updated standard in over three years; it mandates the expansion of SQL beyond its relational roots to handle images, sound files, and other nonrelational data types and will produce a great need for updated information
The fifth edition of this popular reference guide is completely revised to cover these enhancements, including how to handle data stored in XML files and on the Web, expanded coverage of image and sound files, and some hot new trends like OLE DB
Uses the friendly, easy-to-understand For Dummies style to show programmers and Web developers how to build relational databases, retrieve information from them, implement a database design, secure a database, and perform other essential functions with SQL
Author has written twenty computer books, many relating to databases and database management

Introduction

Basic Concepts
- Relational Database Fundamentals
- SQL Fundamentals
- The Components of SQL

Using SQL to Build Databases
- Building and Maintaining a Simple Database Structure
- Building a Multitable Relational Database

Retrieving Data
- Manipulating Database Data
- Specifying Values
- Advanced SQL Value Expressions
- Zeroing In on the Data You Want
- Relational Operators
- Delving Deep with Nested Queries
- Recursive Queries
- Providing Database Security

Controlling Operations
- Protecting Data
- Using SQL Within Applications

SQL in the Real World
- ODBC and JDBC
- SQL:2003 and XML

Advanced Topics
- Cursors
- Persistent Stored Modules
- Error-Handling

The Part of Tens
- Ten Common Mistakes
- Ten Retrieval Tips

Appendixes
- SQL:2003 Reserved Words
- Glossary

Index

L'auteur - Allen G. Taylor

Allen Taylor est formateur et spécialiste reconnu des bases de données, avec à son actif plus de 20 ouvrages sur le sujet.

Allen Taylor is a database consultant and 30-year veteran of the computer industry. He is the author of 20 computer-related books, including SQL Weekend Crash Course and SQL For Dummies.

Autres livres de Allen G. Taylor

SQL poche pour les nuls

SQL pour les nuls

Sql poche pour les nuls 3ed

SQL pour les nuls

Découvrir tous les livres de Allen G. Taylor

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Allen G. Taylor
Collection	For Dummies
Parution	21/08/2003
Édition	5^eme édition
Nb. de pages	426
Format	18,7 x 23,2
Couverture	Broché
Poids	640g
Intérieur	Noir et Blanc
EAN13	9780764540752