|
|
Downloads via DownloadAccess - Give it a try!
Secure download via TorrentPrivacy| Category: | Books |
| Added: | 1 Year+ |
| Size: | 13 Megabyte |
| Peers: | 168 Seeders & 70 Leechers  [ Update ]updated '7 months ago' |
| Tracker: | http://www.h33t.com:3310 |
| Infohash: | 65e1cc6f306b43acc1490e89804c6f086a6cc7b2 |
Retrieving torrent peers info from tracker, please wait...Description:
*******************************************************************************
SQL Clearly Explained
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 13,288,485 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
This is the second edition of the popular practitioner's guide to SQL, the
industry-standard database query language. Like most computer languages, SQL can
be overwhelming when you first see it, but for years readers have relied on this
book to clear the confusion and explain how SQL works and how to use it
effectively. Packed with tips, tricks, and good information, SQL Clearly
Explained, Second Edition teaches database users and programmers everything they
need to know to get their job done including
*formulating SQL queries,
*understanding how queries are processed by the DBMS,
*maximizing performance,
*using SQL to enter, modify, or delete data,
*creating and maintaining database structural elements
*embedding SQL in applications.
Table of Contents
Preface to the Second Edition
Pt. 1 Getting Started
Ch. 1 Installing and Running MySQL 3
Ch. 2 Creating and Loading Databases 9
Ch. 3 Introduction to SQL 17
Pt. 2 Performing Interactive Data Manipulation
Ch. 4 Simple SQL Retrieval 35
Ch. 5 Retrieving Data from More Than One Table: Joins 65
Ch. 6 Advanced Retrieval Operations 101
Ch. 7 Calculations and Grouping Queries 119
Ch. 8 Data Modification 147
Pt. 3 Managing Database Structure
Ch. 9 Schemas and Tables 157
Ch. 10 Views, Temporary Tables, and Indexes 179
Pt. 4 Program-Based Data Manipulation
Ch. 11 Users, Sessions, and Transaction Control 203
Ch. 12 Embedded SQL 217
Ch. 13 Dynamic SQL 235
Pt. 5 Additional Language Features
Ch. 14 Unimplemented SQL-92 Features 251
Ch. 15 Object-Oriented Features of the SQL:1999 Standard 265
Pt. 6 Appendices
App. A The Online Bookstore Database 301
App. B SQLSTATE Return Codes 309
App. C SQL Syntax Summary 315
App. D SQL:1999 Core Features 323
Glossary 333
Index 343
Product Details
* ISBN: 1558608761
* ISBN-13: 9781558608764
* Format: Paperback, 352pp
* Publisher: Elsevier Science & Technology Books
* Pub. Date: May 2003
* Edition Description: REV
* Edition Number: 2
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader
*******************************************************************************
SQL Clearly Explained
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 13,288,485 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
This is the second edition of the popular practitioner's guide to SQL, the
industry-standard database query language. Like most computer languages, SQL can
be overwhelming when you first see it, but for years readers have relied on this
book to clear the confusion and explain how SQL works and how to use it
effectively. Packed with tips, tricks, and good information, SQL Clearly
Explained, Second Edition teaches database users and programmers everything they
need to know to get their job done including
*formulating SQL queries,
*understanding how queries are processed by the DBMS,
*maximizing performance,
*using SQL to enter, modify, or delete data,
*creating and maintaining database structural elements
*embedding SQL in applications.
Table of Contents
Preface to the Second Edition
Pt. 1 Getting Started
Ch. 1 Installing and Running MySQL 3
Ch. 2 Creating and Loading Databases 9
Ch. 3 Introduction to SQL 17
Pt. 2 Performing Interactive Data Manipulation
Ch. 4 Simple SQL Retrieval 35
Ch. 5 Retrieving Data from More Than One Table: Joins 65
Ch. 6 Advanced Retrieval Operations 101
Ch. 7 Calculations and Grouping Queries 119
Ch. 8 Data Modification 147
Pt. 3 Managing Database Structure
Ch. 9 Schemas and Tables 157
Ch. 10 Views, Temporary Tables, and Indexes 179
Pt. 4 Program-Based Data Manipulation
Ch. 11 Users, Sessions, and Transaction Control 203
Ch. 12 Embedded SQL 217
Ch. 13 Dynamic SQL 235
Pt. 5 Additional Language Features
Ch. 14 Unimplemented SQL-92 Features 251
Ch. 15 Object-Oriented Features of the SQL:1999 Standard 265
Pt. 6 Appendices
App. A The Online Bookstore Database 301
App. B SQLSTATE Return Codes 309
App. C SQL Syntax Summary 315
App. D SQL:1999 Core Features 323
Glossary 333
Index 343
Product Details
* ISBN: 1558608761
* ISBN-13: 9781558608764
* Format: Paperback, 352pp
* Publisher: Elsevier Science & Technology Books
* Pub. Date: May 2003
* Edition Description: REV
* Edition Number: 2
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader