Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9922 6266 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 Nepean TAFE 2012
I.T
 .NET
 Windows 7
 Adobe CS5
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Linux
 Windows Server 2008
 SAP
 Sharepoint 2010
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical

MySQL Tutorial

by: Luke Welling ; Laura Thomson

Notify me when in stock

On-line Price: $45.95 (includes GST)

Paperback package 288

20%Off Retail Price

You save: $11.00

TBA - Subject to Change. Price/availability/options for all orders will be confirmed by reply email before processing.
_____________________
N.Sydney : On Order (reserve your copy)

Retail Price: $56.95

Publisher: SAMS,2003/11/24

Category: MYSQL & mSQL Level: B/I

ISBN: 0672325845
ISBN13: 9780672325847

Add to Shopping Cart

Features


      The official MySQL Press guide to MySQL--Thoroughly reviewed for accuracy by the creators of MySQL.

Gives students confidence that they are learning from materials that are both accurate and effective.


  Coverage through MySQL 4.1--Reflects the latest MySQL features, including the InnoDB storage engine, improved user privilege management, and more.

Teaches students techniques they will be able to utilize for many years to come.


  Task-oriented, concise, and focused--Delivers efficient, task-oriented coverage of the skills every user needs in order to work professionally with MySQL: installation, configuration, queries, administration, security, and optimization.

Prepares students for the MySQL database challenges they are most likely to encounter, while providing a firm foundation in concepts and techniques they will rely upon constantly.


  --End-of-chapter exercises and review questions--Includes exercises and review questions that can easily be tailored to the needs of specific courses and instructors.

Provides constant feedback and reinforcement to ensure that students understand the material they are learning.


  By two of the worlds leading MySQL experts--Authored by experts with a proven track record of explaining MySQL and related technologies clearly and effectively.

Helps students learn more efficiently, by anticipating their needs and answering their questions.


          Author Bio


      Luke Welling is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. He chooses to use Open Source software whenever practical and evangelizes the advantages of this approach as widely as possible. He has spoken to audiences in Australia, North America, and Europe about MySQL, PHP, and other Open Source topics. He has taught a wide variety of technical topics to university students and professionals, but he specializes in Internet-related topics.


  Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She has taught a wide variety of courses with a Web and Internet focus and is currently completing a Ph.D. in Web Mining. She speaks at conferences around the globe and has delivered training at organizations as diverse as Ericsson and Lonely Planet. Previously, Laura has worked for Telstra and the Boston Consulting Group. She holds a first-class honors degree in Computer Systems Engineering and a degree (with distinction) in Computer Science. In her spare time, she rides her horses, feeds her menagerie of animals, and occasionally speaks to Luke about something nontechnical.


      

Table of Contents

Introduction.


  I. MySQL Basics.


    1. Installing MySQL.


        2. Quick Tour.


      II. Designing and Creating Databases with MySQL.


    3. Database Design Crash Course.


        4. Creating Databases, Tables and Indexes.


      III. Using MySQL.


    5. Inserting, Deleting, and Updating Data.


        6. Querying MySQL.


        7. Advanced Queries.


        8. Using MySQL Built-in Functions with SELECT.


      IV. MySQL Table Types and Transactions.


    9. Understanding MySQL's Table Types.


      10. Using Transactions with InnoDB Tables.


      V. Administering MySQL.


  11. Managing User Privileges.


      12. Configuring MySQL.


      13. Administering Your Database.


      14. Backup and Disaster Recovery.


      15. Securing Your MySQL Installation.


      16. Replicating Your Database.


      VI. Optimizing MySQL.


  17. Optimizing Your MySQL Server Configuration.


      18. Optimizing Your Database.


      19. Optimizing Your Queries.


      Index.