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

• Using SQL for data analysis
• What you should know
• Setting up Codespaces
• Getting started with a database in Codespaces

1. SQL Introduction and Asking the Right Questions

• A quick review of Structured Query Language (SQL)
• What is a relational database?
• Common SQL structures

2. Using Data Types

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

3. Working with Dates

• 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
• Creating data visualization

Conclusion

• Leveling up SQL