SQL Fundamentals

ISBN-10: 0130669474
ISBN-13: 9780130669476
Edition: 2nd 2002 (Revised)
Authors: John J. Patrick
List price: $59.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle 9i for the enterprise, and Microsoft Access 2000 for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
Writing a Scientific Report Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $59.99
Edition: 2nd
Copyright year: 2002
Publisher: Prentice Hall PTR
Publication date: 5/7/2002
Binding: Mixed Media
Pages: 864
Size: 6.75" wide x 9.00" long x 1.25" tall
Weight: 2.684
Language: English

Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle 9i for the enterprise, and Microsoft Access 2000 for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, SQL Fundamentals, Second Edition shows exactly how to retrieve the data you want, when you need it, in any application -- from ad hoc reports to the data warehouse. Unlike competitive books, SQL Fundamentals, Second Edition emphasizes practical concepts and examples from the latest versions of both leading SQL implementations: Access 2000 on the desktop, and Oracle 9i for the enterprise. You'll start with the basics: creating simple queries to retrieve information from a single table. Next, you'll move on to more complex queries involving many tables. Patrick shows how to create tables and views that divide a complex process into a series of simple steps; summarize your data; work with each form of join; and much more. Throughout, he emphasizes techniques for writing SQL queries that are easy to understand, verify, modify, and extend. All tables used in the book are furnished in both Oracle and Access format. The accompanying CD-ROM contains a library of Access databases and code for building Oracle databases.

Preface
Acknowledgments
Storing Information in Tables
Introduction
The Parts of a Table
Examples of Tables
Summary
Getting Information from a Table
The Select Statement
The Select Clause
The Where Clause
The Order By Clause
Summary
Exercises
Compound Conditions in the Where Clause
Compound Conditions in the Where Clause
Constant Values
Punctuation Matters
Some Exercises Solved for You
Summary
Exercises
Saving Your Results
Saving Your Results in a New Table or View
Modifying the Data in a Table
Summary
Exercises
Modifying Data Through a View
Transactions
Modifying Data Through a View
Oracle SQLplus
Finding Information About Tables and Views
Summary
Exercises
Creating Your Own Tables
Creating Tables
Changing Tables
Tables with Duplicate Rows
Loading a Large Amount of Data from a Flat File
Summary
Exercises
Formats, Sequences, and Indexes
Formats
Sequences
Indexes
Finding More Information in the Data Dictionary
An Exercise Solved for You
Summary
Exercises
Data Integrity
Referential Integrity
The Delete Options and Update Options of RI
Variations of Referential Integrity
Other Types of Constraints
Summary
Exercises
Row Functions
Introduction to Row Functions
Number Functions
Text Functions
Date Functions
Summary
Exercises
Using Row Functions
Other Functions
Using the Documentation of Row Functions
Creating Patterns of Numbers and Dates
Summary
Exercises
Summarizing Data
Introduction to the Column Functions
Maximum and Minimum
Count
Sum and Average
Other Topics
Summary
Exercises
Controlling the Level of Summarization
Dividing a Table into Groups of Rows and Summarizing Each Group
Eliminating Some of the Summarized Data
Restrictions on Summarization
Summary
Exercises
Inner Joins
Introduction to Joins
Inner Joins of Two Tables
Variations of the Join Condition
Applications of Joins
Summary
Exercises
Outer Joins
Introduction to Outer Joins
Applications of Outer Joins
Summary
Exercises
Union and Union All
Unions
Unconventional Unions
Applications of a Union
Set Intersection and Set Difference in Oracle
Summary
Exercises
Cross Joins and Self Joins
Cross Joins
Self Joins
Summary
Exercises
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
Summary
If-Then-Else and Subqueries
If-Then-Else Logic
Parameter Queries
Subqueries
Applications of Subqueries
Older Features of Subqueries
Summary
The Multiuser Environment
Database Configurations
Operating in a Multiuser Environment
Security and Privileges
Several People Using the Same Table at the Same Time
Locks
The Data Dictionary and the Multiuser Environment
How to Create a Shared Application
Summary
The Design of SQL
Original SQL Design Objectives
Newer Interfaces
Typical Applications
Summary
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
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
Tips on Using Access
You Can Use Access 2000 or 2002
Starting Access
Entering an SQL Query
Dealing with Errors
Printing
Diagram of the Lunches Database
Join Conditions
Data Validation Rules
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×