1

Introduction to databases

• What are a database and a database server?
• Reading a relational model.
• Creating a table. Notions of columns and types
• Primary key and uniqueness.
• Notion of referential integrity.
• Tool for querying a database.

2

Extracting data from a table

• What is an extraction query?
• List the values to be returned.
• The WHERE clause for filtering data.
• The absence of a value (NULL marker).
• Returning unduplicated rows (DISTINCT).
• Restriction operators (BETWEEN, IN, LIKE, etc.).

3

Querying data from multiple tables

• Concept of joins: Returning information from multiple tables.
• Inner join and outer join.
• The “natural” join... and its difficulties.
• Assembly operators (UNION, INTERSECT...).
• Introduction to views: principle and benefits

4

Ranking and statistics

• Finding aggregate values (MIN, MAX, AVG, SUM, etc.).
• Calculating relative aggregates with GROUP BY.
• Filtering aggregate values with HAVING.
• Mixing aggregates and details with OVER.
• Ranking results with RANK, ROW_NUMBER.

5

Presenting and sorting data

• Presenting data from columns with aliases
• Converting from one type to another.
• Making choices using the CASE operator.
• Sorting data with ORDER BY.
• Operations on character strings and dates.

6

Using subqueries

• What is a subquery?
• Different types of results.
• Subqueries of lists and IN, ANY/SOME and ALL operators.
• Correlated subqueries.