One of the hardest things for a non-SQL expert to do build queries which transform data. This session goes through the basics of SQL Operators that can be used to get total counts, transform a number code into the useful text, work with dates, and create subselect queries like a pro.
- Counts
- Sum
- Datediff
- Case statements
- Subselect queries
- Column Naming
- Aliases
- SQL query formatting
- Tips and Tricks