MySQL Crash Course

ISBN-10: 0672327120
ISBN-13: 9780672327124
Edition: 2006
Authors: Ben Forta
List price: $34.99 Buy it from $7.80
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: Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't.Sams  More...

Used Starting from $17.67
New Starting from $26.74
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

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: $34.99
Copyright year: 2006
Publisher: Pearson Education
Publication date: 12/12/2005
Binding: Paperback
Pages: 336
Size: 5.50" wide x 8.25" long x 0.75" tall
Weight: 1.100
Language: English

Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't.Sams Teach Yourself MySQL in 10 Minutes is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to: Use the MySQL toolset Retrieve and sort data Filter data using comparisons, wildcards, and full text searching Use the aggregate functions to analyze data Perform insert, update, and delete operations Join relational tables using inner, outer, and self joins Combine queries using unions Use views Create, and modify tables, and access table schemas Create and use stored procedures, cursors, and other advanced database features Manage databases, users, and security privileges

Introduction
Who Is This Book For?
Companion Website
Conventions Used in This Book
Understanding SQL
Database Basics
What Is SQL?
Try It Yourself
Introducing MySQL
What Is MySQL?
MySQL Tools
Working with MySQL
Making the Connection
Selecting a Database
Learning About Databases and Tables
Retrieving Data
The SELECT Statement
Retrieving Individual Columns
Retrieving Multiple Columns
Retrieving All Columns
Retrieving Distinct Rows
Limiting Results
Using Fully Qualified Table Names
Sorting Retrieved Data
Sorting Data
Sorting by Multiple Columns
Specifying Sort Direction
Filtering Data
Using the WHERE Clause
The WHERE Clause Operators
Advanced Data Filtering
Combining WHERE Clauses
Using the IN Operator
Using the NOT Operator
Using Wildcard Filtering
Using the LIKE Operator
Tips for Using Wildcards
Searching Using Regular Expressions
Understanding Regular Expressions
Using MySQL Regular Expressions
Creating Calculated Fields
Understanding Calculated Fields
Concatenating Fields
Performing Mathematical Calculations
Using Data Manipulation Functions
Understanding Functions
Using Functions
Summarizing Data
Using Aggregate Functions
Aggregates on Distinct Values
Combining Aggregate Functions
Grouping Data
Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering
Working with Subqueries
Understanding Subqueries
Filtering by Subquery
Using Subqueries As Calculated Fields
Joining Tables
Understanding Joins
Creating a Join
Creating Advanced Joins
Using Table Aliases
Using Different Join Types
Using Joins with Aggregate Functions
Using Joins and Join Conditions
Combining Queries
Understanding Combined Queries
Creating Combined Queries
Full-Text Searching
Understanding Full-Text Searching
Using Full-Text Searching
Inserting Data
Understanding Data Insertion
Inserting Complete Rows
Inserting Multiple Rows
Inserting Retrieved Data
Updating and Deleting Data
Updating Data
Deleting Data
Guidelines for Updating and Deleting Data
Creating and Manipulating Tables
Creating Tables
Updating Tables
Deleting Tables
Renaming Tables
Using Views
Understanding Views
Using Views
Working with Stored Procedures
Understanding Stored Procedures
Why Use Stored Procedures
Using Stored Procedures
Using Cursors
Understanding Cursors
Working with Cursors
Using Triggers
Understanding Triggers
Creating Triggers
Dropping Triggers
Using Triggers
Managing Transaction Processing
Understanding Transaction Processing
Controlling Transactions
Globalization and Localization
Understanding Character Sets and Collation Sequences
Working with Character Set and Collation Sequences
Managing Security
Understanding Access Control
Managing Users
Database Maintenance
Backing Up Data
Performing Database Maintenance
Diagnosing Startup Problems
Review Log Files
Improving Performance
Improving Performance
Getting Started with MySQL
What You'll Need
Obtaining the Software
Installing the Software
Preparing for Your Chapters
The Example Tables
Understanding the Sample Tables
Creating the Sample Tables
MySQL Statement Syntax
ALTER TABLE
COMMIT
CREATE INDEX
CREATE PROCEDURE
CREATE TABLE
CREATE USER
CREATE VIEW
DELETE
DROP
INSERT
INSERT SELECT
ROLLBACK
SAVEPOINT
SELECT
START TRANSACTION
UPDATE
MySQL Datatypes
String Datatypes
Numeric Datatypes
Date and Time Datatypes
Binary Datatypes
MySQL Reserved Words
Index

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

×