SQL Learning Resources

Collection of various SQL related materials for learning

Vasav

1 minute read

Introduction

As someone who works with data, learning SQL is super important. It’s like the ABCs of data stuff! You’ll use SQL in lots of places, so it’s crucial to get really good at it. Especially in the world of big data, there’s this cool thing called Spark SQL that lets you use your SQL skills to do all sorts of important tasks. In this blog, I’m putting together a bunch of helpful resources about SQL. And guess what? I’ll keep adding more stuff as I find it! So, keep an eye out for updates!

Tutorials

  1. sqlbolt
  2. w3schools
  3. selectstarsql
  4. sqlzoo
  5. use-the-index-luke
  6. 8weeksqlchallenge
  7. mode
  8. datalemur

Video Tutorials

  1. SQL by Sumit Mittal
  2. Seattle Data Guy - How To Write Better SQL In 7 Minutes
  3. techTFQ
  4. Setting up postgres docker container locally

Practice SQL

  1. mysql-sample-db
  2. pgexercises
  3. Live SQL - Oracle
  4. analystbuilder
  5. dataford
  6. interviewquery

Blog Posts

  1. DB datetime tips
  2. Insert in mssql using pandas
  3. Generating Fake Data

Books

  1. Data-Warehouse-Toolkit-Definitive-Dimensional
  2. SQLBook
  3. sql
  4. introduction-to-sql