Database Star

JSON in MySQL: The Ultimate Guide

MySQL has quite a few features for storing and working with JSON data.

SQL Best Practices and Style Guide

SQL is a common language to learn when working with software.

But once you learn the basics, you’ve probably got a lot of questions about different ways to do things.

How should I format my code? Which alternative of these features is better?

This guide aims to help answer those questions.

Read on to learn how to style your SQL and some recommendations in this “SQL Style Guide and Best Practices”.

Ultimate Guide to the SQL Execution Plan

If you’ve looked into SQL performance at all online, you’ve probably heard of something called an “SQL execution plan”.

Or maybe you’ve heard it called a “query plan” or “explain plan”.

What is it, why is it helpful, and what can you do with it?

You’ll learn all about them, and more, in this guide.

Let’s get into it!

How to Fix Slow SQL Queries

Do you have a slow SQL query?

If so, you’re in the right place.

In this article, you’ll learn a range of reasons why a SQL query may be slow and how to fix them.

Hierarchical Data in SQL: The Ultimate Guide

Storing hierarchical data in a database is something we need to do occasionally.

While databases are very good at storing data about different types of records, hierarchical data is not something that is immediately obvious.

But there are several ways it can be done.

In this guide, you’ll learn what hierarchical data is, see several different methods for designing your tables along with queries for each method, pros and cons of each design, and recommendations for Oracle, SQL Server, MySQL, and PostgreSQL.

Let’s get into the guide!

(more…)

29 Software Developers Share Database Advice

Software developers are one of the main groups of people who work with databases.

Recently, I asked a range of software developer blog owners to share their advice for working with databases.

How to Save MySQL Query Output to a File

Do you need to save your results from a MySQL query to a CSV or text file?

It’s easy to do in MySQL. You can do this using an IDE or the command line, using a built-in MySQL command.

Let’s take a look.

How to Import a CSV using MySQL Workbench

Are you working on a MySQL database and need to import CSV data?

I’ll show you how to do this in MySQL Workbench in this guide.

17 Sites for SQL Practice

Are you looking for places to practice SQL online? This list contains many different websites that have SQL practice functionality.

81 Best Books for Programmers

If you’re a programmer or software developer, you’ve probably done a lot of reading. And if you’re interested in becoming a better programmer, there are many books you can read to improve your skills.

This page contains a list of the best books for programmers. I’ve looked at different lists on Google, Reddit, Twitter, and other places.

(more…)