Mastering SQL Selection - Professional
- Buy now
- Learn more
Installation

001-install.mov
Jupyter

002-jupyter.mov
Files for Course

SQL.ipynb
pres-er.png
alta-er.png
SQL Exercises.ipynb
SQL Cheatsheet
Course Overview

01-Pres-example.mp4
01-load-ex.mov
Connect to a Database

02-connecting.mp4
02-connecting-ex.mov
Selection

03-selection.mp4
03-selection-ex.mov
Exceptions

04-exceptions.mp4
04-exceptions-ex.mov
Counts

05-counts.mp4
05-counts-ex.mov
Filtering

06-filter.mp4
06-filter-ex.mov
Dates

07-dates.mp4
07-dates-ex.mov
Strings

08-strings.mp4
08-strings-ex.mov
NULL

09-null.mp4
09-null-ex.mov
Aggregations

10-groupby.mp4
10-groupby-ex.mov
Sorting

11-sorting.mp4
11-sortings-ex.mov
Filtering Aggregations

12-having.mp4
12-having-ex.mov
Query Parameters

13-query-params.mp4
13-qp-ex.mov

Counts

Counting is probably the most basic operation of a data scientist. It is probably one of the most useful metrics as well. Counts are used all over the place. Let's see how to do them with SQL!

2 Lessons