|
|
Downloads via DownloadAccess - Give it a try!
Secure download via TorrentPrivacy| Category: | Books |
| Added: | 1 Year+ |
| Size: | 44 Megabyte |
| Peers: | 47 Seeders & 25 Leechers  [ Update ]updated '8 months ago' |
| Tracker: | http://www.h33t.com:3310 |
| Infohash: | 506024f893fe4e00ae17ab5a43d7076217003c3c |
Retrieving torrent peers info from tracker, please wait...Description:
*******************************************************************************
SQL Fundamentals
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 6,071,666 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
Don't just learn "generic" SQL: learn SQL to get results with the world's top
database platforms -- Oracle for the enterprise and Microsoft Access for the
desktop! Based on John J. Patrick's hands-on SQL course at the University of
California at Berkeley Extension, this book shows exactly how to retrieve the
data you want, when you need it, in any application -- from ad hoc reports to
the data warehouse. From the simplest Select statements to the most
sophisticated joins, Patrick shows you exactly how to write SQL queries that are
easy to understand, verify, modify, and extend.
Table Of Contents
Preface
Acknowledgments
Ch. 1 Storing Information in Tables 1
Ch. 2 Getting Information from a Table 33
Ch. 3 Compound Conditions in the Where Clause 89
Ch. 4 Saving Your Results 139
Ch. 5 Modifying Data Through a View 177
Ch. 6 Creating Your Own Tables 227
Ch. 7 Formats, Sequences, and Indexes 277
Ch. 8 Data Integrity 315
Ch. 9 Row Functions 357
Ch. 10 Using Row Functions 397
Ch. 11 Summarizing Data 435
Ch. 12 Controlling the Level of Summarization 473
Ch. 13 Inner Joins 521
Ch. 14 Outer Joins 563
Ch. 15 Union and Union All 601
Ch. 16 Cross Joins and Self Joins 643
Ch. 17 Combining Tables in a Production Database 669
Ch. 18 If-Then-Else and Subqueries 691
Ch. 19 The Multiuser Environment 735
Ch. 20 The Design of SQL 779
App. A Obtaining and Installing Oracle 791
App. B Tips on Using Oracle 801
App. C Tips on Using Access 813
App. D Diagram of the Lunches Database 821
Index 825
Product Details
* ISBN: 0137126026
* ISBN-13: 9780137126026
* Format: Paperback, 832pp
* Publisher: Prentice Hall
* Pub. Date: September 2008
* Edition Number: 3
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader
*******************************************************************************
SQL Fundamentals
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 6,071,666 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
Don't just learn "generic" SQL: learn SQL to get results with the world's top
database platforms -- Oracle for the enterprise and Microsoft Access for the
desktop! Based on John J. Patrick's hands-on SQL course at the University of
California at Berkeley Extension, this book shows exactly how to retrieve the
data you want, when you need it, in any application -- from ad hoc reports to
the data warehouse. From the simplest Select statements to the most
sophisticated joins, Patrick shows you exactly how to write SQL queries that are
easy to understand, verify, modify, and extend.
Table Of Contents
Preface
Acknowledgments
Ch. 1 Storing Information in Tables 1
Ch. 2 Getting Information from a Table 33
Ch. 3 Compound Conditions in the Where Clause 89
Ch. 4 Saving Your Results 139
Ch. 5 Modifying Data Through a View 177
Ch. 6 Creating Your Own Tables 227
Ch. 7 Formats, Sequences, and Indexes 277
Ch. 8 Data Integrity 315
Ch. 9 Row Functions 357
Ch. 10 Using Row Functions 397
Ch. 11 Summarizing Data 435
Ch. 12 Controlling the Level of Summarization 473
Ch. 13 Inner Joins 521
Ch. 14 Outer Joins 563
Ch. 15 Union and Union All 601
Ch. 16 Cross Joins and Self Joins 643
Ch. 17 Combining Tables in a Production Database 669
Ch. 18 If-Then-Else and Subqueries 691
Ch. 19 The Multiuser Environment 735
Ch. 20 The Design of SQL 779
App. A Obtaining and Installing Oracle 791
App. B Tips on Using Oracle 801
App. C Tips on Using Access 813
App. D Diagram of the Lunches Database 821
Index 825
Product Details
* ISBN: 0137126026
* ISBN-13: 9780137126026
* Format: Paperback, 832pp
* Publisher: Prentice Hall
* Pub. Date: September 2008
* Edition Number: 3
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader