FB
Ultimate Guide to Data Warehouses

Ultimate Guide to Data Warehouses

Jan 6, 2020

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)

Dec 18, 2019

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)

Dec 10, 2019

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
A Guide to the Entity Relationship Diagram (ERD)

A Guide to the Entity Relationship Diagram (ERD)

Jul 31, 2019

Learn all about Entity Relationship Diagrams (ERDs), what they are used for, how to understand them, how to create them, and more in this guide. What is an Entity Relationship Diagram (ERD)? An Entity Relationship Diagram (ERD) is a type of diagram that lets you see... Read more
24 Database Design Mistakes and How to Avoid Them

24 Database Design Mistakes and How to Avoid Them

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