SQL Tips and Tricks for Data Science

Focused View

Ben Sullins and Free the Data Academy

59:23

0 View

01 - Introduction

01 - Extract meaning from data.mp4

01:04

02 - What you should know before watching this course.mp4

00:57

03 - Using the exercise files.mp4

00:32

02 - 1. SQL Tips and Tricks

01 - Retrieve data using SQL.mp4

04:18

02 - Join tables.mp4

05:44

03 - Filter data.mp4

05:33

04 - Aggregate data.mp4

06:29

05 - Window functions.mp4

01:54

06 - Subqueries.mp4

04:16

07 - Rolling calculations.mp4

04:48

08 - Analyze employee data.mp4

04:18

09 - Date and time functions.mp4

05:11

10 - Common table expressions.mp4

05:55

11 - Year-over-year calculations.mp4

03:26

12 - Finding ranks.mp4

04:09

03 - Conclusion

01 - Becoming a powerful data scientist.mp4

00:49

Description

Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists. Ben's tips focus on practical applications of SQL queries for data analysis. Learn how to retrieve data, join tables, calculate rolling averages and rankings, work with dates and times, use window functions, aggregate and filter data, and much more. Each tip is short, relevant, and up to date with current industry best practices—making this the perfect course for busy analysts who normally struggle to find time to build their skills.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Ben Sullins and Free the Data Academy

Instructor's Courses

I run Free the Data Academy which offers high-quality Data Skills training online. I've worked in data since the late 90's in nearly every role out there and in 2013 began sharing what I've learned through online courses. You can find my courses here on LinkedIn and on my own academy at FTDAcademy.com

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.