SQL Analysis for Data Developers

SQL Analysis for Data Developers

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 01m | 217 MB


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.

+ Table of Contents

1 Getting started with SQL analysis for developers What is the data telling us
2 What is SQL A quick review of Structured Query Language
3 What is a relational database
4 Common SQL structure to begin asking the right questions for your data
5 Using data types and identifying the wrong data types
6 Finding missing values
7 Finding possible inaccurate data values
8 Finding duplicate rows
9 Working with dates
10 Filtering data by dates
11 Common SQL string functions
12 Common SQL aggregate functions
13 Introduction to data manipulation
14 Getting started with data visualization
15 Adding your SQL to BI tools
16 Next steps