SQL Tips and Tricks for Data Science

Offered By: LinkedIn Learning

Tags

SQL Courses Data Science Courses Relational Databases Courses

Course Description

Overview

Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists.

Syllabus

Introduction

Extract meaning from data
What you should know before watching this course
Using the exercise files

1. SQL Tips and Tricks

Retrieve data using SQL
Join tables
Filter data
Aggregate data
Window functions
Subqueries
Rolling calculations
Analyze employee data
Date and time functions
Common table expressions
Year-over-year calculations
Finding ranks

Conclusion

Becoming a powerful data scientist

Taught by

Ben Sullins

Related Courses

Introduction to Databases
Meta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX