x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

SQL Fundamentals

ISBN-10: 0137126026
ISBN-13: 9780137126026
Edition: 3rd 2009
Authors: John J. Patrick
List price: $69.99 Buy it from $34.21
This item qualifies for FREE shipping

*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.

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: SQL for Oraclereg; 11g, Accessreg; 2007and the real world! Donrsquo;t just learn ldquo;genericrdquo; SQL. Learn SQL to get results with the worldrsquo;s top database platformsOracle 11g for the enterprise, and Microsoft Access 2007 for the desktop.  More...

New Starting from $57.54
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

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
Calculus 1 Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $69.99
Edition: 3rd
Copyright year: 2009
Publisher: Prentice Hall PTR
Publication date: 9/2/2008
Binding: Paperback
Pages: 832
Size: 6.75" wide x 9.00" long x 1.25" tall
Weight: 2.728
Language: English

SQL for Oraclereg; 11g, Accessreg; 2007and the real world! Donrsquo;t just learn ldquo;genericrdquo; SQL. Learn SQL to get results with the worldrsquo;s top database platformsOracle 11g for the enterprise, and Microsoft Access 2007 for the desktop. Based on John Patrickrsquo;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 applicationfrom 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. Yoursquo;ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extendeven if yoursquo;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 bookrsquo;s problems and an open area for discussions with the author and other readers.

Preface
Storing Information in Tables
Introduction
The Parts of a Table
Examples of Tables
Key Points
Getting Information from a Table
The Select Statement
The Select Clause
The Where Clause
The Order By Clause
Key Points
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
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
The Data Dictionary and Other Oracle Topics
Commit, Rollback, and Transactions
Modifying Data through a View
The SQL Commands Page in Oracle
Using the Oracle Data Dictionary
Key Points
Creating Your Own Tables
Creating Tables
Changing Tables
Tables with Duplicate Rows
Key Points
Formats, Sequences, and Indexes
Formats
Sequences
Indexes
Using the Oracle Data Dictionary
An Exercise Solved for You
Key Points
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
Row Functions
Introduction to Row Functions
Numeric Functions
Text Functions
Date Functions
Key Points
Using Row Functions
Specialized Row Functions
Using the Documentation of Row Functions
Creating Patterns of Numbers and Dates
Key Points
Summarizing Data
Introduction to the Column Functions
Maximum and Minimum
Count
Sum and Average
Other Topics
Key Points
Controlling the Level of Summarization
Dividing a Table into Groups of Rows
Eliminating Some of the Summarized Data
Key Points
Inner Joins
Introduction to Joins
Inner Joins of Two Tables
Variations of the Join Condition
Applications of Joins
Key Points
Outer Joins
Introduction to Outer Joins
Applications of Outer Joins
Key Points
Union and Union All
Union Basics
Unconventional Unions
Applications of a Union
Set Intersection and Set Difference in Oracle
Key Points
Cross Joins, Self Joins, and Cross Tab Queries
Cross Joins
Self Joins
Cross Tab Queries in Access
Cross Tab Queries in Oracle
Key Points
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
If-Then-Else, Parameter Queries, and Subqueries
If-Then-Else Logic

×
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.

×