Database Tutorial

Course Tutorial Site

Site Admin

Articles

without comments

Week 3: Articles

The articles for this week focus on the Data Manipulation Language (DML) INSERT statement, scalar subqueries, and automatic numbering. Scalar subqueries are SELECT statements that return one column and one row from a table; and they are typically used to find a surrogate key by using the natural key in the WHERE clause. Automatic numbering uses sequence values to populate what are known as surrogate key columns or ID columns.

You should read the INSERT article first and then either the scalar subquery or automatic numbering articles.

Articles

Written by michaelmclaughlin

August 11th, 2018 at 3:06 pm

Posted in