NULL

Exercise #30

Database «Recycled materials company»

Exercise #70

Database «Ships»

NOT IN predicate

Three-valued logic and WHERE clause

Exercise #37

Database «Ships»

UNPIVOT operator

PIVOT and UNPIVOT Operators

Using NULL value in the search conditions

Predicates II

FULL JOIN and MySQL

Using multiple tables in a query

Once more about NULL values

Typical problems

CONCAT function

New sql features

Default values

Data Definition Language (SQL DDL)

The sorting and NULL values

Getting summarizing values

Three-valued logic and WHERE clause

Typical problems

Exercise #55

Database «Ships»

CASE statement

SELECT statement

Exercise #32

Database «Ships»

Exercise #(-2) (tips and solutions)

Tips and solutions

Exercise #26

Computer Firm Database

Exercise #60 (tips and solutions)

Tips and solutions