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 themLearn how to insert, select, update, delete, join, and subquery data, using practical examplesUse built-in string functions to find, extract, format, and convert text from columnsLearn functions for mathematical or statistical calculations, and for formatting date and time valuesPerform administrative duties such as managing user accounts, backing up databases, and importing large amounts of dataUse APIs to connect and query MySQL and MariaDB with PHP and other languages
From the brand
Sharing the knowledge of experts
O’Reilly’s mission is to change the world by sharing the knowledge of innovators. For over 40 years, we’ve inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.
Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.
Your partner in learning
Bestsellers
Software Development
Programming Languages
AI / Machine Learning
Data Science
Data, Databases and more
Cloud Services
Business
Finance
Blockchain / Cryptocurrency
Security
Cookbooks
Head First series
97 Things series
Lean series
ASIN : B00VDHRFJI
Publisher : O’Reilly Media
Accessibility : Learn more
Publication date : March 30, 2015
Edition : 1st
Language : English
File size : 1.7 MB
Simultaneous device usage : Unlimited
Screen Reader : Supported
Enhanced typesetting : Enabled
X-Ray : Not Enabled
Word Wise : Not Enabled
Print length : 675 pages
ISBN-13 : 978-1449362867
Page Flip : Enabled
Best Sellers Rank: #2,138,510 in Kindle Store (See Top 100 in Kindle Store) #38 in MySQL Guides #91 in SQL #202 in SQL Databases
Customer Reviews: 4.2 4.2 out of 5 stars 27 ratings