SQL for Data Analysis
1h 11mIntermediate2023-07-17
Authors

Nikiya Simpson
MBA, Developer, Expert in Data-Driven Web Applications
Course details
If you’re looking to use Structured Query Language in 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 about your data and 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 Jupyter Notebook to help bring your 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 - Using SQL for data analysis
- 02 - What you should know
- 03 - Setting up Codespaces
- 04 - Getting started with a database in Codespaces
1. SQL Introduction and Asking the Right Questions
- 05 - A quick review of Structured Query Language (SQL)
- 06 - What is a relational database
- 07 - Common SQL structures
2. Using Data Types
- 08 - Using data types and identifying the wrong data types
- 09 - Finding missing values
- 10 - Finding possible inaccurate data values
- 11 - Finding duplicate rows
3. Working with Dates
- 12 - Working with dates
- 13 - Filtering data by dates
4. Easy SQL Functions
- 14 - Common SQL string functions
- 15 - Common SQL aggregate functions
- 16 - Introduction to data manipulation
5. Presenting Your SQL Results in Data Visualization
- 17 - Getting started with data visualization
- 18 - Creating data visualization
Conclusion
- 19 - Leveling up SQL
Related courses
- SQL for Data Analysis (2020)
- SQL for Exploratory Data Analysis Essential Training
- Advanced SQL for Data Scientists
- Advanced SQL for Data Science: Time Series
- Intermediate SQL for Data Scientists
- Intermediate SQL for Data Scientists (2021)
- Complete Guide to SQL for Data Engineering: from Beginner to Advanced
- Databricks for Data Analysts