franchise.cloud
Franchise: a sql notebook
2 min · · an open-source notebook for sql Open App → No sign up, no install. Chart with a single click. Compare queries side by side. Download your work and share it with anyone. If your data is in a CSV, JSON,… · Shared by 63, including Moritz Klack, Daniel Bentes, Fabrizio Bianchi, Balda, Clemens, Stephen C Sanders, Bryan Onel, Jesús Torres 👩💻, bouiboui, René Clausen Nielsen, Tibor Martini 🇺🇦 @tibor@mastodon.social
hakibenita.com
Practical SQL for Data Analysis
· What you can do without Pandas · Shared by 62, including Topi Tjukanov, Fabrizio Bianchi, ITNEXT, Nico Müller 🇺🇦, Real Python, Mike Tamir, PhD, Mark Tabladillo PhD, Lynn Cherny
coding-geek.com
How does a relational database work
· An in-depth article that explains how a relational database handles an SQL query and the basic components inside a database. · Shared by 60, including rohit, Charlie O'Keefe @charlieok@hachyderm.io, PotHix, Brian, Fabrizio Bianchi
Towards Data Science
Six Spark Exercises to Rule Them All
17+ min · · Some challenging Spark SQL questions, easy to lift-and-shift on many real-world problems (with solutions) · Shared by 58, including Fabrizio Bianchi, Vinod Sharma, Donneker, Nige Roberts-Willson, Andreas Staub
jvns.ca
SQL queries don't start with SELECT
4 min · · Okay, obviously many SQL queries do start with SELECT (and actually this post is only about SELECT queries, not INSERTs or anything). But! Yesterday I was working on an explanation of window… · Shared by 54, including Nico Müller 🇺🇦, Tibor Martini 🇺🇦 @tibor@mastodon.social, Fabrizio Bianchi, Dr. Ganapathi Pulipaka 🇺🇸, Eliska Hutnikova
DEV Community
8 New SQL Tools That Will Change How You Work in 2020
5 min · · When it comes to working with SQL, we all want the same things: speed and scale. And on top of that we, want to be easy—maybe even fun. From data collection to processing, to analysis, to putting it… · Shared by 51, including Phillip Murphy, Simon07, Fabrizio Bianchi, Tibor Martini 🇺🇦 @tibor@mastodon.social, @AlgoCompSynth@ravenation.club by znmeb
sqlbolt.com
SQLBolt - Learn SQL - Introduction to SQL
2 min · · SQLBolt provides a set of interactive lessons and exercises to help you learn SQL · Shared by 45, including Nico Müller 🇺🇦, Luca Like, Fabrizio Bianchi, Luis Bravo, Data Science Renee
use-the-index-luke.com
SQL Indexing and Tuning e-Book
2 min · · SQL indexing and tuning tutorial for developers.
No unnecessary database details—just what developers need to know.
Covers all major SQL databases. · Shared by 45, including Florian Hanke 🍎, Cedric Meury, Nils Hitze, Jakub Ferenc, Brian, Fabrizio Bianchi
chartio.com
We made SQL visual
9 min · · Through months of design, prototypes, and user tests we made a visual version of SQL - which has proven to enable 80% of business users to write complex quer… · Shared by 43, including Bryan Onel, Mike Tamir, PhD, Fabrizio Bianchi
metabase.com
Best practices for writing SQL queries
9 min · · SQL best practices: a brief guide to writing better SQL queries. · Shared by 41, including Fabrizio Bianchi, Matthew Turland, Esther Schindler
sqlwiki.netspi.com
SQL Injection Wiki
1 min · · This wiki's mission is to be a one stop resource for fully identifying, exploiting, and escalating SQL injection vulnerabilities across various Database Management Systems. · Shared by 38, including Oleg Baskov, Nico Müller 🇺🇦, Fabrizio Bianchi
sqlpd.com
Learn SQL while solving crimes! SQL Police Department
· SQL Police Department is an online game where you solve crimes using SQL (and learn SQL in the process). Learn SQL while playing a game! · Shared by 37, including mastodon.social/@renestalder, Fabrizio Bianchi
dbdiagram.io
Database Relationship Diagrams Design Tool
1 min · · Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard · Shared by 37, including Mike Ivars, Fabrizio Bianchi, Balda, Waqas Ahmed
youtube.com
How SQL Database Engines Work
· Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008. The description: To many programmers, SQL RDBMSes are a ma... · Shared by 37, including Oleg Baskov, rohit, Fabrizio Bianchi
blog.acolyer.org
Millions of tiny databases
7 min · · Millions of tiny databases, Brooker et al., NSDI’20 This paper is a real joy to read. It takes you through the thinking processes and engineering practices behind the design of a key part of … · Shared by 34, including Nico Müller 🇺🇦, Tom Connor, Fabrizio Bianchi
selectstarsql.com
Select Star SQL
1 min · · This is an interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn't require registration or downloads. It helps you learn by… · Shared by 34, including Joe Germuska, Data Science Renee, Fabrizio Bianchi