MySQL / MariaDB

No Starch Press, 2023. — 511 р. — ISBN-13: 978-1718503007. With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know. MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled withpractical...

Packt Publishing, 2012. - 366 p. - ISBN: 1849517789 phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data...

Apress, 2016. — 391 p. — ISBN10: 1484212940. — ISBN13: 978-1484212943 2016 | ISBN: 1484212940 | English | 335 Pages | EPUB | 4 MB This book introduces the problems facing Internet of Things developers and explores current technologies and techniques to help you manage, mine, and make sense of the data being collected through the use of the world's most popular database on the...

O’Reilly Media, Inc., 2022. — 483 p. — ISBN 978-1-098-10509-9. You'll find several books on MySQL basics today, but only one that covers advanced MySQL performance--and nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching developers mid-level MySQL knowledge beyond the...

Packt Publishing, 2022. — 725 p. — ISBN 1839214902. Learning MySQL just got a whole lot easier, thanks to this hands-on workshop, complete with simple explanations, engaging examples, and realistic exercises that focus on helping you to build and maintain databases effectively Key Features Learn how to set up and maintain a MySQL database. Run SQL queries to create, retrieve,...

Packt Publishing, 2018. — 446 p. MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before. This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and...

BPB Online, 2022. — 674 p. — ISBN 978-93-5551-267-3. This book will take you on an interactive journey to understand SQL querying from the most basic to the most expert level utilising a variety of SQL techniques to extract relevant insights from your MySQL databases. The first section of this book serves as an introduction to the fundamental ideas of both SQL and MySQL. It...

McGraw-Hil, 2013. — 1904 p. — ISBN: 0071791884. The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL...

Packt Publishing - ebooks Account, 2014. — 312 p. — ISBN10: 1783284390. — ISBN13: 978-978-1783284399 Enable performance-enhancing optimizations Connect to different databases and file formats Filled with clear step-by-step instructions that can be run on a live database Who This Book Is For This book is for anyone who wants to learn more about databases in general or MariaDB in...

Trevor J Page, 2014. — 142 p. — ASIN B00OVB9ULY Learning about Databases and SQL is a skill that not only benefits Database Administrators, but also programmers too. This course is designed to give programmers a "leg-up" on the competition when it comes to landing a great job in the programming field. This book is written by former senior software engineer and best-selling...

Apress, 2013. - 640 pages. 2nd Edition. ISBN: 1430246596. На англ. языке. Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL...

Packt Publishing, 2017. — 470 p. — ISBN10: 1788397185, ISBN13: 978-1788397186. Code files Combine the powers of MySQL and Hadoop to build a solid Big Data solution for your organization Integrate MySQL with different NoSQL APIs and Big Data tools such as Apache Sqoop A comprehensive guide with practical examples on building a high performance Big Data pipeline with MySQL Who...

Wiley, 2013. — 720 p. — ISBN: 111821370X, 9781118213704. Get the basics on four key web programming tools in one great book! PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content...

1st ed. — 2015. — 44 p. MySQL for Beginners is a Book for all MySQL Queries,Statements,About MySQL,Uses of MySQL,MySQL Tools,all MySQL Statements,About Databases,MySQL Web,other MySQL Queries, etc. Creating Databases, Tables Accessing Databases Inserting data into Table Altering Table Select Queries MySQL Functions MySQL Join MySQL Create Index MySQL Auto Increment a field...

SitePoint, 2015. — 150 p. — ISBN10: 0992461286, ISBN13: 978-0-9941826-3-0 (ebook). Get a Jump Start on working with MySQL today! MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers.

Packt Publishing, 2015. — 208 p. — ISBN: 978-1-78398-286-8. Quickly get up to speed with MariaDB—the leading, drop-in replacement for MySQL, through this practical tutorial This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features. At the very beginning, we show you the...

Apress, 2013. — 448 p. — ISBN: 1430260769, 9781430260769. Practical PHP and MySQL Website Databases is a project-oriented book that demystifies building interactive, database-driven websites. The focus is on getting you up and running as quickly as possible. In the first two chapters you will set up your development and testing environment, and then build your first PHP and...

Packt Publishing, 2014. — 384 p. — ISBN: 978-1-78398-154-0. Debug, secure, and back up your data for optimum server performance with MariaDB. MariaDB is a community-driven fork of MySQL, and is a relational DBMS that can be used to build reliable, high-performance database servers. MariaDB combines MySQL characteristics such as replication, backup and disaster recovery,...

Apress, 2013. — 340 p. — ISBN: 1430260076, 9781430260073. Expert PHP and MySQL takes you beyond learning syntax to showing you how to apply proven software development methods to building commerce-grade PHP and MySQL projects that will stand the test of time and reliably deliver on customer needs. Developers of real-world applications face numerous problems that seem trivial on...

Packt Publishing, 2019. — 286 p. — ISBN: 1788834445. Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL Key Features Explore the new and advanced features of MySQL 8.0 Use advanced techniques to optimize MySQL performance Create MySQL-based applications for your enterprise with the help of practical examples Book...

Packt Publishing, 2018. — 510 p. — ISBN: 9781788395199. MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This handbook will be your companion to understand the newly introduced features in MySQL and how you can...

BPB Publications, 2020. — 132 р. — ISBN: 978-93-89898-088. A step-by-step guide that will help you manage data in a relational database using SQL with ease DESCRIPTION This book starts with the concepts in RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). The first few chapters cover the definitions and a brief explanation of all the important...

Packt Publishing, 2013. - 88 Pages. ISBN: 184968748X. На англ. языке. A quick reference guide to walk you through the setup of InnoDB, and help you start unlocking the engine's potential Overview Learn something new in an Instant! A short, fast, focused guide delivering immediate results. Detailed and in-depth explanation of configuration and tuning parameters, in addition to...

McGraw-Hill Education, 2018. — 128 p. Practical instruction on using JavaScript Object Notation (JSON) with MySQL This hands-on guide teaches, step by step, how to use JavaScript Object Notation (JSON) with MySQL. Written by a MySQL Community Manager for Oracle, MySQL and JSON: A Practical Programming Guide shows how to quickly get started using JSON with MySQL and clearly...

Apress, 2017. — 116 p. — ISBN: 1484231198. Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins...

Apress, 2018. — 473 p. — ISBN: 1484238842. Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB...

Apress, 2018. — 545 p. — ISBN: 1484227247. Learn the new Document Store feature of MySQL 8 and build applications around a mix of the best features from SQL and NoSQL database paradigms. Don’t allow yourself to be forced into one paradigm or the other, but combine both approaches by using the Document Store. MySQL 8 was designed from the beginning to bridge the gap between...

4th Edition. — O’Reilly Media, 2022. — 523 p. — ISBN 978-1-492-08051-0. How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide...

Apress, 2017. — 700 p. — ISBN: 978-1-4842-2981-1. Create and run a real-time, highly-available, and high-redundancy version of the world's most popular open-source database, MySQL. You will understand the advantages and disadvantages of the MySQL NDB Cluster solution, and when MySQL NDB Cluster is the right choice. Pro MySQL NDB Cluster walks you through the full lifecycle of a...

Apress: 2024, 757 p. — ISBN-13 979-8868802515. Освоение администрирования MySQL: высокая доступность, безопасность, производительность и эффективность This book is your one-stop resource on MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, and performance and...

LearnToProgram, 2014. — 518 p. — ISBN: 0990402010, 9780990402015. So you're getting comfortable with HTML, CSS and JavaScript? You're up for the next challenge? The PHP programming language coupled with the MySQL database is the final step toward making a complete application. Many commercial e-commerce sites, membership sites and even online communities use PHP. Once you learn...

O’Reilly Media, 2024. — 606 p. — ISBN 978-1098155896, 1098155890, ASIN B0D8GCCGWX. Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations,...

2nd Revised edition. — Packt Publishing, 2015. — 135 p. — ISBN10: 1785284126, ISBN13: 978-1785284120. Код примеров к книге выложен здесь: /file/1965522/ MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some...

Apress, 2019. — 514 p. — ISBN13: (pbk) 978-1-4842-5082-2. Use MySQL Shell, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL, Python, and JavaScript. That’s right! You can write Python scripts and execute them within the shell interactively, or in batch mode. The level of automation available from Python combined with batch mode...

Addison-Wesley, 2011. — 394 p. — ISBN10: 0321799941, ISBN13: 978-0-321-79994-4. MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including...

2nd edition. — O’Reilly Media, Inc., 2021. — 632 p. — ISBN 978-1492085928. Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster and recovery, this...

Apress, 2020. — 849 p. — ISBN13: (electronic): 978-1-4842-5584-1. Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries...

Packt Publishing, 2014. — 298 p. — ISBN: 978-1-78398-160-1. Familiarize yourself with the MariaDB system and build high-performance applications. Designing and maintaining a huge amount of data in production is not an easy task. Understanding how solutions work, what kind of differences exist between them, and how to get them working is necessary before designing a...

Books on Demand, 2018. — 640 p. MySQL Cluster has been developed for more than 20 years. The amount of innovative ideas in the product deserves a thorough description. This book covers the reasons why NDB was developed, the initial requirements and what applications it is used in. Covers internal algorithms and how they interact with external APIs and configuration. Contains a...

Apress, 2019. — 156 p. Mitigate the risks involved in migrating away from a proprietary database platform toward MariaDB’s open source database engine. This book will help you assess the risks and the work involved, and ensure a successful migration. Migrating to MariaDB describes the process and lessons learned during a migration from a proprietary database management engine...

O’Reilly Media, Inc., 2024. – 686 p. — (3rd Early Release). ISBN 9781098155896. Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, high...

O’Reilly Media, 2014. — 762 р. — ISBN: 1449339581, 9781449339586. Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or...

Apress Media LLC, 2023. — 412 p. — ISBN-13 978-1-4842-8945-7. Access all the information you need to begin using the MySQL Database Service (MDS) in the Oracle Cloud Infrastructure (OCI). MDS is Oracle’s new platform as a service (PAAS) offering for open-source database users. This book covers getting started with an account in OCI, gives a brief overview of OCI services...

GitforGits, 2025. — 442 p. — ISBN 8198431624, 9788198431622. This book is for DBAs and devs who are eager to dive into the world of modern database operations with MySQL 9. With clear-cut instructions and step-by-step demonstrations, you'll be up and running in no time. You'll learn to install MySQL 9 on Linux, upgrade existing systems, and even migrate data from other...

2nd edition. — David Stokes Publishing, 2020. — 180 p. JSON - JavaScript Object Notation - has become the data interchange format for most developers. MySQL added a JSON data type plus NoSQL JSON Document Store so developers can work with both relational tables and schema-less JSON document collections in version 5.7. MySQL 8.0 has introduced many new JSON centric features....

Apress Media LLC., 2024. — 382 p. — ISBN-13: 979-8-8688-0980-4. Your MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security―and that’s only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or...

2nd edition. — O’Reilly Media, 2008. — 1094 p. — ISBN: 978-0-596-51433-4. When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or...

2nd Edition. — Addison-Wesley Professional, 2023-11-10. — 304 p. — ISBN-13: 978-0-13-822302-1. MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately...

Apress, 2021. — 399 p. — ISBN: 9781484266519 Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well as table locks to record and gap...

Packt Publishing, 2012. — 134 p. — ISBN: 1849687463, 9781849687461. Master the tools you thought you knew and discover the features you never knew existed Tips, tricks and fast-paced tutorials for getting the most out of Navicat Master the visual design tools and editors with thorough examples. Discover how easy Navicat makes outsmarting the trickiest cases. Both Mac and PC...

4th Edition. — O’Reilly Media, Inc., 2022. — 950 p. — ISBN 978-1-492-09309-1. For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out...

GitforGits, 2024. — 335 p. For database developers, administrators, engineers, and backend developers, MySQL 8 Cookbook provides solution-focused recipes. This book takes a practical approach to solving real-world problems by showing readers how to increase database security, enhance performance, and fix common MySQL issues through the use of numerous examples. You will learn...