Learn Relational Database Design and SQL

sql.md

Learning Relational Database Design and SQL

Learn SQL (interactive)

• SQLBolt
• SQLZoo
• GalaXQL
• Mode SQL Tutorial
• Datacamp: Intro to SQL for Data Science
• Codecademy Learn SQL
• Select Star SQL
• SQL Murder Mystery Walkthrough for SQL Beginners
• SQL Murder Mystery
• SQLCourse
• SQLCourse2
• SQLRU
• SQL Climber

Learn SQL (with exercises)

• PostgreSQL Exercises
• Study by Yourself SQL Course
• Kaggle: Intro to SQL
• Kaggle: Advanced SQL
• Strata Scratch - Interview Questions
• Sololearn SQL Course

Learn SQL (text form)

• Use the Index Luke
• An Intermediate MySQL Tutorial

Learn SQL (video)

• SQL Server playlist by kudvenkat
• SQL Server Queries playlist by wiseowl
• SQL Server Programming and Procedures playlist by wiseowl

Learn SQL (book)

• SQL Cookbook
• Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Note that the book links go to bookfinder.com, a book price comparison website. These links are not affiliate links.

Learn SQL (paid)

• Datacamp: Joining Data in PostgreSQL
• Mastery with SQL
• A Curious Moon

Learn Database Design

• Relational Model
• A quick start on database design
• Normalization
• An Introduction to Database Normalization
• 3 Normal Forms Database Tutorial
• Description of Database Normalization Basics
• Database Normalization and Techniques
• Creating a Quick MySQL Database
• Relational Database Design

Tools

• SQLfiddle - Online Database Environment
• DBfiddle - Another Online Database service
• db<>fiddle - Run Queries in batches, multiple dbms to choose from
• mycli - Command line interface for MySQL, MariaDB, Percona
• poorsql - SQL Formatter