Sams Teach Yourself MySQL in 10 Minutes

Name: Sams Teach Yourself MySQL in 10 Minutes
Price: 6.53 USD
Availability: InStock
ISBN: 9780672328633

ISBN-10: 0672328631

ISBN-13: 9780672328633

Edition: 2006

Authors: Chris Newman

List price: $24.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $6.53

what's this?

Rush Rewards U
Members Receive:

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

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

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



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