FB
Ultimate Guide to Data Warehouses

Ultimate Guide to Data Warehouses

Data warehouses are an important part of a business. As a developer, you’ll be involved in the data warehouse in one way or another: creating it, designing it, accessing it, or working on software that provides data to it. Learn all about data warehouses in this... Read more
Sample Database: University Rankings (ERD and SQL)

Sample Database: University Rankings (ERD and SQL)

Do you want to practice SQL on something other than the basic default database? Here’s a sample ERD and data for a university ranking database. When you’re learning SQL or database design, it’s helpful to use other databases as a reference. Many... Read more
Sample Database: Olympic Games (ERD and SQL)

Sample Database: Olympic Games (ERD and SQL)

When you’re learning SQL or database design, it’s helpful to use other databases as a reference. Many articles online refer to Oracle’s HR database, or SQL Server’s AdventureWorks database. These can be helpful, but often you’re looking... Read more
24 Database Design Mistakes and How to Avoid Them

24 Database Design Mistakes and How to Avoid Them

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