MariaDB 11 Essentials - Deploying and Managing Databases with MariaDB

Neil Smyth

Summary

MariaDB 11 Essentials provides a concise guide to MariaDB, one of the most highly regarded database management systems in use today. It covers fundamental concepts, advanced techniques, and best practices.
 
The book begins by installing and configuring MariaDB on Windows and Linux before outlining the fundamentals of relational database management systems.
 
The essentials of relational database management are covered, including table design, SQL queries, joins, and transaction handling.
 
Beyond the fundamentals, this book covers advanced MariaDB features, such as indexing for performance optimization, automation with triggers and events, and creating and restoring database backups.
 
In addition to covering the command-line tools provided with MariaDB, several chapters introduce the phpMyAdmin and MySQL Workbench tools, which offer user-friendly graphical interfaces for database management.
 
This book explains each topic in detail and includes practical examples that provide hands-on experience. The chapters also contain quick-reference summaries highlighting key points for easy review.
 
By the end of this book, you will have the confidence to design, build, and manage MariaDB databases.

Available since: 04/10/2025.

Print length: 268 pages.

Science & Technology

Other books that might interest you

I AM Intuitive - A...

Arlene Dijamco

Are you ready to feel free and flow through life with purpose and clarity? Created by integrative physician Dr. Arlene Dijamco, this groundbreaking resource can help you light up from the inside out to live life as the full expression of who you are.
Every part of you has meaning-from how you feel and what you notice to what you think, say, and do. By learning to interpret the various aspects of yourself, you will learn how to tap into your own navigation system.
Need direction? You've got it. Inspiration during difficult times? It's within you. Looking for company? Start by befriending yourself. After all, you're an infinite being with unlimited potential. This book will shed light on the truth of your multidimensional and loving nature. Sit with the pages often because there's so much here to embrace, process, and explore as you deepen your self-understanding.
Filled with real-life patient stories, practical exercises, concise charts, feel-good clarity, and intuitive know-how, I AM Intuitive will help you access your inner compass-body, mind, and spirit.TABLE OF CONTENTS
Disclaimer
Opening Poem
Preface
Introduction
Part I - The Intuitive body
Chapter 1 - A New Way of Looking at Symptoms
Chapter 2 - Grounding the Body and Opening the Heart
Chapter 3 - Your Body as a Compass
Exercises for the Intuitive Body
Part II - The Intuitive Mind
Chapter 4 - Thoughts—What are They?
Chapter 5 - Grounding the Mind
Chapter 6 - Your Mind as a Compass
Exercises for the Intuitive Mind
Chapter 7 - Spiritual Beings Having a Human Experience
Chapter 8 - Grounding the Spirit
Chapter 9 - Your Spirit as a Compass
Exercises for the Intuitive Spirit
Part IV - The Intuitive Human
Chapter 10 - The Art of Intuitive Living
Chapter 11 - Multidimensional Medicine

Show book

ChatGPT talks on science for...

Paulo Dario

This book follows a series of "conversations" with these tools, mainly with "chatGPT 4.0" but also with "Bard". It's well known that chatGPT is hampered in its research up to a certain point in time and, because they are language modeling tools, they end up inventing... a lot, especially in bibliographic references. However, accessory tools are emerging that make it possible to improve and even correct this situation, tools that will certainly become much more powerful in the future, but which are already a reality. So, using all these AI tools, a book has been created that aims to be a pedagogical tool that answers a series of questions that can be asked by secondary and higher education students, or even people who are just interested in these issues, but who don't have the access or predisposition to use these types of AI tools.

Show book

A Wilding Year - Bringing life...

Hannah Dale

Follow Hannah Dale's deeply personal journey as she returns her Lincolnshire farm to nature, celebrating the return of an astonishing variety of wildlife.
Hannah Dale, the artist and founder of the award-winning nature-centric gift company Wrendale Designs, takes you through a year on her farm in rural Lincolnshire where, alongside her husband, she has undertaken an ambitious rewilding project. Together, they are attempting to return the land to nature and increase the number of species their land is able to support.
A Wilding Year explores how one family have been able to embrace the beauty to be found in untidy landscapes, heralding the return of skylarks, meadow pipits, hobbies, polecats and many more species to their farm. The land was originally claimed from marshy wetlands, and leaning into the land's natural inclination to be wet has also yielded amazing ponds and pond life.
This rewilding journey has also provided Hannah with new sources of inspiration for her paintings. A Wilding Year is both a journal and a sketchbook, in which Hannah keeps a visual record of the incredible variety of species she finds on the farm.
This fascinating account of a year spent in nature brings to life the beauty and power of wildlife in every season.

Show book

Do Elephants Have Knees? and...

Charles R. Ault

What makes a penguin a bird? Is a camel more closely related to a horse than to a giraffe? Why is a whale not a fish? Similar puzzles preoccupied Charles Darwin throughout his life. Whimsy, in the playfulness of stories for children, is a way to appreciate Darwinian histories. 
In Do Elephants Have Knees? Charles R. Ault Jr. uses the fanciful imagery of story to explain Darwinian thought. At the same time, he launches careful consideration of Darwin’s humanity, the origins of his curiosity, and the reach of his ideas. 
Ault’s approach illustrates the value of story form in learning science and provides a wealth of resources for enriching courses that focus on Darwin’s ideas. “Good storytelling mines curiosity,” Ault writes, “and exuberant playfulness enriches a disciplined study of science.”

Show book

Cybersecurity: Safeguarding Your...

Ryan Adams

"Cybersecurity: Safeguarding Your Digital World as a Cyber Sentinel" is an in-depth guide to managing the complex environment of online threats in an era dominated by digital interactions and technical breakthroughs. This book is a vital resource for individuals, businesses, and cybersecurity experts who want to safeguard their digital assets and preserve the integrity of their information systems. 
 The book explores the vital significance of cybersecurity, stressing the dynamic threat environment that is defined by highly skilled assaults like phishing, ransomware, and advanced persistent threats (APTs). It highlights the CIA Triad's core values—Confidentiality, Integrity, and Availability—which serve as the cornerstone of all cybersecurity initiatives. 
 With thorough instructions on how to set up multi-factor authentication (MFA), create strong passwords, encrypt data, and create safe backup plans, readers will obtain useful insights into safeguarding personal devices. The book also discusses responsible social media usage and secure browsing techniques to protect private data and prevent identity theft. 
 The book provides firms with detailed methods for creating strong cybersecurity frameworks, including staff training, risk assessment, policy creation, and incident response planning. It looks at how important network security necessities like intrusion detection systems (IDS) and firewalls are for safeguarding organizational infrastructure. 
 The potential of emerging technologies like blockchain and artificial intelligence (AI) to improve cybersecurity protocols is explored, and talks about continuous learning emphasize the value of remaining up to date on the most recent developments and dangers in the industry.

Show book

Food Safety Exam Prep 2025-2026...

Lucian Ashbourne

Food Safety Exam Prep 2025-2026
⭐⭐ Simplified Guide & Explanations Included ⭐⭐
Are you eager to advance your career and solidify your knowledge by successfully passing the Master Food Safety Exam?
Searching for a thorough guide that encompasses all the essential elements to excel in the Master Food Safety Exam?
Your quest ends here!
This guide serves as your ultimate companion for enhancing your understanding, applying your skills, and participating in practical exercises. With this resource, you’re set up for success.
Updated to align with the latest Master Food Safety Exam Structure.
Key features of this comprehensive guide:
- In-depth perspective on the Master Food Safety Certification
- Extensive explanations of critical food safety concepts
- Effective strategies for exam preparation and successful tackling of questions
Our guide stands out because of its exhaustive coverage, which is vital for your exam triumph. Concepts are not merely glossed over; they are explored in detail.
Please be aware that this guide is an independent resource and is not affiliated with any official food safety organization.
Structured clearly and written in accessible language, our Food Safety Exam Guide ensures smooth transitions between topics. Bid farewell to complex jargon and embrace content that is clear, concise, and technically sound.
So, why hesistate? Click the BUY NOW button, secure your guide, and embark on your journey towards success in the Master Food Safety Exam!
Don’t miss out on this essential resource that prepares you thoroughly for the Food Safety Exam.

Show book