Pro MySQL by Jay Pipes, Michael Kruckenberg

Pro MySQL



Download Pro MySQL




Pro MySQL Jay Pipes, Michael Kruckenberg
Language: English
Page: 769
Format: pdf
ISBN: 159059505X, 9781590595053
Publisher: Apress

Pro MySQL

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or you’re a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examples—from dealing with hierarchical data to performing Geographic Information System (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.

The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.

About the Author

Michael Kruckenberg

Michael Kruckenberg started his career with web technologies more than 10 years ago. His first major undertaking was bringing a small mail-order company online (using MySQL). After hopping around a bit during the 1990s Internet boom and spending time in the Internet startup world, Mike put his feet down at his current gig, senior programmer at Tufts University. He is now the technical manager for the Apache/Perl/MySQL-driven Tufts University Sciences Knowledgebase (TUSK), a content repository for faculty and students. Mike likes to spend his elusive free time with his wife and kids on New England adventures, has a healthy addiction to music, and likes to dabble in the arts (photography, video, and literature).

Jay Pipes

For the past 10 years, Jay Pipes has worked with all kinds of companies, large and small, to identify the value of the information they collect and help them build software that best addresses the needs of their businesses. From e-commerce to work-order management systems, Jay has been involved in projects with both Microsoft and open-source technologies. Passionate about programming and all things technical, Jay now runs his own consulting business, based in Columbus, Ohio. When not being bothered by his two cats, two dogs, and a constantly ringing phone, you can find him, headphones pulled across his ears, happily coding away at home.

MORE EBOOKS:
Out of Order: An incisive and boldly original critique of the news media's domination of America's political Process download pdf
Rebel Fay ebook download
Standard Handbook of Chains: Chains for Power Transmission and Material Handling (Mechanical Engineering (Marcell Dekker): A Series of Textbooks and Reference Books) pdf download







Tags: Pro MySQL ebook pdf djvu epub
Pro MySQL download pdf epub djvu
Download Pro MySQL free ebook pdf
Read Pro MySQL online book
Pro MySQL cheap ebook for kindle and nook
Pro MySQL download book
Jay Pipes, Michael Kruckenberg ebooks
Pro MySQL download pdf rapidshare mediafire fileserve 4shared torrent