Database Learning Classic Books __ Database

 for the MySQL database technology learning, for the first to learn the database should be a good learning pedal, below to share some of the Classics Learning Database books.

"MySQL Technology Insider: SQL Programming"

"MySQL Technology Insider: SQL Programming" is the best-selling book "MySQL Technology Insider: InnoDB Storage Engine" Sister chapter, a profound revelation of MySQL SQL programming in the essence and mystery, Provides good guidance and help for developers and DBAs to use SQL language to solve a variety of MySQL challenges related to development and management.

The book consists of 10 chapters, which comprehensively explores the various methods, techniques and best practices of SQL programming in MySQL. The 1th chapter introduces the concept of SQL programming, the application type of database and SQL Query Analyzer, then introduces three stages of SQL programming, hoping that readers can reach the final fusion stage through the study of this book. The 2nd chapter explains all kinds of data types in MySQL and the corresponding programming problems. The 3rd chapter probes into the principle and method of logical query and physical query. The 4th chapter of the topic is subquery, not only explain the various commonly used subquery method and its optimization, but also explained the MARIADB query optimization. In the 5th chapter, the author analyzes the various joins in the MySQL database tutorial and the implementation algorithms, as well as the hash join introduced in the MARIADB database, and then gives the solution to the various operations about the set. The 6th chapter shares the methods and techniques of aggregation and rotation operations, and gives solutions to some classic common problems. The 7th Chapter delves into the use of cursors, focusing on how to improve the efficiency of SQL programming by using cursors correctly. The 8th chapter explains various programming techniques about the transaction, and expounds the classification of the transaction in detail. The 9th chapter analyzes the internal implementation of various indexes in detail, and discusses how to use the index to improve query efficiency. The 10th chapter introduces the methods and techniques of partitioning, and expounds How to do SQL programming through partitioning.

This book is a good choice whether you are a developer or a DBA, whether you need a SQL query manual or if you want to learn about SQL programming in depth.

"MySQL Technology insider: InnoDB Storage Engine" is currently the only one on the InnoDB of the book, by senior MySQL experts in person, the Chinese and foreign database experts jointly recommended, authoritative no doubt. The depth of the content, from the point of view of the source code to analyze the InnoDB architecture, implement principles, work mechanisms, and give you a great deal of best practices to help you gain a systematic and in-depth mastery of innodb and, more importantly, provide you with excellent guidance for designing and managing High-performance, highly Available database systems. Pay attention to actual combat, the whole book supplemented with a large number of cases, operability is extremely strong. The book first provides a panoramic overview of MySQL's unique plug-in storage engine, analyzing the advantages of MySQL's various storage engines and the application environment. Then take the internal implementation of InnoDB as the cut-in point, explain each function module inside the INNODB storage engine in detail, including the InnoDB Storage engine architecture, the data structure in memory, the physical storage of tables and pages based on InnoDB storage Engine, index and algorithm, file, lock, transaction, Backup, and InnoDB performance tuning of important knowledge, and finally in-depth analysis of the InnoDB storage Engine source code structure, for everyone to read and understand InnoDB source code has an important guiding significance. The MySQL technology insider: InnoDB Storage engine is for all developers and DBAs who want to build and manage high performance, high-availability MySQL database tutorials for reading books.

MySQL Technology Insider: 4th Edition introduces the basics of MySQL and its unique features that differ from other database systems, including how SQL works and the MySQL API, and how to combine MySQL with languages such as Perl or PHP. To generate dynamic Web pages for database query results, how to write MySQL data access program, detailed discussion of database management and maintenance, data directory organization and content, access control, secure connection and so on. The appendix also provides software installation information, listing the MySQL data types, functions, variables, syntax, procedures, APIs and other important details. Bestseller.

"MySQL Technology Insider: 4th Edition" is a comprehensive MySQL guide, the database system interested readers can benefit from it.

This book by The Sun China Engineering Institute MySQL experts to explain the MySQL kernel design and implementation. The author of MySQL Divide and conquer, the complex MySQL kernel into a number of functional subsystems, so as to resolve the difficulties of understanding the subsystem.

This book is divided into 12 chapters. The 1th chapter introduces the historical origin of MySQL. The 2nd chapter introduces the architecture of MySQL database. The 3rd Chapter deeply understands the MySQL source code, the 4th chapter explains the key class and the algorithm. From the 5th chapter to the end, according to each subsystem to explain, including connectivity and network systems, server threading and resource management, query resolution and optimizer, security management system, storage engine interface details and practice, classic storage engine, log function and practical analysis and other subsystems.

The relevant MySQL source code is provided in the book CD.

This book is suitable for the technicians and developers who are interested in kernel programming design, as well as the various technicians who use MySQL database in their study and work. Because the main content is related to the MySQL kernel source code, so learners should have C + + preparation knowledge books.

Turn from: http://blog.itpub.net/29057434/viewspace-768290/