Data definition
Normalization
Data Manipulation
So what happens when you create a view, and then later someone else changes the underlying tables? In this article let’s explore
In this article we are going to design and create a sample relational database you can use with MySql, PostgreSQL or Microsoft
You can use the SQL CREATE TABLE command to create a new table in the database. When you create a table you
In this puzzle, we’re going to learn how to do some basic data modeling. Many of you have expressed an interest in
Primary Key vs Unique Key. It really not about one or the other. You actually may need both a primary key and
What is a Data Dictionary? The SQL Server data dictionary stores information about a database’s definition. The dictionary contains information about database
Database normalization is a process used to organize a database into tables and columns. There are three main forms: first normal form
This article will teach you the difference between a primary key and foreign key. This article will also teach you why both
When working with SQL databases it is often useful to create diagrams of the database tables and their relationships. These may be
A database view is a searchable object in a database that is defined by a query. Though a view doesn’t store data,
A database index allows a query to efficiently retrieve data from a database. Indexes are related to specific tables and consist of
A relational database is made up of several components, of which the table is most significant. The database table is where all
The main objective of a database management system is to store, retrieve, and process data. In order to do this in a
A SQL database is used to store and retrieve data. The database is housed in a database server and largely controlled by
