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.
Topics: Understanding MySQL Installation MySQL fundamentals storage engines basic SQL Techniques MySQL with Inter.NET Based Middleware PHP using Apache Web Server MySQLs Graphical Database Management Tools php MyAdmin 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
About The Author
The author Ivan Bayross is an M.Tech in DBMS from Manchester University UK. He has spent more than 30 years in the software industry. He rose from the ranks in the IT industry, where he started as a programmer, moved up to C.I.O and is now the Chairman and Technology lead, in a software development house at Mumbai, India. He specializes in multi-tier, client/server, application development.
