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

LinkedIn Learning

SQL for Data Analysis

via LinkedIn Learning

Write review
Scrimba Ad

Get 20% off all career paths from fullstack to AI

Learn More → Corporate Finance Institute Ad

Build the Finance Skills That Lead to Promotions, Not Just Certificates

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
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 4142 ratings

Start your review of SQL for Data Analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.