SQL For Web Developers, Programmers and Students

ISBN-10: 1840785438

ISBN-13: 9781840785432

Edition: 3rd 2012

Authors: Mike McGrath

List price: $10.99 Buy it from $3.00
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


Used Starting from $9.85
New Starting from $13.54
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
Periodic Table Online content $4.95 $1.99
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
Customers also bought

Book details

List price: $10.99
Edition: 3rd
Copyright year: 2012
Publisher: Computer Step
Publication date: 5/3/2012
Binding: Paperback
Pages: 192
Size: 7.25" wide x 9.00" long x 0.50" tall
Weight: 0.946
Language: English

Introducing SQL
What is SQL?
Making SQL queries
Installing MySQL on Windows
Installing MySQL on Linux
Installing an ODBC driver
Using Microsoft Query tool
Getting started
Introducing databases
Exploring databases
Creating a databases
Deleting a databases
Running SQL scripts
Creating database tables
Exploring database tables
Creating a table
Deleting a table
Table data types
Table field modifiers
Setting the primary key
Altering a table
Inserting data into tables
Inserting complete rows
Including a columns list
Inserting selected data
Updating data
Changing specific data
Deleting data
Retrieving data from tables
Retrieving a column
Retrieving multiple columns
Retrieving a row
Copying retrieved data
Inserting selected fields
Sorting retrieved data
Sorting a column
Sorting multiple columns
Sorting by column position
Setting the sort direction
Simple data filtering
Making comparisons
Comparing a single value
Comparing a range of values
Seeking non-matches
Finding null values
Complex data filtering
Comparing multiple values
Comparing alternative values
Comparing alternative lists
Specifying evaluation order
Matching strings
Matching characters
Matching regular expressions
Generating calculated fields
Concatenating fields
Trimming padded spaces
Adopting aliases
Doing arithmetic
Manipulating data
Introducing functions
Text functions
Numeric functions
Date and time functions
System functions
Grouping table data
Finding summary values
Counting rows
Discovering total values
Working with distinct values
Creating data groups
Filtering grouped data
Sorting filtered group data
Making complex queries
Using sub-queries
Sub-query calculated fields
Combining queries
Handling duplicate rows
Sorting combined results
Joining database tables
What are joins?
Creating a join
Joining multiple tables
Creating self joins
Creating natural joins
Creating outer joins
Handy reference
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.