SQL for Data Analysis
- Offered byLinkedin Learning
SQL for Data Analysis at Linkedin Learning Overview
Duration | 1 hour |
Total fee | ₹899 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
SQL for Data Analysis at Linkedin Learning Highlights
- 5 quizzes
- Access on tablet and phone
SQL for Data Analysis at Linkedin Learning Course details
- 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 learner's data, as well as how those questions translate into SQL
- She also shows how these concepts can be used to derive quick insights from learner's data to help drive effective decision-making
SQL for Data Analysis at Linkedin Learning Curriculum
Introduction
Getting started with SQL analysis for developers: What is the data telling us?
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
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
Working with Dates in SQL
Working with dates
Filtering data by dates
Easy SQL Functions
Common SQL string functions
Common SQL aggregate functions
Introduction to data manipulation
Presenting Your SQL Results in Data Visualization
Getting started with data visualization
Adding your SQL to BI tools
Conclusion
Next steps