SQL for Data Analysis

Description

In this course, you will :

• Begins with a quick review of SQL fundamentals, then focuses on fundamental SQL queries used in the early stages of data analysis.
• explains the significance of asking the right questions of your data and how those questions translate into SQL
• demonstrates how these concepts can be used to derive quick insights from data to aid in effective decision-making.
• concludes the course by demonstrating how to incorporate queries into tools such as Microsoft Power BI to help bring data to life.

Syllabus :

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

Show more