SQL Fundamentals

, by Patrick, John J.

Write a Review

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780137126026 | 0137126026
Cover: Paperback
Copyright: 9/2/2008

Rent

(Recommended)

$44.52

Term

Due

Price

Semester

Dec 13

$46.85

Quarter

Aug 16

$44.52

Short Term

Jul 2

$42.17

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy Used

Usually Ships in 3-5 Business Days

$49.89
Buy New

This is a hard-to-find title. We are making every effort to obtain this item, but do not guarantee stock.

$67.21

Summary

Author Biography

Supplemental Materials

Third edition of the hands-on, real-world guide to mastering SQL through using the world's top two databases: Oracle and Microsoft Access.

Preface	p. xxv
Storing Information in Tables	p. 1
Introduction	p. 3
The Parts of a Table	p. 9
Examples of Tables	p. 19
Key Points	p. 30
Getting Information from a Table	p. 31
The Select Statement	p. 33
The Select Clause	p. 37
The Where Clause	p. 50
The Order By Clause	p. 71
Key Points	p. 80
Compound Conditions in the Where Clause	p. 83
Compound Conditions in the Where Clause	p. 85
Constant Values	p. 95
Punctuation Matters	p. 102
Case Sensitivity	p. 113
Three-Valued Logic	p. 120
Error Messages	p. 122
Some Exercises Solved for You	p. 124
Key Points	p. 131
Saving Your Results	p. 133
Saving Your Results in a New Table or View	p. 135
Modifying the Data in a Table with SQL	p. 151
Modifying the Data in a Table with the GUI	p. 161
Restrictions on Modifying the Data in a Table	p. 167
Key Points	p. 170
The Data Dictionary and Other Oracle Topics	p. 171
Commit, Rollback, and Transactions	p. 173
Modifying Data through a View	p. 179
The SQL Commands Page in Oracle	p. 192
Using the Oracle Data Dictionary
	p. 195
Key Points	p. 207
Creating Your Own Tables	p. 209
Creating Tables	p. 211
Changing Tables	p. 226
Tables with Duplicate Rows	p. 236
Key Points	p. 243
Formats, Sequences, and Indexes	p. 245
Formats	p. 247
Sequences	p. 257
Indexes	p. 262
Using the Oracle Data Dictionary
	p. 266
An Exercise Solved for You	p. 278
Key Points	p. 280
Data Integrity	p. 281
Constraints on One Table	p. 283
Referential Integrity	p. 289
The Delete Options and Update Options of RI	p. 303
Variations of Referential Integrity	p. 311
How to Code Constraints in a Create Table Statement	p. 316
Key Points	p. 319
Row Functions	p. 321
Introduction to Row Functions	p. 323
Numeric Functions	p. 334
Text Functions	p. 340
Date Functions	p. 350
Key Points	p. 359
Using Row Functions	p. 361
Specialized Row Functions	p. 363
Using the Documentation of Row Functions	p. 372
Creating Patterns of Numbers and Dates	p. 376
Key Points	p. 397
Summarizing Data	p. 399
Introduction to the Column Functions	p. 401
Maximum and Minimum	p. 404
Count	p. 411
Sum and Average	p. 420
Other Topics	p. 428
Key Points	p. 434
Controlling the Level of Summarization	p. 435
Dividing a Table into Groups of Rows	p. 437
Eliminating Some of the Summarized Data	p. 459
Key Points	p. 471
Inner Joins	p. 473
Introduction to Joins	p. 475
Inner Joins of Two Tables	p. 479
Variations of the Join Condition	p. 495
Applications of Joins	p. 504
Key Points	p. 515
Outer Joins	p. 517
Introduction to Outer Joins	p. 519
Applications of Outer Joins	p. 534
Key Points	p. 553
Union and Union All	p. 555
Union Basics	p. 557
Unconventional Unions	p. 573
Applications of a Union	p. 577
Set Intersection and Set Difference in Oracle	p. 590
Key Points	p. 595
Cross Joins, Self Joins, and Cross Tab Queries	p. 597
Cross Joins	p. 599
Self Joins	p. 613
Cross Tab Queries in Access	p. 624
Cross Tab Queries in Oracle	p. 645
Key Points	p. 650
Combining Tables in a Production Database	p. 653
Methods of Joining Three or More Tables	p. 655
Losing Information	p. 660
Caring about the Efficiency of Your Computer	p. 663
Standardizing the Way That Tables Are Joined	p. 666
Key Points	p. 671
If-Then-Else, Parameter Queries, and Subqueries	p. 673
If-Then-Else Logic	p. 675
Table of Contents provided by Publisher. All Rights Reserved.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

SQL Fundamentals

Summary

Author Biography

Table of Contents

Supplemental Materials