Querying MariaDB
eBook - ePub

Querying MariaDB

Use SQL Operations, Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Adam Aspin

Share book
  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Querying MariaDB

Use SQL Operations, Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Adam Aspin

Book details
Table of contents

About This Book

Employ analytics in relational databases to advance your career

Key Features
? Use of multiple MariaDB datasets to gain hands-on experience with data analysis principles.
? Extensive examples take the reader through all levels of SQL skill, from novice to expert.
? Includes methods and techniques for doing complex database queries in MariaDB.

This book will take you on an engaging experience to understand SQL querying from the most basic to the most expert level, using various SQL techniques to extract valuable insights from your MariaDB databases. The adventure will begin with the most basic level and end with the most professional level.This book's first section provides an introduction to the fundamental concepts of both SQL and MariaDB. It then guides users through building queries using simple and then more complex table joins and progressively more powerful data filtering to generate advanced queries utilizing various SQL techniques. The reader will understand MariaDB database analysis better by learning the basics of SQL computation, relational logic, and data grouping and aggregation. Also covered are SQL basics like formatting queries, making subqueries, making derived tables, joining and filtering tables, etc. In addition, the book explains how to conduct rolling analysis, investigate time-series data, and manage enormous and complex MariaDB datasets.When readers have finished the book, they can devise their techniques for analyzing relational MariaDB datasets and acquiring the necessary insights.

What you will learn
? Examine SQL principles such as table joins, data filtering, query design, and table derivation.
? Make it simpler to manipulate data that is dispersed across multiple tables.
? Use basic math and logic, multiple filters, and data aggregation to look at the data
.? Learn to use table expressions, subqueries, and complex calculations well.
? Utilize sophisticated techniques for rolling analysis and time series analysis.

Who this book is for
This book is for MariaDB users and data professionals, including database developers, SQL developers, data analysts, and BI specialists, who wish to design complicated queries and extract the needed insights from their datasets.

Table of Contents
1. Writing Basic SQL Queries
2. Using Multiple Tables When Querying Data
3. Using Advanced Table Joins
4. Filtering Data
5. Applying Complex Filters to Queries
6. Making Simple Calculations
7. Aggregating Output
8. Working with Dates in MariaDB
9. Formatting Text in Query Output
10. Formatting Numbers and Dates
11. Using Basic Logic to Enhance Analysis
12. Subqueries
13. Derived Tables
14. Common Table Expressions
15. Correlated Subqueries
16. Dataset Manipulation
17. Using SQL for More Advanced Calculations
18. Segmenting and Classifying Data
19. Rolling Analysis
20. Analyzing Data Over Time
21. Complex Data Output

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Querying MariaDB an online PDF/ePUB?
Yes, you can access Querying MariaDB by Adam Aspin in PDF and/or ePUB format, as well as other popular books in Computer Science & Programming in SQL. We have over one million books available in our catalogue for you to explore.



Table of contents