SQL

Introduction

• SQL Explained in 100 Seconds • Fireship 📺

General

• SQL and PDO Operations Reference | Tania Rascia
• SQL queries don’t start with SELECT • Julia Evans 📖
• Notes on building SQL exercises • Julia Evans 📖
• GitHub - ben-n93/SQL-tips-and-tricks: SQL tips and tricks • Ben Nour 📖

Syntax

• Understanding SQL SELECT and WHERE • WHERE filters out rows and SELECT filters out columns • Edward Loveall 📖
• Understanding SQL JOIN • JOIN combines the columns from two tables into one larger table (to allow returning extra cross-referenced data) • Edward Loveall 📖

PostgreSQL

• PostgreSQL in 100 Seconds • Fireship 📺
• Neon — Serverless, Fault-Tolerant, Branchable Postgres • Postgres in the cloud with a generous free tier 🛠

ORMs

• The Only Database Abstraction You Need | Prime Reacts • A case for only using some ORM features while generally writing SQL directly • The Primeagen 📺
• JS ecosystem:
  • I tried 8 different Postgres ORMs • Compares pg, postgres.js, knex, kysely, sequelize, typeorm, prisma and drizzle and recommends Prisma or Drizzle • Beyond Fireship 📺

Other Tools

• sq | wrangle data • Like jq, but for structured data like sql query results • Neil O’Toole 🛠️

Inbox

• MySQL - The Basics // Learn SQL in 23 Easy Steps

• MySQL Tutorial for Beginners [Full Course]

• SQL Tutorial for Beginners

• Learn SQL In 60 Minutes

• Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

• you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

• SQL Beginner to Advanced in One Hour | CareerFoundry Webinar

• Free SQL Tutorial for Data Analysts & Data Scientists

• flaviocopes.com/tags/database/

• SQL Tutorial for Beginners • Also acts as a Postgres walkthrough for beginners • Ben Awad 📺

• sql: SQL Introduction

• mysql - Where to store SQL commands for execution - Stack Overflow - recommends storing queries as files and reading those files into an in-memory object at app startup

• sql - What is the difference between “INNER JOIN” and “OUTER JOIN”? - Stack Overflow - inner join is the intersection (inner part of venn diagram); outer join is the union (entire venn diagram) - Stack Overflow

• Visual Representation of SQL Joins - CodeProject - Lots of helpful Venn diagram infographics - C. L. Moffatt

• The Secret Weapon Every Software Engineer Needs In 2023 - SQL skills will reduce your IO bottlenecks - Isaac Harris-Holt

• Learn SQL - Programiz

• sq • Like jq, but for database query responses • sq 🛠️

• Distinct in SQL: A Comprehensive Guide