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
DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Scrimba Ad

Get 20% off all career paths from fullstack to AI

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Learn fundamental SQL data analysis techniques especially useful for developers. Explore querying relational database values, filtering results, leveraging functions, and more.

Syllabus

Introduction
  • Getting started with SQL analysis for developers: What is the data telling us?
1. SQL Introduction and Asking the Right Questions
  • What is SQL? A quick review of Structured Query Language
  • What is a relational database?
  • Common SQL structure to begin asking the right questions for your data
2. Garbage In/Garbage Out: Identifying Bad Data in Your Projects
  • Using data types and identifying the wrong data types
  • Finding missing values
  • Finding possible inaccurate data values
  • Finding duplicate rows
3. Working with Dates in SQL
  • 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
  • Adding your SQL to BI tools
Conclusion
  • Next steps

Taught by

Nikiya Simpson

Reviews

4.7 rating at LinkedIn Learning based on 1006 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.