Learn fundamental SQL data analysis techniques especially useful for developers. Explore querying relational database values, filtering results, leveraging functions, and more.
Overview
Syllabus
Introduction
- Getting started with SQL analysis for developers: What is the data telling us?
- 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
- Using data types and identifying the wrong data types
- Finding missing values
- Finding possible inaccurate data values
- Finding duplicate rows
- Working with dates
- Filtering data by dates
- Common SQL string functions
- Common SQL aggregate functions
- Introduction to data manipulation
- Getting started with data visualization
- Adding your SQL to BI tools
- Next steps
Taught by
Nikiya Simpson
