Databases

How To Manage a Redis Database eBook — step-by-step Databases tutorial on Progressive Robot

How To Manage a Redis Database eBook

This book aims to provide an approachable introduction to Redis concepts by outlining many of the key-value store’s commands so readers can learn their patterns and syntax, thus building up readers’ understanding gradually. The goal for this book is to serve as an introduction to Redis for those interested in getting started with it, or key-value stores in general. For more experienced users, this book can function as a collection of helpful cheat sheets and in-depth reference.

Read more
How To Manage an SQL Database — step-by-step Databases tutorial on Progressive Robot

How To Manage an SQL Database

SQL databases come installed with all the commands you need to add, modify, delete, and query your data. This cheat sheet-style guide provides a quick reference to some of the most commonly-used SQL commands.

Read more
How To Use Indexes in MySQL — step-by-step Databases tutorial on Progressive Robot

How To Use Indexes in MySQL

As the data in a database increases, search performance can suffer. The larger the dataset, the harder it is for the database engine to find the documents that match the query quickly. Database administrators can use indexes to aid the database engine and improve its performance. In this tutorial, you’ll learn what indexes are, how to create them, and confirm whether they’re used to query the database.

Read more
CHAT