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 - sql-js/sql.js: A javascript library to run SQLite on the web.

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

<<<<<<< main

• The Only Database Abstraction You Need | Prime Reacts • A case for only using some ORM features while generally writing SQL directly • The Primeagen & MrCompSciGuy 📺 =======
• The Only Database Abstraction You Need | Prime Reacts • A case for only using some ORM features while generally writing SQL directly • The Primeagen 📺

origin/main

• 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 📺

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