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