Skip to content

Instantly share code, notes, and snippets.

@macfergusson

macfergusson/SQL_Resources.md

Last active July 18, 2024 13:06
Show Gist options
  • Save macfergusson/8b4a57626257e0b422e26435b4946f93 to your computer and use it in GitHub Desktop.
Save macfergusson/8b4a57626257e0b422e26435b4946f93 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Community Discord Resources
Raw
SQL_Resources.md

SQL Community Discord Resource List

This content collected and curated for the SQL Discord, join us!

Table of Contents

Share Code

These tools allow you to create and share executable SQL queries:

https://dbfiddle.uk/

https://sqlfiddle.com/

SQL Tutorials and Study Courses

https://sqlzoo.net/

https://sqlbolt.com/

https://selectstarsql.com/

https://www.sqlcourse.com/

https://dataschool.com/learn-sql/

https://www.udemy.com/topic/sql/free/

https://www.codecademy.com/learn/learn-sql/

https://mode.com/sql-tutorial/introduction-to-sql/

https://www.khanacademy.org/computing/computer-programming/sql

https://mystery.knightlab.com/

https://www.w3schools.com/sql/default.asp

https://datalemur.com/sql-tutorial

https://www.learnsqlonline.org/

http://solhsa.com/galaxql.html

https://www.edx.org/learn/sql

https://learnsql.com/

https://www.sololearn.com/en/learn/courses/data-programming

https://www.sqltutorial.org/

https://www.tutorialspoint.com/sql/

Once you get through the basics, you may want to pick a particular platform to focus on. Common choices are Oracle, SQL Server, MySQL, Postgres, etc.

SQL Challenges

https://www.codewars.com/kata/sql/

https://www.hackerrank.com/domains/sql/

https://leetcode.com/problemset/database/

https://www.stratascratch.com/

Other Coding Challenges

https://projecteuler.net/

https://exercism.org/tracks/

https://www.codingame.com/start/

Diagramming and Normalization

https://dbdiagram.io/home/

https://arctype.com/blog/er-diagram/

https://www.youtube.com/watch?v=GFQaEYEc8_8

Useful links for creating Entity Relationship Diagrams, Schema Models, etc

https://www.dbdesigner.net/

https://dbdiagram.io/home

https://draw.io/

What aspect of SQL, Data, Analytics etc should I concentrate on?

This is exactly why it's best to "dabble around" at first and feel out the different aspects of working with data, so you can find where you would most like to spend your time and efforts later. You won't discover that until you get your hands on a little bit of everything. Learn a little DBA stuff, some database design stuff, some ETL, how to use tools like Excel and PowerBI, how transactional systems differ in needs from analytical systems, make reports, charts, hell make an application in python or VB or something that connects to the database and reads some data out. Read a lot. Ask questions. Touch things. Break them. Fix them. You will come out on the other side knowing who you are and where you want to go next. For now, just jump in the pool somewhere. https://discord.com/channels/698642420497383504/698642858885906494/1172608094765850674

Recommended books:

SQL Basics

Transaction Processing

Database Systems

Data Warehousing

Database Design and Modeling

Database Internals

Administration and Performance

Articles

Video content on YouTube:

References for Specific Relational Database Management Systems

MySQL

https://www.mysqltutorial.org/

SQLite

Postgres

https://www.postgresqltutorial.com/

https://wiki.postgresql.org/wiki/Developer_FAQ#Where_can_I_get_a_copy_of_the_SQL_standards.3F

http://www.interdb.jp/pg/pgsql01.html

Oracle

https://www.oracletutorial.com/

http://philip.greenspun.com/sql/

SQL Server

The popularity contest

https://db-engines.com/en/ranking

Standardized date format (Objectively the best)

https://xkcd.com/1179/

ISO 8601 was published on 06/05/88 and most recently amended on 12/01/04.

Useful Explainer Images

Logical Processing Order Image

Azure Types Explainer Image

Join Explainer Image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment