SQL for Data Analysis

Learn fundamental SQL data analysis techniques especially useful for developers. Explore querying relational database values, filtering results, leveraging functions, and more.

Introduction

• Getting started with SQL analysis for developers: What is the data telling us?

1. SQL Introduction and Asking the Right Questions

• What is SQL? A quick review of Structured Query Language
• What is a relational database?
• Common SQL structure to begin asking the right questions for your data

2. Garbage In/Garbage Out: Identifying Bad Data in Your Projects

• Using data types and identifying the wrong data types
• Finding missing values
• Finding possible inaccurate data values
• Finding duplicate rows

3. Working with Dates in SQL

• Working with dates
• Filtering data by dates

4. Easy SQL Functions

• Common SQL string functions
• Common SQL aggregate functions
• Introduction to data manipulation

5. Presenting Your SQL Results in Data Visualization

• Getting started with data visualization
• Adding your SQL to BI tools

Conclusion

• Next steps