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 query problems
CONCAT function
New sql features
Default value definition
Data Definition Language (SQL DDL)
The sorting and NULL values
Getting summarizing values
Three-valued logic and WHERE clause
Typical query problems
Exercise #55
Database «Ships»
CASE statement
SELECT statement
Exercise #32
Database «Ships»
Exercise #(-2) (tips and solutions)
Tips & solutions
Exercise #26
Computer Firm Database
Exercise #60 (tips and solutions)
Tips & solutions