SQL for Data Analysis

SQL for Data Analysis

1h 11mIntermediate2023-07-17

Authors

Nikiya Simpson

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

Introduction

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

SQL Introduction and Asking the Right Questions

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

Using Data Types

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

Working with Dates

  • Working with dates
  • Filtering data by dates

Easy SQL Functions

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

Presenting Your SQL Results in Data Visualization

  • Getting started with data visualization
  • Creating data visualization

Conclusion

  • Leveling up SQL
40,000 Toman