Towards Data Science
How I’d Learn Data Science if I Could Start Over (2 years in)
11+ min · · My guide to learning data science as efficiently as possible · Shared by 115, including luis antónio santos, Sagun Shrestha, Fabrizio Bianchi, Dean of Big Data 🎓 #DOBD
Kaggle
Learn Intro to SQL Tutorials
· Learn SQL for working with databases, using Google BigQuery to scale to massive datasets. · Shared by 10, including Data Science Renee, Fabrizio Bianchi, Kirk Borne
Search Engine Land
How to get a Knowledge Panel for your brand, even without Wikipedia
8 min · · Your own site, Wikidata, third-party mentions and business databases can expand your Knowledge Graph entries in Google and Bing. · Shared by 33, including Fabrizio Bianchi, Bill Slawski ⚓ 🇺🇦, Aleyda Solis 🇺🇦, RebelMouse, Barry Schwartz
medium.com
4 SQL Tips for Data Scientists and Data Engineers
20+ min · · Please, don’t average averages · Shared by 7
slideshare.net
Modern SQL in Open Source and Commercial Databases
· SQL has gone out of fashion lately—partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL… · Shared by 15, including slumos, Fabrizio Bianchi, Florian Hanke 🍎
blog.jooq.org
A Probably Incomplete, Comprehensive Guide to the Many Different Ways to JOIN Tables in SQL
20+ min · · Perhaps the most powerful SQL feature is the JOIN operation. It is the envy of all non-relational databases, because the concept is so simple, yet so universally applicable, when you want to “… · Shared by 31, including Michael Duergner, Fabrizio Bianchi, Eliska Hutnikova, DON’T PANIC, dunschtig
freeCodeCamp.org
Learn SQL with These 5 Easy Recipes
5 min · · SQL is a powerful and expressive language for dealing with data from relational databases, but it can seem daunting to the uninitiated. · Shared by 13, including Fabrizio Bianchi
The New Stack
SQL Databases in a Cloud Native World
2 min · · Welcome to The New Stack Context, a podcast where we discuss the latest news and perspectives in the world of cloud native computing. For this week’s episode, we spoke with Peter Zaitsev, CEO of the… · Shared by 13, including Richard MacManus, Fabrizio Bianchi, William Toll
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
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
sqlnotebook.com
SQL Notebook
3 min · · SQL Notebook is a free Windows app for exploring and manipulating tabular data. It is powered by a supercharged SQLite engine, supporting both standard SQL queries and SQL Notebook-specific commands.… · Shared by 21, including Fabrizio Bianchi, Cameron Yick ~ @hydrosquall@vis.social on mastodon, Brian
blog.jooq.org
10 Cool SQL Optimisations That do not Depend on the Cost Model
20+ min · · Cost Based Optimisation is the de-facto standard way to optimise SQL queries in most modern databases. It is the reason why it is really really hard to implement a complex, hand-written algorithm i… · Shared by 15, including Fabrizio Bianchi, Florian Hanke 🍎
flashcards.wizardzines.com
SQL flashcards
· Shared by 10, including Fabrizio Bianchi, Vikram Dutt, Matthias Lampe
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
medium.com
Things I Wished More Developers Knew About Databases
20+ min · · A large majority of computer systems have some state and are likely to depend on a storage system. My knowledge on databases accumulated… · Shared by 441, including Mike Tamir, PhD, Dr. Ganapathi Pulipaka 🇺🇸, Matthias Lampe, Jaana Dogan ヤナ ドガン, Bryan Onel, Stefan Weber, Eliska Hutnikova, Balda, @brianleroux@indieweb.social 💙, Fabrizio Bianchi, Clemens
Towards Data Science
6 SQL Tricks Every Data Scientist Should Know
16+ min · · SQL tricks to make your analytics work more efficient · Shared by 213, including Dr. Ganapathi Pulipaka 🇺🇸, Carla Gentry 🎶, Fabrizio Bianchi