SQL-DataCamp-Exploratory Data Analysis in SQL

SQL-DataCamp-Exploratory Data Analysis in SQL

1. What’s in the Database

1.1 What’s in the database

1.2 Explore tables sizes

1.3 Count missing values

1.4 Join tables

1.5 The keys to the database

1.6 Foreign keys

1.7 Read and entity relationship diagram

1.8 Coalesce

1.9 Coalesce with a self-join

1.10 Column types and constrains

1.11 Effects of casting

1.12 Summarize the distribution of numeric values

2. Summarizing and Aggregating Numeric Data

2.1 Numeric data types and summary functions

2.2 Division

2.3 Explore with division

2.4 Summarize numeric columns

2.5 Summarize group statistics

2.6 Exploring distributions

2.7 Truncate

2.8 Generate series

2.9 More summary functions

2.10 Correction

2.11 Mean and Median

2.12 Creating temporary tables

2.13 Creating a temp table

2.14 Create a temp table to simplify a query

2.15 Insert in to a temp table

3. Exploring Categorial Data and Unstructured Text

3.1 Character data types and common issues

3.2 Count the categories

3.3 Spotting character data problems

3.4 Cases and Spaces

3.5 Trimming

3.6 Exploring unstructured text

3.7 Split strings on a delimiter

3.8 Shorten long strings

3.9 Strategies for multiple transformations

3.10 Create an “other” category with CASE WHEN

3.11 Group and recode values

3.12 Create a table with indicator variables

4. Working with Dates and Timestamps

4.1 Date/time types and formats

4.2 ISO 8601

4.3 Date comparisons

4.4 Date arithmetic

4.5 Completion time by category

4.6 Date/time components and aggregation

4.7 Date parts

4.8 Variation by day of week

4.9 Date truncation

4.10 Aggregation with date/time Series

4.11 Find missing dates

4.12 Custom aggregation periods

4.13 Monthly average with missing dates

4.14 Time between events

4.15 Longest gap

4.16 Rats

4.17 Wrap-up