Learn Data Analytic: Mode

Learn Data Analytic

-Time Series

-User Engagement

-Crunchbase D3

http://sqlschool.modeanalytics.com/

Section 1-SQL The Basic

1. Introduction 
2. Basic Concept
3. Retrieving Data Drom The Database
4. Filtering Data and Making Simple Calculations
5. Using Multiple Filters at Once
6. Ordering Your Result

Section 2-SQL Intermidiate

1. Using SQL to replace pivot tables
2. Aggregating within Categories
3. Counting unique values in column
4. Conditional Logic to Define New Columns
5. Joins
6. Inner Joins
7. Outer Joins
8. Left / Right Joins
9. Full Joins
10. Union
11. Join Tips dan Tricks

Section 3-SQL Advanced

1. Data Type
2. Wrangling Messy Data - Cleaning Strings
3. Subqueries
4. Window Functions - more @ Postgres Documentation
5. Making Queries Run Faster

Section 4-Analytic Training

1. Yammer - A drop in Engagement