Database - Introduction to SQL

Indexes can usually be created for both primary and secondary keys.

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

SQL is a data sublanguage.

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.