

MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL (Paperback)
Key item features
Specs
Author, Guy Harrison; Steven Feuerstein
Book format, Paperback
Genre, Computing & Internet
Pages, 636
Age group, Adult
About this item
Product details
The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.
In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.
MySQL's new procedural language has a straightforward syntax, making it easy to write simple programs. But it's not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.
In MySQL Stored Procedure Programming, they put that hard-won experience to good use. 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. It consists of four major sections:- MySQL stored programming fundamentals -- tutorial, basic statements, SQL in stored programs, and error handling
- Building MySQL stored programs -- transaction handling, built-in functions, stored functions, and triggers
- MySQL stored programs in applications -- using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
- Optimizing MySQL stored programs -- security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices
A companion web site contains many thousands of lines of code, that you can put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
Specifications
Publication date
Author
Book format
Genre
Warranty
Warranty information
Warnings
Similar items you might like
Top 30 SQL Interview Coding Tasks $18.99
$1899current price $18.99Top 30 SQL Interview Coding Tasks
Expert's Voice in Open Source: Pro Drupal Development (Paperback) $39.40
$3940current price $39.40Expert's Voice in Open Source: Pro Drupal Development (Paperback)
Relational Database Programming: A Set-Oriented Approach, (Paperback) $37.36
$3736current price $37.36Relational Database Programming: A Set-Oriented Approach, (Paperback)
Learn SQL Learn SQL by Examples: Examples of SQL Queries and Stored Procedures for MySQL and Oracle, Book 1, (Paperback) $10.99
$1099current price $10.99Learn SQL Learn SQL by Examples: Examples of SQL Queries and Stored Procedures for MySQL and Oracle, Book 1, (Paperback)
Programming: C Programming Success in a Day & MySQL Programming Professional Made Easy (Paperback) $9.20
$920current price $9.20Programming: C Programming Success in a Day & MySQL Programming Professional Made Easy (Paperback)
Pre-Owned PHP Programming with MySQL: The Web Technologies Series, 9780538745840, 0538745843, Paperback, 2 edition $30.74
2 optionsAvailable in additional 2 options$3074current price $30.74Pre-Owned PHP Programming with MySQL: The Web Technologies Series, 9780538745840, 0538745843, Paperback, 2 edition
Create Rapid Web Application in Oracle Application Express 19: A platform to develop stunning, scalable data-centric web, (Paperback) $32.67
$3267current price $32.67Create Rapid Web Application in Oracle Application Express 19: A platform to develop stunning, scalable data-centric web, (Paperback)
Oracle PL/SQL for DBAs: Security, Scheduling, Performance & More (Paperback) $32.35
$3235current price $32.35Oracle PL/SQL for DBAs: Security, Scheduling, Performance & More (Paperback)
SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle (Paperback) $16.56
$1656current price $16.56SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle (Paperback)
MySQL 9 QuickStart Pro: Administrative strategies to upgrade, migrate and optimize databases with MySQL 9, (Paperback) $29.99
$2999current price $29.99MySQL 9 QuickStart Pro: Administrative strategies to upgrade, migrate and optimize databases with MySQL 9, (Paperback)
Dbms, Mysql, Data Analysis: Experiment Database View, (Paperback) $10.00
$1000current price $10.00Dbms, Mysql, Data Analysis: Experiment Database View, (Paperback)
Getting Started with SQL and Database Design: A Beginner's Guide to Databases and SQL Queries, (Paperback) $19.99
$1999current price $19.99Getting Started with SQL and Database Design: A Beginner's Guide to Databases and SQL Queries, (Paperback)
The Practical Database Engineer Mastering MySQL: From Tables to Transactions - Building Databases the Practical Way, Book 1, (Paperback) $22.00
$2200current price $22.00The Practical Database Engineer Mastering MySQL: From Tables to Transactions - Building Databases the Practical Way, Book 1, (Paperback)
An Integer Programming Procedure for Assembly System Design Problems, (Paperback) $13.95
$1395current price $13.95An Integer Programming Procedure for Assembly System Design Problems, (Paperback)
For Beginners (For Beginners) Advanced SQL for Beginners: Master Complex Queries, Joins, Subqueries, and Stored Procedures for Database Management, (Paperback) $14.99
$1499current price $14.99For Beginners (For Beginners) Advanced SQL for Beginners: Master Complex Queries, Joins, Subqueries, and Stored Procedures for Database Management, (Paperback)
PostgreSQL 18 with Python for Beginners: Build Real-World Database Applications, Master SQL, and Develop Production-Read, (Paperback) $27.77
$2777current price $27.77PostgreSQL 18 with Python for Beginners: Build Real-World Database Applications, Master SQL, and Develop Production-Read, (Paperback)
PostgreSQL 18 for Beginners: Build Real-World Database Projects Using SQL, JSON, and Python, (Paperback) $17.27 Was $26.00
$1727current price $17.27, Was $26.00$26.00PostgreSQL 18 for Beginners: Build Real-World Database Projects Using SQL, JSON, and Python, (Paperback)
Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012 (Paperback) $29.95
$2995current price $29.95Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012 (Paperback)
Expert's Voice in SQL Server Pro SQL Server 2008 Relational Database Design and Implementation, (Paperback) $25.32 Was $41.11
$2532current price $25.32, Was $41.11$41.11Expert's Voice in SQL Server Pro SQL Server 2008 Relational Database Design and Implementation, (Paperback)
MS Access 2013 Pure SQL: Real, Power-Packed Solutions For Business Users, Developers, And The Rest Of Us (Paperback) $24.58
$2458current price $24.58MS Access 2013 Pure SQL: Real, Power-Packed Solutions For Business Users, Developers, And The Rest Of Us (Paperback)
Customer ratings & reviews
- Free shipping
Free Holiday returns until Jan 31
How do you want your item?
Related pages
- Best Sellers In HTML Programming
- Algorithms Java
- Best Sellers In Books PHP Programming
- Best Sellers In Programming Web Development
- Html Dummies
- Excel Table Format
- Project Management Books
- Spreadsheets Books
- Project Management Software Books
- Windows Administration Books
- Collaboration Software Books
- Computer & Internet Law Books
