SQL For Web Developers, Programmers and Students

Name: SQL For Web Developers, Programmers and Students
Price: 2.9 USD
Availability: InStock
ISBN: 9781840785432

ISBN-10: 1840785438

ISBN-13: 9781840785432

Edition: 3rd 2012

Authors: Mike McGrath

List price: $10.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $2.90

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Book details

List price: $10.99
Edition: 3rd
Copyright year: 2012
Publisher: In Easy Steps Limited
Publication date: 6/28/2012
Binding: Paperback
Pages: 192
Size: 7.38" wide x 8.88" long x 0.42" 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


Summary



Getting started


Introducing databases


Exploring databases


Creating a databases


Deleting a databases


Running SQL scripts


Summary



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


Summary



Inserting data into tables


Inserting complete rows


Including a columns list


Inserting selected data


Updating data


Changing specific data


Deleting data


Summary



Retrieving data from tables


Retrieving a column


Retrieving multiple columns


Retrieving a row


Copying retrieved data


Inserting selected fields


Summary



Sorting retrieved data


Sorting a column


Sorting multiple columns


Sorting by column position


Setting the sort direction


Summary



Simple data filtering


Making comparisons


Comparing a single value


Comparing a range of values


Seeking non-matches


Finding null values


Summary



Complex data filtering


Comparing multiple values


Comparing alternative values


Comparing alternative lists


Specifying evaluation order


Matching strings


Matching characters


Matching regular expressions


Summary



Generating calculated fields


Concatenating fields


Trimming padded spaces


Adopting aliases


Doing arithmetic


Summary



Manipulating data


Introducing functions


Text functions


Numeric functions


Date and time functions


System functions


Summary



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


Summary



Making complex queries


Using sub-queries


Sub-query calculated fields


Combining queries


Handling duplicate rows


Sorting combined results


Summary



Joining database tables


What are joins?


Creating a join


Joining multiple tables


Creating self joins


Creating natural joins


Creating outer joins


Summary


Handy reference


Index