SQL Server Default Column Values The eleventh part of the SQL Server Programming Fundamentals tutorial considers the use of default column values. These are literal values or functions that are used to provide default values for columns when new table rows are created.

SQL Server Identity Columns The twelfth part of the SQL Server Programming Fundamentals tutorial describes identity columns. By applying an identity specification to a numeric column, the column's value is defaulted to a new value for every row inserted into the table.

SQL Server Computed Columns The thirteenth part of the SQL Server Programming Fundamentals tutorial investigates computed columns. Values in these columns are calculated automatically by the database management system using an expression that is attached to the column definition.

SQL Server Unique Constraints The fourteenth part of the SQL Server Programming Fundamentals tutorial discusses unique constraints. This type of constraint adds a rule to a table to ensure that no two rows contain duplicate information within the constrained columns.

SQL Server Indexes Part 1 The fifteenth part of the SQL Server Programming Fundamentals tutorial describes indexes. Indexes provide a lookup facility for a table, allowing rows to be found more quickly and without the need to scan the data in every row when querying a table.

This tutorial is 29% complete. More articles will be added shortly.