INTRODUCTION TO DATABASES AND SQL
• Database concepts
• Understanding SQL terminology
INTRODUCTION TO THE SELECT STATEMENT
• An overview of the SELECT statement
• Syntax rules you’ll want to know
CALCULATING DATA
• Aggregate functions
• Column aliases
• Performing calculations
• Date functions
SELECTING SPECIFIC ROWS
• The WHERE clause
• The ORDER BY clause
WORKING WITH OTHER OPERATORS
• Searching for text
• Logical operators
• NULLs

• The GROUP BY clause
• The HAVING clause
• Comparing the WHERE and HAVING clauses
MULTI-TABLE QUERIES
• Joins
• Joining tables
• Outer joins
QUERYING A DATABASE USING ACCESS
• Connecting to a database
• Querying a database
• Generating a report of the data