There are 40 queries that cover a number of topics in SQL, covering data engineering, data science, and database searching. Topics include:
- Retrieving data from single and multiple tables
- Inserting, updating, and deleting data
- Summary queries (aggregate, grouping, summarizing, window, named window, frame functions)
- Joins and subqueries (correlated, uncorrelated, SELECT/FROM/WHERE subqueries, complex, common table expressions)
- Casting, converting, and formatting data types (character, integer, fixed-point, floating-point, date, time, date and time, large objects)
- Date time data types (passing, extracting, date time calculations)
- IF / IF NULL/ COALESCE and CASE statements
- Regular expression functions
- Ranking functions