• the select statement
• set operations
• other data manipulation statements
• joins
• data definition statements
• transaction control statements
• a comparison with the SAS data step
• the SAS dialect of SQL

More advanced usage

• window functions
• linear regression using SQL
• analysis of variance using SQL
• survival analysis using SQL

For information on statistical analysis see statistics_101.