SQL for Data Analysis

Focused View

Nikiya Simpson

1:11:13

123 View

01 - Introduction

01 - Using SQL for data analysis.mp4

00:36

02 - What you should know.mp4

01:07

03 - Setting up Codespaces.mp4

04:59

04 - Getting started with a database in Codespaces.mp4

00:55

02 - 1. SQL Introduction and Asking the Right Questions

01 - A quick review of Structured Query Language (SQL).mp4

04:24

02 - What is a relational database.mp4

06:03

03 - Common SQL structures.mp4

06:04

03 - 2. Using Data Types

01 - Using data types and identifying the wrong data types.mp4

05:46

02 - Finding missing values.mp4

05:16

03 - Finding possible inaccurate data values.mp4

04:05

04 - Finding duplicate rows.mp4

04:05

04 - 3. Working with Dates

01 - Working with dates.mp4

02:35

02 - Filtering data by dates.mp4

04:28

05 - 4. Easy SQL Functions

01 - Common SQL string functions.mp4

05:15

02 - Common SQL aggregate functions.mp4

03:05

03 - Introduction to data manipulation.mp4

05:30

06 - 5. Presenting Your SQL Results in Data Visualization

01 - Getting started with data visualization.mp4

03:36

02 - Creating data visualization.mp4

01:19

07 - Conclusion

01 - Leveling up SQL.mp4

02:05

Description

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.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out both Codespaces videos to learn how to get started.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Nikiya Simpson

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.