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