It's Raining Books Sale
 
 

Recently Viewed clear list


Original Essays | September 15, 2014

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »
  1. $18.19 Sale Hardcover add to wish list

    Juliet's Nurse

    Lois Leveen 9781476757445

spacer
Qualifying orders ship free.
$1.75
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- General

Other titles in the Sams Teach Yourself...in 24 Hours series:

Sams Teach Yourself MySQL in 24 Hours (Sams Teach Yourself...in 24 Hours)

by

Sams Teach Yourself MySQL in 24 Hours (Sams Teach Yourself...in 24 Hours) Cover

 

Synopses & Reviews

Publisher Comments:

Sams Teach Yourself MySQL in 24 Hours teaches the reader everything from basic installation to using MySQL in Web application development.

First, the basic concepts of database design are taught, and then the reader jumps right into planning and creating a database. The book then walks the reader through all the basics of using MySQL - working with tables and data, using MySQL's query functions, using transactions, and database administration - before the reader finally learns to put everything together to properly create the foundation database for a Web-based application.

Synopsis:

This is a concise, well-structured guide to learning MySQL from the ground up. All the latest features of MySQL are covered, including transactions.

About the Author

Julie Meloni is the technical director for i2i Interactive, a multimedia company located in Campbell, CA (that's just down the street from San Jose). She's been developing Web-based applications since the Web first saw the light of day and remembers the excitement surrounding the first GUI Web browser. She is the author of several books and articles on Web-based programming languages and database topics, and you can find translations of her work in several languages, including Chinese, Italian, Portuguese, and Polish.

Table of Contents

(NOTE: Each chapter concludes with a Summary, Q&A, and Workshop.)

Introduction.

I. INTRODUCTION TO MYSQL AND RELATIONAL DATABASES.

Hour 1. Introducing MySQL.

What Is a Relational Database? What Is MySQL? Communicating with MySQL.
Hour 2. Understanding Database Terminology.

Basic Elements Explained.
Hour 3. Learning the Database Design Process.

The Importance of Good Database Design. Types of Table Relationships. Understanding Normalization. Following the Design Process.

II. SETTING UP YOUR ENVIRONMENT.

Hour 4. Using the MySQL Client.

Working with the MySQL Command-Line Interface. Working with the MySQL Administration Tools. Other Interfaces to MySQL.
Hour 5. Securing MySQL.

Basic Security Guidelines. Introducing the MySQL Privilege System. Working with User Provileges.

III. LEARNING TO PLAN FOR YOUR DATABASE-DRIVEN APPLICATIONS.

Hour 6. Planning and Creating Your Database.

Determine Your Goals. Conceptualize the Tables. Creating the Database.
Hour 7. Creating Your Database Tables-Part I.

Learning the MySQL Data Types. Learning the Table Creation Syntax.
Hour 8. Creating Your Database Tables-Part II.

Identifying Keys in Your Tables. Adding Indexes to Your Tables. When to Use, or Not to Use, Keys and Indexes. Finalizing Your Table Creation Statements. Issuing Your Table Creation Statements.

IV. WORKING WITH YOUR TABLES.

Hour 9. Populating Your Database Tables.

Using the INSERT Command. Importing Data from Other Databases.
Hour 10. Selecting Data from Your Tables.

Using the SELECT Command. Using WHERE in Your Queries. Using Operators in WHERE Clauses. String Comparison Using LIKE.
Hour 11. Advanced Usage of SELECT Statements.

Using the GROUP BY Clause. Using SELECT Within INSERT Statements. Selecting from Multiple Tables. Using JOIN.
Hour 12. Modifying and Deleting Data.

Using the UPDATE Command to Modify Records. Using the REPLACE Command. Using the DELETE Command.
Hour 13. More About DELETE.

Deleting Related Records. Listing Tables and Databases Before Deleting Them. Using the DROP Command.
Hour 14. Modifying Table Structure.

Using DESCRIBE to View Table Structure. Renaming Tables. Using the ALTER Command.

V. USING BUILT-IN FUNCTIONS IN MYSQL QUERIES.

Hour 15. Using MySQL String Functions.

Frequently Used String Functions. Obscure String Functions.
Hour 16. Using MySQL Numeric Functions.

Using Numeric Functions in Queries.
Hour 17. Using MySQL Date and Time Functions.

Using Date and Time Functions in Queries. Formatting Dates and Times. Performing Date Arithmetic. Special Functions and Conversion Features.

VI. USING TRANSACTIONS.

Hour 18. Transactions Overview.

What Are Transactions? Transaction-Safe Table Types in MySQL.
Hour 19. Practical Transaction Usage.

Converting Tables to Transaction-Safe Table Types. Using Transactions in Your Applications.

VII. ADMINISTERING YOUR MYSQL SERVER.

Hour 20. Optimizing and Tuning Your Database.

Building an Optimized Platform. MySQL Startup Options. Optimizing Your Table Structure. Optimizing Your Queries.
Hour 21. Backing Up and Restoring Your Database.

Database Backup Overview. Using mysqlhotcopy. Using the BACKUP TABLE and RESTORE TABLE Commands. Using myisamchk.
Hour 22. Basic Administrative Commands.

Using the FLUSH Command. Using the SHOW Command.

VIII. INTERFACING WITH MYSQL.

Hour 23. Using MySQL with Perl.

Getting Access to Perl. Connecting to MySQL with Perl. Executing Queries. Working with MySQL Data.
Hour 24. Using MySQL with PHP.

Getting Access to PHP. How PHP Works. Connecting to MySQL with PHP. Working with MySQL Data.

IX. APPENDICES.

Appendix A. Installing MySQL.

How to Get MySQL. Installing MySQL 3.23 or 4.0 on Windows. Installing MySQL 3.23 or 4.0 on Linux/UNIX. Troubleshooting Your Installation.
Appendix B. Using MyODBC.

Installing MyODBC on Windows. Configuring MyODBC. Importing/Exporting Data with MysQL and Microsoft Access.
Appendix C. Reserved Words.

Appendix D. Practical MySQL/PHP Examples.

Creating Access Logs and Reports. Creating an Online Poll. Storing Uploaded Files in Your Database. Retrieving Images Files from Your Database.
Index.

Product Details

ISBN:
9780672323492
Author:
Meloni, Julie C.
Publisher:
Sams
Author:
Meloni, Julie
Author:
Meloni, Julie C.
Location:
Indianapolis, Ind.
Subject:
Database Management - General
Subject:
Database management
Subject:
Client-server computing
Subject:
Sql (computer program language)
Subject:
SQL
Subject:
MySQL
Subject:
Client-Server Computing - General
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Sams Teach Yourself ... in 24 Hours
Series Volume:
no. 00-4540S
Publication Date:
April 2002
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
368
Dimensions:
9.08x7.42x.83 in. 1.36 lbs.

Other books you might like

  1. Magnitude 8 Used Trade Paper $5.95
  2. Sams Teach Yourself C++ in 24 Hours... Used Trade Paper $15.00

Related Subjects

Computers and Internet » Database » Client Server
Computers and Internet » Database » Design
Computers and Internet » Database » General
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Sams Teach Yourself MySQL in 24 Hours (Sams Teach Yourself...in 24 Hours) Used Trade Paper
0 stars - 0 reviews
$1.75 In Stock
Product details 368 pages Sams - English 9780672323492 Reviews:
"Synopsis" by , This is a concise, well-structured guide to learning MySQL from the ground up. All the latest features of MySQL are covered, including transactions.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.