- Shopping Bag ( 0 items )
Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. A companion web site contains thousands of lines of code that you can put to use immediately. The book consists of four major sections: Stored programming fundamentals-tutorial, using SQL in stored programs, and error handling, Building MySQL stored programs-transactions, built-in functions, stored functions, and triggers, MySQL stored programs in applications-using stored programs with PHP, Perl, Python, Java, and .NET (C# and VB.NET), Optimizing MySQL stored programs-security, basic and advanced SQL tuning, optimization of stored program code, and programming best practices.
Few in the MySQL world have substantial experience with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise. Guy is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on database technologies. Steven is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming. Between them, they have authored a dozen books.
|1||Introduction to MySQL stored programs||3|
|2||MySQL stored programming tutorial||20|
|4||Blocks, conditional statements, and iterative programming||77|
|5||Using SQL in stored programming||99|
|7||Creating and maintaining stored programs||159|
|9||MySQL built-in functions||205|
|12||Using MySQL stored programs in applications||261|
|13||Using MySQL stored programs with PHP||275|
|14||Using MySQL stored programs with Java||309|
|15||Using MySQL stored programs with Perl||343|
|16||Using MySQL stored programs with Python||364|
|17||Using MySQL stored programs with .NET||386|
|18||Stored program security||421|
|19||Tuning stored programs and their SQL||442|
|20||Basic SQL tuning||463|
|21||Advanced SQL tuning||486|
|22||Optimizing stored program code||508|
|23||Best practices in MySQL stored program development||533|
Posted October 7, 2006
Are you a MySQL programmer? If you are, then this book is for you. Authors Guy Harrison and Steven Feuerstein, have done an outstanding job of writing a book that will help MySQL practitioners realize the full potential of MySQL stored programs. Harrison and Feuerstein, begin by introducing the MySQL stored program language and provide a detailed description of the language structure and usage. Then, the authors describe how you can use the MySQL elements to build functional and useful store programs. The authors then show you how to use the stored programs within applications. Finally, they show you how to get programs to work correctly by making them perform efficiently, robust and secure, and be easily maintained. This most excellent book describes the stored program language introduced in MySQL 5.0. More importantly, this book will help you get the job done!!
1 out of 1 people found this review helpful.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted April 1, 2013
Posted April 2, 2013