SQL for Data Analysis (2020)
1h 2mBeginner2020-12-07
Authors

Nikiya Simpson
MBA, Developer, Expert in Data-Driven Web Applications
Course details
If you’re looking to get Structured Query Language into your application development, but your story is more prequel than SQL, you need to build a solid foundational knowledge of SQL analysis. In this course, instructor Nikiya Simpson starts with a quick review of SQL basics, then focuses on fundamental SQL queries used in beginning data analysis. Nikiya explains the importance of asking the right questions of your data, as well as how those questions translate into SQL. She also shows how these concepts can be used to derive quick insights from your data to help drive effective decision-making. Nikiya finishes the course by demonstrating how to incorporate queries into tools like Microsoft Power BI to help bring you data to life.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Getting started with SQL analysis for developers - What is the data telling us
1. SQL Introduction and Asking the Right Questions
- 02 - What is SQL A quick review of Structured Query Language
- 03 - What is a relational database
- 04 - Common SQL structure to begin asking the right questions for your data
2. Garbage In Garbage Out - Identifying Bad Data in Your Projects
- 05 - Using data types and identifying the wrong data types
- 06 - Finding missing values
- 07 - Finding possible inaccurate data values
- 08 - Finding duplicate rows
3. Working with Dates in SQL
- 09 - Working with dates
- 10 - Filtering data by dates
4. Easy SQL Functions
- 11 - Common SQL string functions
- 12 - Common SQL aggregate functions
- 13 - Introduction to data manipulation
5. Presenting Your SQL Results in Data Visualization
- 14 - Getting started with data visualization
- 15 - Adding your SQL to BI tools
Conclusion
- 16 - Next steps