mystery.knightlab.com
SQL Murder Mystery
· Use SQL queries to solve the murder mystery. Suitable for beginners or experienced SQL sleuths. · Shared by 97, including @AlgoCompSynth@ravenation.club by znmeb, Matthew Turland, Esther Schindler, Data Science Renee, 𝚛𝚘𝚐𝚎𝚛, Randy Olson, Fabrizio Bianchi, Chris Heilmann codepo8@toot.cafe, Mara Averick, Ben Jones, Bryan Onel
sqlite.org
SQL As Understood By SQLite
12+ min · · with-clause: Common Table Expressions or CTEs act like temporary views that exist only for the duration of a single SQL statement. There are two kinds of common table expressions: "ordinary" and… · Shared by 16, including Mattia Fregola 🤔, Fabrizio Bianchi, Peter Steinberger
Data Science Central
Understanding How SQL is Used in Data Science
8 min · · In the blog about ‘Is SQL Needed to be a Data Scientist?’, we have discussed the importance of SQL and basics of how knowledge of SQL helps with a successful d… · Shared by 17, including Dr. Craig Brown, Fabrizio Bianchi, Kirk Borne, Yves Mulkers
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
caitlinhudon.com
Git Your SQL Together (with a Query Library)
8 min · · Focusing on these points has led to my continuous adoption of a query library — a git repository for saving and sharing commonly (and uncommonly) used queries, all while tracking any changes … · Shared by 21, including Carl Morris, Cameron Yick ~ @hydrosquall@vis.social on mastodon, Data Science Renee, Mara Averick, Fabrizio Bianchi, Luca Hammer
slideshare.net
[LondonSEO 2020] BigQuery & SQL for SEOs
· Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See… · Shared by 12, including Fabrizio Bianchi, Alexis Sanders 🇺🇦
evanjones.ca
Why databases use ordered indexes but programming uses hash tables (evanjones.ca)
5 min · · I think it is safe to state that hash tables (e.g. maps in Go, dicts in Python, HashMap in Java, etc.) are far more common than ordered data structures such as trees for in-memory data structures. One… · Shared by 109, including Chris {he, they} , Matthias Lampe, Fabrizio Bianchi
seekwell.io
A Swiss Army knife for data teams
· With just a few clicks, schedule automatic updates every week, day, hour or every 5 minutes. Always have current data without endless manual updates. · Shared by 8, including Fabrizio Bianchi, Stephen C Sanders
getdbt.com
dbt (data build tool) - Transform data in your warehouse
1 min · · data build tool (dbt) is a command line tool that enables data analysts and engineers to transform data in their warehouse more effectively. · Shared by 34, including Matt, William El Kaim, Philippe Gauvin, Linus Basig, Nico Müller 🇺🇦, Evan Kirstel the $B2B Techfluencer, Ahmad Ragab, 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
schemaexplorer.io
Get the best view of your database
3 min · · Easily see diagrams, schema information & data. · Shared by 6, including Fabrizio Bianchi
panoply.io
Panoply Smart Cloud Data Warehouse
3 min · · Panoply is an AI-driven and autonomous cloud data warehouse. With Panoply, you can turn any siloed data into insights in minutes, without additional data engineering resources. · Shared by 12, including Jeremiah Owyang, Fabrizio Bianchi
numidian.io
Convert and transform any file
1 min · · Fast and modern tool to convert any data to SQL easily. Input up to 100Gb of CSV or JSON and output SQL or any other format to import into a database. · Shared by 10, including Tibor Martini 🇺🇦 @tibor@mastodon.social, Fabrizio Bianchi
datacamp.com
SQL Tutorial: How To Write Better Queries
20+ min · · In this SQL tutorial for beginners, you will learn about anti-patterns, execution plans, time complexity, query tuning, and optimization. · Shared by 19, including Fabrizio Bianchi
