Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SQL for Data Analysis

via LinkedIn Learning

Write review

Financial Edge

The Investment Banker Certification

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

Learn fundamental SQL data analysis techniques especially useful for developers. Explore querying relational database values, filtering results, leveraging functions, and more.

Syllabus

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

Taught by

Nikiya Simpson

Reviews

4.6 rating at LinkedIn Learning based on 2186 ratings

Start your review of SQL for Data Analysis