ISBN-10: 0071548645

ISBN-13: 9780071548649

Edition: 3rd 2009

Authors: Andy Oppel, Robert Sheldon

List price: $42.00 Buy it from $2.59
eBook available
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


New Starting from $32.29
eBooks Starting from $42.00
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
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
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
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

Book details

List price: $42.00
Edition: 3rd
Copyright year: 2009
Publisher: McGraw-Hill Osborne
Publication date: 8/29/2008
Binding: Paperback
Pages: 534
Size: 7.50" wide x 9.00" long x 1.25" tall
Weight: 1.210
Language: English

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified .Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases

Relational Databases and SQL
Introduction to Relational Databases and SQL
Understand Relational Databases
The Relational Model
Learn About SQL
The SQL Evolution
Types of SQL Statements
Types of Execution
SQL Standard versus Product Implementations
Working with the SQL Environment
Understand the SQL Environment
Understand SQL Catalogs
Schema Objects
Then What Is a Database?
Name Objects in an SQL Environment
Qualified Names
Create a Schema
Create a Database
Creating and Altering Tables
Create SQL Tables
Specify Column Data Types
String Data Types
Numeric Data Types
Datetime Data Types
Interval Data Type
Boolean Data Type
Using SQL Data Types
Create User-Defined Types
Specify Column Default Values
Delete SQL Tables
Enforcing Data Integrity
Understand Integrity Constraints
Use NOT NULL Constraints
Add UNIQUE Constraints
Add PRIMARY KEY Constraints
Add FOREIGN KEY Constraints
The MATCH Clause
The [left angle bracket]referential triggered action[right angle bracket] Clause
Define CHECK Constraints
Defining Assertions
Creating Domains and Domain Constraints
Creating SQL Views
Add Views to the Database
Defining SQL Views
Create Updateable Views
Using the WITH CHECK OPTION Clause
Drop Views from the Database
Managing Database Security
Understand the SQL Security Model
SQL Sessions
Accessing Database Objects
Create and Delete Roles
Grant and Revoke Privileges
Revoking Privileges
Grant and Revoke Roles
Revoking Roles
Data Access and Modification
Querying SQL Data
Use a SELECT Statement to Retrieve Data
The SELECT Clause and FROM Clause
Use the WHERE Clause to Define Search Conditions
Defining the WHERE Clause
Use the GROUP BY Clause to Group Query Results
Use the HAVING Clause to Specify Group Search Conditions
Use the ORDER BY Clause to Sort Query Results
Modifying SQL Data
Insert SQL Data
Inserting Values from a SELECT Statement
Update SQL Data
Updating Values from a SELECT Statement
Delete SQL Data
Using Predicates
Compare SQL Data
Using the BETWEEN Predicate
Return Null Values
Return Similar Values
Reference Additional Sources of Data
Using the IN Predicate
Using the EXISTS Predicate
Quantify Comparison Predicates
Using the SOME and ANY Predicates
Using the ALL Predicate
Working with Functions and Value Expressions
Use Set Functions
Using the COUNT Function
Using the MAX and MIN Functions
Using the SUM Function
Using the AVG Function
Use Value Functions
Working with String Value Functions
Working with Datetime Value Functions
Use Value Expressions
Working with Numeric Value Expressions
Using the CASE Value Expression
Using the CAST Value Expression
Use Special Values
Accessing Multiple Tables
Perform Basic Join Operations
Using Correlation Names
Creating Joins with More than Two Tables
Creating the Cross Join
Creating the Self-Join
Join Tables with Shared Column Names
Creating the Natural Join
Creating the Named Column Join
Use the Condition Join
Creating the Inner Join
Creating the Outer Join
Perform Union Operations
Using Subqueries to Access and Modify Data
Create Subqueries That Return Multiple Rows
Using the IN Predicate
Using the EXISTS Predicate
Using Quantified Comparison Predicates
Create Subqueries That Return One Value
Work with Correlated Subqueries
Use Nested Subqueries
Use Subqueries to Modify Data
Using Subqueries to Insert Data
Using Subqueries to Update Data
Using Subqueries to Delete Data
Advanced Data Access
Creating SQL-Invoked Routines
Understand SQL-Invoked Routines
SQL-Invoked Procedures and Functions
Working with the Basic Syntax
Create SQL-Invoked Procedures
Invoking SQL-Invoked Procedures
Add Input Parameters to Your Procedures
Using Procedures to Modify Data
Add Local Variables to Your Procedures
Work with Control Statements
Create Compound Statements
Create Conditional Statements
Create Looping Statements
Add Output Parameters to Your Procedures
Create SQL-Invoked Functions
Creating SQL Triggers
Understand SQL Triggers
Trigger Execution Context
Create SQL Triggers
Referencing Old and New Values
Dropping SQL Triggers
Create Insert Triggers
Create Update Triggers
Create Delete Triggers
Using SQL Cursors
Understand SQL Cursors
Declaring and Opening SQL Cursors
Declare a Cursor
Working with Optional Syntax Elements
Creating a Cursor Declaration
Open and Close a Cursor
Retrieve Data from a Cursor
Use Positioned UPDATE and DELETE Statements
Using the Positioned UPDATE Statement
Using the Positioned DELETE Statement
Managing SQL Transactions
Understand SQL Transactions
Set Transaction Properties
Specifying an Isolation Level
Specifying a Diagnostics Size
Creating a SET TRANSACTION Statement
Start a Transaction
Set Constraint Deferability
Create Savepoints in a Transaction
Releasing a Savepoint
Terminate a Transaction
Committing a Transaction
Rolling Back a Transaction
Accessing SQL Data from Your Host Program
Invoke SQL Directly
Embed SQL Statements in Your Program
Creating an Embedded SQL Statement
Using Host Variables in Your SQL Statements
Retrieving SQL Data
Error Handling
Create SQL Client Modules
Defining SQL Client Modules
Use an SQL Call-Level Interface
Allocating Handles
Executing SQL Statements
Working with Host Variables
Retrieving SQL Data
Working with XML Data
Learn the Basics of XML
Learn About SQL/XML
The XML Data Type
SQL/XML Functions
SQL/XML Mapping Rule
Answers to Self Test
SQL:2006 Keywords
SQL Reserved Keywords
SQL Nonreserved Keywords
SQL Code Used in Try This Exercises
SQL Code by Try This Exercise
The INVENTORY Database
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.