Local cover image
Local cover image

Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB Russell J.T. Dyer

By: Material type: TextTextPublication details: O'Reilly Media, Inc. 2015Description: 1 v. (unpaged) 29 cmDDC classification:
  • 005.133 DYE
Summary: 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
List(s) this item appears in: STEM & ENGINEERING CORNER
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Shelving location Call number Copy number Status Date due Barcode
Books Books CamTech Library STEM & Engineering 005.133 DYE (Browse shelf(Opens below)) C.1 Available CamTech 000378

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

There are no comments on this title.

to post a comment.

Click on an image to view it in the image viewer

Local cover image