– Select statements
– Giving the output field a different name
– Using Where statements to get the exact records you are looking for
– Using Order By statements to sort the data
– Creating Subtotals with the Group By statement
– Introduction to joining tables together
The files mentioned in the video will be in the link that is included with the video.