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 Intro to Relational Databases
Udacity Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera Web Application Development: Basic Concepts
University of New Mexico via Coursera