SQL
16 videos • 81,192 views • by Becoming a Data Scientist
1
How to Install PostgreSQL 12 and pgAdmin 4 on Windows 10
Becoming a Data Scientist
Download
2
How to Load a Sample PostgreSQL Database in pgAdmin 4 (Pagila and Northwind)
Becoming a Data Scientist
Download
3
5 Basic SELECT Statement Queries in SQL
Becoming a Data Scientist
Download
4
The ORDER BY and LIMIT Clauses in SQL to Help With Sorting
Becoming a Data Scientist
Download
5
How to Filter with the WHERE clause in SQL
Becoming a Data Scientist
Download
6
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
Becoming a Data Scientist
Download
7
Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)
Becoming a Data Scientist
Download
8
SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)
Becoming a Data Scientist
Download
9
How to ROUND in SQL (includes up CEILING and down FLOOR)
Becoming a Data Scientist
Download
10
Using the TO_CHAR function in SQL Change Timestamp Output
Becoming a Data Scientist
Download
11
How to use the DATE_TRUNC Function in SQL (vs. TO_CHAR)
Becoming a Data Scientist
Download
12
[Deleted video]
Download
13
Combine SQL Queries With UNION, INTERSECT, EXCEPT
Becoming a Data Scientist
Download
14
How to do Subqueries in SQL with Examples
Becoming a Data Scientist
Download
15
SQL WITH Statements (Common Table Expressions - CTE)
Becoming a Data Scientist
Download
16
Writing CASE WHEN Statements in SQL (IF/THEN)
Becoming a Data Scientist
Download