Skip to content

dmcmurchy/dmcmurchy.github.io

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 

Repository files navigation

A list of SQL resources that I've found useful for learning and practicing SQL

  1. DataLemur - Ace the SQL & Data Science Interview. Has numerous free questions for SQL that you can try and also get hints on how to solve the question.
  2. PostgreSQL Exercises - Loads of great questions that you can try out with the expected results listed.
  3. Advanced SQL Window Function Quiz - Test your knowledge of Modern SQL Window Functions
  4. HackerRank - Practice coding challenges & prep for interviews / Network
  5. DataCamp - Grow your data skills with DataCamp
  6. Select Star SQL - An interactive book to learn SQL on a real dataset.

Gamified SQL Resources

  1. The SQL Murder Mystery - Solve a Murder Mystery using your SQL Skills
  2. SQL PD - Learn SQL while solving crime - Build queries by drag and drop.

Handy Resources

  1. SQL Style Guide - An excellent guide for making sure your code is readable.
  2. dbdiagram.io - A free, simple tool to draw database diagrams (ERDs) by typing DSL code. dbdiagram uses the popular DBML (Database Markup Language).
  3. ChatGPT - While far from perfect I've found it a good resource to help get explanations for SQL code I've come across as well as a quick way to generate explanations to share with others for code I've written.
  4. Phind - AI search engine for Developers

More to come

  • Last edited: 2023-12-20 12:20 PST

About

A list of SQL resources that I've found useful

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages