Share Description
In this course, you will :
- Learn how to investigate what's available in a database, including the tables, relationships between them, and data stored in them.
- Along the way, you'll learn about coalescing and casting data.
- You'll extend functions like min and max to summarise numerical data in novel ways. Add the average, variance, correlation, and percentile functions to your toolbox, as well as the ability to truncate and round numeric values.
- Learn how to deal with case, spacing, and delimiter inconsistencies. Discover how to use a temporary table to recode messy categorical data into standardised values that can be counted and aggregated.
Syllabus :
- What's in the database?
- Summarizing and aggregating numeric data
- Exploring categorical data and unstructured text
- Working with dates and timestamps
