Author
Dan Sullivan
Released
5/22/2017The course begins with a brief overview of SQL. Then the five major topics a data scientist should understand when working with relational databases: basic statistics in SQL, data preparation in SQL, advanced filtering and data aggregation, window functions, and preparing data for use with analytics tools.
- Data manipulation
- ANSI standards
- SQL and variations
- Statistical functions in SQL
- String, numeric, and regular expression functions in SQL
- Advanced filtering techniques
- Advanced aggregation techniques
- Windowing functions for working with ordered data sets
Skill Level Advanced
Duration
Views
- [Dan] Hi, I'm Dan Sullivan. And in this course, I'll be describing how to use SQL for data science. We'll start by reviewing the basics of SQL data manipulation, and data definition commands. We'll cover how to use SQL queries to collect and prepare data for analysis, and introduce basic statistical functions, to help you better understand your data. We'll explore the rich set of options for constructing SQL queries. Including operations for filtering, joining, and aggregating data. We'll also delve into more advanced functions, for rollups and cubes, along with window functions that can greatly simplify complex operations, especially those involving time series.
So let's take a deep dive into SQL for data science.
-
Introduction
-
Welcome42s
-
Exercise files50s
-
-
1. SQL as a Tool for Data Science
-
SQL data definition features5m 32s
-
2. Basic Statistics with SQL
-
Installing PostgreSQL2m 37s
-
CREATE TABLE and INSERT DATA2m 28s
-
Statistical functions4m 21s
-
-
3. Data Munging with SQL
-
Reformatting character data4m 41s
-
Reformatting numeric data3m 25s
-
-
4. Filtering, Joins, and Aggregation
-
Subqueries in SELECT clauses2m 57s
-
Subqueries in FROM clauses1m 59s
-
Subqueries in WHERE clauses1m 38s
-
Joining tables3m 42s
-
Creating a view2m 23s
-
-
5. Window Functions and Ordered Data
-
Window functions: RANK1m 25s
-
LAG and LEAD3m 3s
-
NTILE functions2m 20s
-
6. Preparing Data for Analytics Tools
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome