| |
The book has been written to provide an excellent grounding to those who wish to learn ANSI SQL using MySQL 5.1.XX. This book also has several illustrative examples, which have a logical link between them.
Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of MySQL has been established.
Learning of SQL is done thought the construction of a Sales Management System. The skills thus developed are strongly firmed up via hands on exercises based on the construction of a Human Resource Management System.
Additionally, exclusive significance is given to new features supported by MySQL 5.1.XX such as Stored Procedures, DB Triggers, Transactions, Cursors, Views, Sub-Queries and so on.
A special section covering data replication implementation using MySQL 5.1.XX is included.
The Topics Covered In The Book:
Understanding MySQL Installation
MySQL Fundamentals
Storage Engines
Basic SQL Techniques
MySQL With Internet Based Middleware
PHP using Apache Web Server
MySQL`s Graphical Database Management Tools
phpMyAdmin
MySQL Data Replication
Managing MySQL Instance
Advanced SQL Techniques
MySQL With Programming Environments
Visual Basic, Java and Gambas
MySQL Query Browser
Defining Users
CD-ROM Contents
Windows and Linux based setup files for the installation procedures covered
Source code for examples in this book
Solutions to the hands on exercises. ISBN 9789350235188
|
| |
Pages : 772
|