Search 6,000+ CA Community College Courses

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

Go to class Write review

Overview

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

Go to class

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.