In this article we are going to design and create a sample relational database you can use with MySql, PostgreSQL or Microsoft

Read More
Database Design In Four Steps – Build the Sample PizzaDB

You can use the SQL CREATE TABLE command to create a new table in the database.  When you create a table you

Read More
CREATE TABLE SQL

In this puzzle, we’re going to learn how to do some basic data modeling.  Many of you have expressed an interest in

Read More
Data Modeling Principles in Action

Primary Key vs Unique Key. It really not about one or the other. You actually may need both a primary key and

Read More
Primary Key vs Unique Key – What is the Difference?

What is a Data Dictionary? The SQL Server data dictionary stores information about a database’s definition.  The dictionary contains information about database

Read More
What is a SQL Server Data Dictionary?

Database normalization is a process used to organize a database into tables and columns. There are three main forms: first normal form

Read More
Database Normalization – in Easy to Understand English

This article will teach you the difference between a primary key and foreign key. This article will also teach you why both

Read More
Foreign Key vs Primary Key – What is the Difference?

When working with SQL databases it is often useful to create diagrams of the database tables and their relationships.  These may be

Read More
Keep it Simple: Easy To Understand Data Modeling Concepts

A database view is a searchable object in a database that is defined by a query.  Though a view doesn’t store data,

Read More
What is a Relational Database View?

A database index allows a query to efficiently retrieve data from a database.  Indexes are related to specific tables and consist of

Read More
Database Indexes Explained

A relational database is made up of several components, of which the table is most significant.  The database table is where all

Read More
What is a Database Table?

The main objective of a database management system is to store, retrieve, and process data.  In order to do this in a

Read More
Database Management System Main Parts

A SQL database is used to store and retrieve data.  The database is housed in a database server and largely controlled by

Read More
What are the Major Part of a SQL DB?