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

Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Scientific Computing
University of Washington via Coursera Introduction to Data Science
University of Washington via Coursera Web Intelligence and Big Data
Indian Institute of Technology Delhi via Coursera