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

SQL for Data Analysis (2020)

1h 2mBeginner2020-12-07

Authors

Nikiya Simpson

Nikiya Simpson

MBA, Developer, Expert in Data-Driven Web Applications

Course details

If you’re looking to get Structured Query Language into 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 of your data, as well as 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 Microsoft Power BI to help bring you 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 - Getting started with SQL analysis for developers - What is the data telling us

1. SQL Introduction and Asking the Right Questions

  • 02 - What is SQL A quick review of Structured Query Language
  • 03 - What is a relational database
  • 04 - Common SQL structure to begin asking the right questions for your data

2. Garbage In Garbage Out - Identifying Bad Data in Your Projects

  • 05 - Using data types and identifying the wrong data types
  • 06 - Finding missing values
  • 07 - Finding possible inaccurate data values
  • 08 - Finding duplicate rows

3. Working with Dates in SQL

  • 09 - Working with dates
  • 10 - Filtering data by dates

4. Easy SQL Functions

  • 11 - Common SQL string functions
  • 12 - Common SQL aggregate functions
  • 13 - Introduction to data manipulation

5. Presenting Your SQL Results in Data Visualization

  • 14 - Getting started with data visualization
  • 15 - Adding your SQL to BI tools

Conclusion

  • 16 - Next steps

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