This provides greater performance than a normalised database at the cost of increased database size and the risk of data integrity problems.
The tutorial is aimed at software developers using SQL Server for data storage.
To try the tutorial examples, a SQL Server system must be available.
This can be a locally installed instance of SQL Server or a version installed on an available networked system.
In addition to separating information according to its data structure, a relational database allows to be created.
A relationship defines a possible link between data types; the actual linkage of data is dependant upon the information held.
Part one reviews database concepts and terminology.