SQL Fundamentals, 3rd Edition View Larger Image | John J. Patrick
Prentice Hall, Paperback, 3rd edition, Published September 2008, 832 pages, ISBN 0137126026 | List Price: $59.99
Our Price: $37.95
You Save: $22.04 (37% Off)
| | | Availability: In-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
SQL for Oracle® 11g, Access® 2007–and the real world!
Don’t just learn “generic” SQL. Learn SQL to get results with
the world’s top database platforms–Oracle 11g for the enterprise,
and Microsoft Access 2007 for the desktop. Based on John Patrick’s hands-on
SQL course at the University of California, 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. Thoroughly updated for the newest versions
of Oracle, Access, and the SQL standard, this book contains more exercises,
techniques, and solutions than ever before. You’ll learn exactly how to
write SQL queries that are easy to understand, verify, modify, and extend–even
if you’ve never worked with databases before!
SQL Fundamentals, Third Edition, teaches you how to
• Build simple statements to retrieve, store, or modify data
• Craft complex queries that draw information from multiple tables
• Sort and summarize your data just the way you want it
• Create and edit your own tables
• Protect the integrity of your data
• Create more efficient, high-performance queries
• Work with unions, subqueries, self joins, cross joins, inner joins,
and outer joins
• Use Oracle SQL*Plus and the Oracle Data Dictionary
About the Web Site
The accompanying Web site, http://groups.google.com/group/sqlfun, contains
all SQL code and tables from the book, including full databases for several
versions of Access, and code for building the corresponding Oracle databases.
It also provides solutions to many of the book’s problems and an open area
for discussions with the author and other readers.
Table of Contents
Preface
Chapter 1: Storing Information in Tables
Introduction
The Parts of a Table
Examples of Tables
Key Points
Chapter 2: Getting Information from a Table
The Select Statement
The Select Clause
The Where Clause
The Order By Clause
Key Points
Chapter 3: Compound Conditions in the Where Clause
Compound Conditions in the Where Clause
Constant Values
Punctuation Matters
Case Sensitivity
Three-valued Logic
Error Messages
Some Exercises Solved for You
Key Points
Chapter 4: Saving Your Results
Saving Your Results in a New Table or View
Modifying the Data in a Table with SQL
Modifying the Data in a Table with the GUI
Restrictions on Modifying the Data in a Table
Key Points
Chapter 5: The Data Dictionary and Other Oracle Topics
Commit, Rollback, and Transactions
Modifying Data through a View
Oracle SQL*Plus
Using the Oracle Data Dictionary - Part 1
Key Points
Chapter 6: Creating Your Own Tables
Creating Tables
Changing Tables
Tables with Duplicate Rows
Key Points
Chapter 7: Formats, Sequences, and Indexes
Formats
Sequences
Indexes
Using the Oracle Data Dictionary - Part 2
An Exercise Solved for You
Key Points
Chapter 8: Data Integrity
Constraints on one table
Referential Integrity
The Delete Options and Update Options of RI
Variations of Referential Integrity
How to code Constraints in a Create Table statement
Key Points
Chapter 9: Row Functions
Introduction to Row Functions
Numeric Functions
Text Functions
Date Functions
Key Points
Chapter 10: Using Row Functions
Specialized Row Functions
Using the Documentation of Row Functions
Creating Patterns of Numbers and Dates
Key Points
Chapter 11: Summarizing Data
Introduction to the Column Functions
Maximum and Minimum
Count
Sum and Average
Other Topics
Key Points
Chapter 12: Controlling the Level of Summarization
Dividing a Table into Groups of Rows
Eliminating Some of the Summarized Data
Key Points
Chapter 13: Inner Joins
Introduction to Joins
Inner Joins of Two Tables
Variations of the Join Condition
Applications of Joins
Key Points
Chapter 14: Outer Joins
Introduction to Outer Joins
Applications of Outer Joins
Key Points
Chapter 15: Union and Union All
Union Basics
Unconventional Unions
Applications of a Union
Set Intersection and Set Difference in Oracle
Key Points
Chapter 16: Cross Joins Self Joins and CrossTab Queries
Cross Joins
Self Joins
Cross Tab Queries in Access
Cross Tab Queries in Oracle
Key Points
Chapter 17: Combining Tables in a Production Database
Methods of Joining Three or More Tables
Losing Information
Caring About the Efficiency of Your Computer
Standardizing the Way That Tables Are Joined
Key Points
Chapter 18: If-Then-Else, Parameter Queries and Subqueries
If-Then-Else Logic
Parameter Queries
Subqueries
Applications of Subqueries
Older Features of Subqueries
Key Points
Chapter 19: The Multiuser Environment
Database Configurations
Operating in a Multiuser Environment
Security and Privileges
The Oracle Data Dictionary and the Multiuser Environment
Key Points
Chapter 20: The Design of SQL
Original SQL Design Objectives
Newer Interfaces
Typical Applications
Key Points
Appendix A: Obtaining and Installing Oracle
Getting Current Information
Which Product Should You Get?
Downloading Oracle from the Internet
Ordering Oracle on a CD
Installing Oracle
Setting Up to Run the Examples in This Book
Setting Up a New Userid
Installing the Tables Used in This Book
How to Build the Tables and Assign Other Tablespace Names
Appendix B: Tips on Using Oracle
Starting Oracle
Entering a Query
Other Ways to Edit Your SQL Code
Error Messages Are Sometimes Correct
Using the Scrollbars
If Oracle Does Not Respond
Installing the LOGIN Script
Running All the SQL for a Chapter
Appendix C: Tips on Using Access
You Can Use Access 2000 or 2002
Starting Access
Entering an SQL Query
Dealing with Errors
Printing
Appendix D: Diagram of the Lunches Database
Join Conditions
Data Validation Rules
Index
|
