FB
SQL Best Practices and Style Guide

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”.

read more…

Ultimate Guide to the SQL Execution Plan

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!

read more…

How to Fix Slow SQL Queries

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.

read more…

Hierarchical Data in SQL: The Ultimate Guide

Hierarchical Data in SQL: The Ultimate Guide

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…)

How to Save MySQL Query Output to a File

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.

read more…

81 Best Books for Programmers

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…)

Ben Brumm
Ben Brumm
DatabaseStar

Database Star Academy:
Login

Oracle SQL Expert

Oracle SQL Associate

Popular Posts

Database Normalisation
Introduction to Oracle SQL
SQL Joins
Database Developer

Share via
Copy link
Powered by Social Snap