juschan/sql_resources

SQL Resources

"college.db" and "python_to_database.ipynb" were prepared by John Wong. (Thanks John!)
"college_queries.sql" are for the DB Browser/sqlite3 exercises.

The following are links to useful SQL-related resources.

Learn or Challenge yourself on SQL through Games

• SQL Learning Game - Lost At SQL

Learn SQL through tutorials

• SQL Teaching
• W3schools - SQL
• Khan Academy - SQL
• SQL Zoo - SQL Tutorial
• SQLBolt
• Mode - Windows Functions. Has other tutorials
• Postgrestutorial - Create Functions, Has other tutorials
• Java T Point - Database and modelling tutorial. SQL Commands.

Articles

• The 6 Steps of a SQL Select Statement Process

DB Browser for SQLIte

• Tutorials for DB Browser for SQLite
• Wiki for DB Browser for SQLite

Window Function

• Apache Drill - Window FUnction
• learnsql - How to use the SQL Partition By with Over
• Mode - Window Function

Joins

The best way to think about joins is first to start with the concept of Cartesian Product, and thinking clearly about the conditions.

• Video - SQL: Cartesian Product, Joins
• Video - SQL: Outer Joins

Online DB/SQL Playground Editors

• DB Fiddle
• ExtendsClass - PostgreSQL online
• SQLPad
• SQLFiddle
• Postgres Playground

• • UI Backery - SQL Playground - private instanced postgreSQL database!!

Data Lineage

• SQLFlow