Аннотация
If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.
Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.
Create and alter MySQL tables and specify fields and columns within them
Learn how to insert, select, update, delete, join, and subquery data, using practical examples
Use built-in string functions to find, extract, format, and convert text from columns
Learn functions for mathematical or statistical calculations, and for formatting date and time values
Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
Use APIs to connect and query MySQL and MariaDB with PHP and other languages
![Automate the Boring Stuff with Python [Practical Programming for Total Beginners]](https://www.rulit.me/data/programs/images/automate-the-boring-stuff-with-python-practical-programming_570900.jpg "If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you?
In Automate the Boring Stuff with Python, you’ll learn how to use Python to write programs that do in...")
![Peopleware: Productive Projects and Teams [3rd Edition]](https://www.rulit.me/data/programs/images/peopleware-productive-projects-and-teams-3rd-edition_492686.jpg "Few books in computing have had as profound an influence on software management as Peopleware . The unique insight of this longtime best seller is that the major issues of software development are human, not technical. They’re not easy issues; but solve them, and you’ll maximize your chances of...")
![Вальсируя с медведями [Управление рисками в проектах по разработке программного обеспечения]](https://www.rulit.me/data/programs/images/valsiruya-s-medvedyami-upravlenie-riskami-v-proektah-po-razr_561573.jpg "В этой книге Том ДеМарко и Тимоти Листер, авторы бестселлера Peopleware, рассказывают, как идентифицировать риски, управлять ими и извлекать выгоду из рисков.
...")
![Идеальный код [Как научиться видеть красоту в программировании]](https://www.rulit.me/data/programs/images/oram-endi_605774.jpg "В этой уникальной книге самые авторитетные разработчики программного обеспечения делятся опытом оригинального решения задач, которые вставали перед ними при...")
![The Art of Computer Programming: Volume 1: Fundamental Algorithms [3rd Edition]](https://www.rulit.me/data/programs/images/the-art-of-computer-programming-volume-1-fundamental-algorit_568635.jpg "The bible of all fundamental algorithms and the work that taught many of today")
![Swift [Основы разработки приложений под iOS и macOS]](https://www.rulit.me/data/programs/images/swift-osnovy-razrabotki-prilozhenij-pod-ios-i-macos_554812.jpg "Язык Swift молод, он растет, развивается и изменяется. Но основные подходы к программированию и разработке уже сформировались, и в новом, четвертом издании книги...")
Комментарии к книге "Learning MySQL and MariaDB"