Free! - Mini-review and Win a copy of MySQL Basics for Visual Learners

This book helps non-programmers learn the basics of MySQL. As usual with books from Visibooks, many screenshots and graphics show how to:

        • Administer databases: Back up, delete, restore databases, delete tables.
        • Work with tables: Alter tables, update records, delete records.
        • Perform queries: Create queries, sort results, add criteria.
        • Secure databases: Add and remove users, restrict access.
        • Web-enable databases: Use programming commands, join two tables, employ online forms.
        • Administering Databases: Delete a table, Back up, delete and restore a database.

MySQL Basics For Visual Learners is a book that teaches you the very first basics of MySQL, the way of doing that is by using a great amount of images and pictures. The graphics and visualizations enable you to "scan" trough the book and zoom in to the topics you like. Although it allows you to go trough the lessons very fast, the information takes up a lot of space so your thick book (168 pages) does contain less information then a standard book format.

For who is this book? This book will teach you the very basics of MySQL, and is therefore best suited for users that make a first start with MySQL. Again, the visuals will help those to pick up methods in this program very easily.

The book covers basic topics such as Instalation, Queries, Managing Databases, Security, Tables and PERL/CGI.

MySQL Basics competition! The friendly people of Visibooks are giving away 6 e-books. All you need to do to enter the competition is to download the extract (press read more and then download sample pdf on your right), which is all about MySQL and answer the following question:

  • What is the name of the new database created in chapter 2?

Send your answer to this e-mail address before Thursday 31th of March 2005.

Good Luck!

Overview

Table of Contents:
MySQL Basics for Visual Learners

Getting Started
Install MySQL on a Linux computer
Start MySQL
Create a new database
Create a table
Create a record
Run a query

Administering Databases
Restart MySQL
Back up a database
Delete a table
Delete a database
Restore a database

Working with Tables
Alter tables
Update records
Delete records

Running Queries
Sort query results
Add query criteria

Securing a Database
Add a local user
Add a remote user
Remove a user
Restrict a user

Web-enabling Databases
Perform a query using PERL
Join two tables using PERL
Create a CGI script
Write a query in a CGI script

Comments

Be the first to write a comment

You must me logged in to write a comment.