Sams Teach Yourself MySQL in 10 Minutes

ISBN-10: 0672328631
ISBN-13: 9780672328633
Edition: 2006
Authors: Chris Newman
List price: $24.99 Buy it from $2.98
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: Now at over 5 million downloads and widely used at all levels, MySQL continues to grow in popularity. Readers are hungry for a concise, easily accessible tutorial on MySQL basics that allows them to get up and running quickly. While there are many  More...

Used Starting from $2.98
New Starting from $20.14
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
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

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $24.99
Copyright year: 2006
Publisher: Pearson Education
Publication date: 5/9/2006
Binding: Paperback
Pages: 288
Size: 5.50" wide x 8.25" long x 0.75" tall
Weight: 0.682
Language: English

Now at over 5 million downloads and widely used at all levels, MySQL continues to grow in popularity. Readers are hungry for a concise, easily accessible tutorial on MySQL basics that allows them to get up and running quickly. While there are many MySQL books on the market, there are no up-to-date books that meet this need for the reader. Furthermore, sales of MySQL books clearly shows the need for a concise, handy tutorial versus the more bulky introductions to MySQL. Sams Teach Yourself MySQL in 10 Minutes provides a no-fluff, just-the-answers guide to building and managing MySQL databases.

Introduction
MySQL Foundations
Introducing MySQL
Database Basics
About MySQL AB and mysql.com
MySQL Components
Summary
Using MySQL
The mysql Client
Executing SQL Statements
Creating the Sample Tables
Summary
Getting Started with SQL
Retrieving Data
The Select Statement
Retrieving Database Information
Summary
Filtering and Sorting Data
The Where Clause
The Order By Clause
Summary
Advanced Data Filtering
Combining Where Clauses
Limiting the Number of Rows Returned
Summary
Numeric Operators and Functions
Numeric Operators
Numeric Functions
Conditional Functions
Summary
String Operators and Functions
Using Operators with Strings
String Functions
Summary
Date Operators and Functions
Date Operators
Date Functions
Summary
Summarizing Data
Aggregate Functions
Grouping Data
Filtering Summary Data
Summary
Advanced SQL
Using Subqueries
Understanding Subqueries
Summary
Joining Tables
Understanding Joins
Summary
Creating Advanced Joins
The Join Keyword
Inner Joins
Joining Multiple Tables
Cross Joins
Self-Joins
Natural Joins
Outer Joins
Summary
Combining Queries
Understanding Combined Queries
Other Compound Operations
Using Temporary Tables
Summary
Creating a New Database
Creating and Modifying Tables
Creating a New Database
Character Sets and Collations
Altering a Database
Dropping a Database
Managing Tables
Temporary Tables
Using a Query to Create a Table
Storage Engines
Altering Tables
Dropping Tables
Summary
Working with Data
The Insert Statement
The Delete Statement
The Update Statement
The Replace Statement
Loading Data from a File
Why Use Transactions?
Transactions in MySQL
Autocommit Mode
Rolling Back a Transaction
Summary
Designing Your Database
Relationships
Normalization
Naming Tables and Columns
Data Types
Summary
Keys and Indexes
Understanding Keys and Indexes
Using Indexes in MySQL
Summary
Managing User Access
Understanding MySQL Authentication
User Management
Using Wildcards
Summary
New Features in MySQL 5.0
Views
Understanding Views
Summary
Stored Routines
Understanding Stored Routines
Summary
Triggers
Understanding Triggers
Summary
Interfacing with MySQL
Using ODBC
Understanding ODBC
Connecting to MyODBC
Summary
Using MySQL with C
The C Language API
Summary
Using MySQL with PHP
Using the mysql API
Using the mysqli API
Summary
Using MySQL with Perl
The Perl DBI
Using the MySQL DBD
Summary
Appendixes
Installing MySQL
Obtaining MySQL
Linux/UNIX Installation
Windows Installation
Sample Table Scripts

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

×