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

Exceptions

As you learn SQL you will run into exceptions. Sometimes, you will get an error. Sometimes, you might have logic errors (or just bad SQL) that runs but returns the wrong (or an empty) result.

2 Lessons