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.
Published in 2005
Published by Apress
Author Michael Kruckenberg
ISBN 159059505X Size 7.45MB
SQL Server 2005 T-SQL Recipes
HBase: The Definitive Guide
Database Systems for Advanced Applications
High Performance MySQL
Getting Started with Couchbase Server
Real-life SQL: Learn SQL in 4 weeks with a Step-by-step method
Encyclopedia of Data Warehousing and Mining, Second Edition
Oracle Service Bus 11g Development Cookbook
Microsoft SQL Server 2005 Developer's Guide
Sams Teach Yourself SQL in 10 Minutes (4th Edition)
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Big Data For Dummies(2923)
Introducing Data Science: Big Data, Machin(2133)
Next Generation Databases: NoSQLand Big Da(1706)
Handbook On Big Data Analytics(1703)
Install BigData step by step: Hadoop, HIve(1654)
Beginning SQL Queries: From Novice to Prof(1605)
SQL: SQL Programming For Beginners - The U(1593)
Foundations for Analytics with Python (Ea(1525)
Developing a Java Web Application in a Day(1516)
Making Sense of Data: Designing Effective (1407)
MongoDB in Action, 2 edition(1405)
Getting Started with SQL: A Hands-On Appro(1403)
SQL Programming: Questions and Answers(1369)
Learning Probabilistic Graphical Models in(1304)