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 Printed Pages: 432. Buchnummer des Verkäufers 92235
Titel: Learning MySQL and MariaDB: Heading in the ...
Verlag: Shroff Publishers & Distributors Pvt. Ltd.
Buchbeschreibung O'reilly UK Ltd. Apr 2015, 2015. Taschenbuch. Buchzustand: Neu. Neuware - With an easy, step-by-step approach, this practical guide shows programmers new to databases how to install, effectively use, and maintain MySQL and MariaDB. You'll learn these database systems through real-world examples and many practical tips. Popular and easy-to-use database engines such as MySQL and MariaDB - a community-driven variant of MySQL& - help organizations large and small handle data by providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. Experienced web developers and programmers interested in adding MySQL to their skill sets will also find this book useful. Topics include: An introduction to database systems and the SQL database language Installation and basic administration of MySQL and MariaDB Functions, subqueries, and other query enhancements Methods for accessing MySQL and MariaDB from popular programming languages 381 pp. Englisch. Artikel-Nr. 9781449362904