24 Database Design Mistakes and How to Avoid Them

by Ben | Aug 18, 2018

Creating a database is easy. Designing an effective database, the right way, using good practices, is hard. In this article, I’ve listed 24 different database design mistakes that you should try to avoid. Mistake 1: Ignoring the Purpose or Frequency of the Data When... Read more

Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

by Ben | Jul 10, 2018

Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you’ll learn what these terms are, so you can communicate better with other developers and understand other online tutorials that use these... Read more

Database Normalization: A Step-By-Step-Guide With Examples

by Ben | Sep 30, 2017

Database normalisation is a concept that can be hard to understand. But it doesn’t have to be. In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms. By the end of the article, you’ll know all about it and how to do it. So... Read more

Singular vs Plural and Other Database Table Naming Conventions

by Ben | Jan 2, 2017

Are you wondering if you should name your Oracle database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article. Why Do We Need SQL Table... Read more

6 Easy And Actionable Steps On How To Design A Database

by Ben | Apr 21, 2014

Are you looking to design a database? Whether it’s for your workplace or home project, learning how to design a database is a valuable skill. Let’s take a look at six easy steps on how to design a database. 1 – What Is Your Purpose? The first place... Read more