Résumé
If SQL can do it, you can do it too...
- Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you'd like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.
Inside, you'll find complete coverage of SQL
- Understand the definition and characteristics of relational databases and SQL's role within RDBMS
- Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
- Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
- Comprehend Data Manipulation Language (DML) from different vendors' perspectives
- Master single-table select statements and multitable queries from the ground up</ LI>
- Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
- Discover new SQL developments including XML, OLAP, Web services, and object-oriented features
Bonus CD-ROM includes:
- IBM DB2 Universal Database Personal Edition v 8.1 for Windows Operating Environments Evaluation copy
- Complete original database example files from the authors
- Complete book in PDF format
Contents
SQL Basic Concepts and Principles- SQL and Relational Database Management Systems (RDBMS)
- Fundamental SQL Concepts and Principles
- SQL Data Types
- Creating RDBMS Objects
- Altering and Destroying RDBMS Objects
- Data Manipulation Language (DML)
- Sessions, Transactions, and Locks
- Understanding SELECT Statement
- Multitable Queries
- SQL Functions
- SQL Operators
- SQL and RDBMS Security
- The System Catalog and INFORMATION_SCHEMA
- Stored Procedures, Triggers, and User-Defined Functions
- Dynamic and Embedded SQL Overview
- SQL API
- New Developments: XML, OLAP, and Objects
L'auteur - Alex Kriegel
Alex Kriegel is a professional database systems analyst with a major manufacturing firm in Oregon. He has more than 10 years of database experience working with Microsoft SQL Server, Oracle, DB2, Sybase, and PostgreSQL both as developer and DBA. Alex has a bachelor of science degree in solid-state physics from State Polytechnic Institute of Minsk, Belarus, and has earned the Microsoft Certified Solution Developer (MCSD) accreditation. He is the author of SQL Bible. Alex wrote the first draft of approximately two-thirds of this book.
L'auteur - Boris M. Trukhnov
Boris M. Trukhnov, OCP, has been working as Senior
Technical Analyst/Oracle DBA for Pope & Talbot, Inc.,
in Portland, Oregon, since 1998. His previous job titles
include Senior Programmer Analyst, Senior Software
Developer, and Senior Operations Analyst. He has been
working with SQL and relational databases since 1994. Boris
holds a B.S. in Computer Science from the University of
Minnesota.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wiley |
| Auteur(s) | Alex Kriegel, Boris M. Trukhnov |
| Parution | 30/04/2003 |
| Nb. de pages | 856 |
| Format | 18,8 x 23,5 |
| Couverture | Broché |
| Poids | 1267g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780764525841 |
| ISBN13 | 978-0-7645-2584-1 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
