Видео с ютуба Zrozumsql

The Hash Join Algorithm: The Hash Table | SQL Course 11.12 (PL)

GRANT in PostgreSQL: Granting Privileges to Roles Step by Step | SQL Course 04.05 (PL)

[ZROZUMSQL] SELECT *, czyli o tym jak SQL może być podstawą świetnej kariery.

Aggregate and Window Function Exercises: ROLLUP, LAG, LAST_VALUE | SQL Course 08.13 (PL)

DISTINCT in SQL: Removing Duplicates and When to Avoid It | SQL Course 06.06 (PL)

Module 4 Exercises: Roles, GRANT, REVOKE and Foreign Keys, with Solutions | SQL Course 04.09 (PL)

SQL Join Exercises: JOIN, UPDATE with EXISTS and the Project | SQL Course 07.16 (PL)

The Course Project: a Home Budget, Business and Functional Requirements | SQL Course 02.16 (PL)

DISTINCT ON in PostgreSQL: One Row per Group with ORDER BY | SQL Course 06.07 (PL)

Window Functions in Practice: AVG OVER (PARTITION BY) and ROW_NUMBER | SQL Course 08.07 (PL)

Exercises: System Tables, Passwords and Data Quality | SQL Course 12.11 (PL)

Roles in PostgreSQL: CREATE ROLE, LOGIN and the PUBLIC Role | SQL Course 04.04 (PL)

TRUNCATE vs DELETE in SQL: Differences, Disk Space, RESTART IDENTITY | SQL Course 05.12 (PL)

How to Read Complex SQL Queries: From the Inside Out | SQL Course 06.05 (PL)

UNION vs UNION ALL in SQL: the Difference and the Rules | SQL Course 06.14 (PL)

ANY, ALL, SOME, IN and NOT IN in SQL: Comparing Against a List | SQL Course 06.11 (PL)

Exercises on Views, Procedures and Triggers in SQL | SQL Course 09.13 (PL)

WITH (CTE) in SQL: Cleaner Queries and WITH with DELETE | SQL Course 07.12 (PL)

SQL Antipatterns Exercise: Review Your Own Project | SQL Course 10.14 (PL)

Exploring a Database Structure With SQL Only | SQL Course 12.05 (PL)