SQL Tips and Tricks for Data Science
59mIntermediate2021-12-09
Authors
Ben Sullins
Data Geek, Tech Consultant
Course details
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.
Skills covered
Tips, Tricks, & TechniquesSQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Extract meaning from data
- 02 - What you should know before watching this course
- 03 - Using the exercise files
1. SQL Tips and Tricks
- 04 - Retrieve data using SQL
- 05 - Join tables
- 06 - Filter data
- 07 - Aggregate data
- 08 - Window functions
- 09 - Subqueries
- 10 - Rolling calculations
- 11 - Analyze employee data
- 12 - Date and time functions
- 13 - Common table expressions
- 14 - Year-over-year calculations
- 15 - Finding ranks
Conclusion
- 16 - Becoming a powerful data scientist