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