The language of SQL

Relational databases and SQL

Basic data retrieval

Calculated fields and aliases

Using functions

Sorting data

Selection criteria

Boolean logic

Inner joins

Outer joins

Self joins and views

Subqueries

Set logic

Stored procedures and parameters

Modifying data

Maintaining tables

Conditional logic

Summarizing data

Subtotals and crosstabs

Principles of database design

Strategies for displaying data