Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
SQL for Data Analysis

SQL for Data Analysis

1h 11mIntermediate2023-07-17

Authors

Nikiya Simpson

Nikiya Simpson

MBA, Developer, Expert in Data-Driven Web Applications

Course details

If you’re looking to use Structured Query Language in your application development but your story is more prequel than SQL, you need to build a solid foundational knowledge of SQL analysis. In this course, instructor Nikiya Simpson starts with a quick review of SQL basics, then focuses on fundamental SQL queries used in beginning data analysis. Nikiya explains the importance of asking the right questions about your data and how those questions translate into SQL. She also shows how these concepts can be used to derive quick insights from your data to help drive effective decision-making. Nikiya finishes the course by demonstrating how to incorporate queries into tools like Jupyter Notebook to help bring your data to life.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

  • 01 - Using SQL for data analysis
  • 02 - What you should know
  • 03 - Setting up Codespaces
  • 04 - Getting started with a database in Codespaces

1. SQL Introduction and Asking the Right Questions

  • 05 - A quick review of Structured Query Language (SQL)
  • 06 - What is a relational database
  • 07 - Common SQL structures

2. Using Data Types

  • 08 - Using data types and identifying the wrong data types
  • 09 - Finding missing values
  • 10 - Finding possible inaccurate data values
  • 11 - Finding duplicate rows

3. Working with Dates

  • 12 - Working with dates
  • 13 - Filtering data by dates

4. Easy SQL Functions

  • 14 - Common SQL string functions
  • 15 - Common SQL aggregate functions
  • 16 - Introduction to data manipulation

5. Presenting Your SQL Results in Data Visualization

  • 17 - Getting started with data visualization
  • 18 - Creating data visualization

Conclusion

  • 19 - Leveling up SQL

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal