SQL for Data Analysis

Go to class
Write Review

Free Online Course: SQL for Data Analysis provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL for Data Analysis is taught by Nikiya Simpson.

Overview
  • 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