ben-nour/SQL-tips-and-tricks resource

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

2300 stars · 107 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A curated, opinionated collection of SQL tips and tricks covering formatting, data wrangling, performance, and common mistakes. It is written from the perspective of a working data analyst and applies to various RDBMSs like MySQL, SQLite, and Snowflake.

Use cases

• learn sql best practices
• improve sql query readability
• avoid common sql mistakes like not in with null
• optimize slow sql queries
• learn ctes and window function filtering
• sql tips for data analysts

When to choose

• you are a beginner or intermediate SQL user wanting practical, experience-based advice
• you want concise tips on formatting, joins, and query performance
• you work across multiple RDBMSs like MySQL, SQLite, or Snowflake

When to avoid

• you need comprehensive SQL documentation or a formal tutorial course
• you need dialect-specific advanced features for one database
• you want executable tooling rather than written guidance

Facets

learning-resource · maturity active

documentation databases tutorials data-science sql tips-and-tricks query-optimization data-analysis mysql sqlite snowflake

Member repositories

For agents

markdown · JSON · MCP: product_card(name="ben-nour/SQL-tips-and-tricks")