Towards Data Science
My Top 3 SQL Interview Questions
6 min · · I frequently interview candidates for positions of Data Analysts, Data Engineers and Data Architects, and sometimes participate in… · Shared by 9, including Fabrizio Bianchi
mode.com
SQL SELECT | Basic SQL
5 min · · This SQL tutorial covers the SQL SELECT statement, which is used to retrieve data from a database based on criteria specified in the query. The SELECT statement has two fundamental parts—SELECT and… · Shared by 8, including Fabrizio Bianchi
GeeksforGeeks
SQL Tutorial
1 min · · Structured Query Language or SQL is a standard Database language which is used to create, maintain and retrieve the data from relational databases like MySQL,… Read More » · Shared by 10, including Fabrizio Bianchi
Towards Data Science
Learning SQL the Hard Way
15+ min · · Shared by 10, including Fabrizio Bianchi, Dr. Ganapathi Pulipaka 🇺🇸
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
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
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
datacamp.com
SQL with Tableau
6 min · · In this tutorial, you will learn how to connect Tableau to a Microsoft SQL Server database and then analyze the data to get insights. · Shared by 9, including Fabrizio Bianchi
Google Cloud
Getting started with BigQuery ML using the web UI
11+ min · · This tutorial introduces users to BigQuery ML using the BigQuery web UI. BigQuery ML enables users to create and execute machine learning models in BigQuery by using SQL queries. The goal is to… · Shared by 4, including Fabrizio Bianchi
Google Cloud
Working with Arrays in Standard SQL
14+ min · · In BigQuery, an array is an ordered list consisting of zero or more values of the same data type. You can construct arrays of simple data types, such as INT64, and complex data types, such as STRUCTs.… · Shared by 5, including Fabrizio Bianchi
Google Cloud
Standard SQL Data Types
11+ min · · BigQuery supports simple data types such as integers, as well as more complex types such as ARRAY and STRUCT. This page provides an overview of each data type, including allowed values. For… · Shared by 4, including Fabrizio Bianchi
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
wozniak.ca
What ORMs have taught me: just learn SQL
1 min · · Perhaps the most subversive issue I’ve had with ORMs is “attribute creep” or “wide tables”, that is, tables that just keep accruing attributes. As much as I’d like to avoid it, sometimes it becomes… · Shared by 78, including Massimiliano Aroffo, Fabrizio Bianchi, mastodon.social/@renestalder, Matthias Lampe
helenanderson.co.nz
10 Ways to Tweak Slow SQL Queries
5 min · · Before you rage quit or call in your DBA, check these things aren't causing slow SQL queries. A few tweaks could be all you need. · Shared by 73, including Fabrizio Bianchi, Michael Weibel, Esther Schindler
helenanderson.co.nz
SQL concepts: from A to Z
11+ min · · SQL concepts that pop up during SQL Server training, if you have a junior analyst in your life who needs a resource to refer to. · Shared by 6, including Fabrizio Bianchi
github.com
mattm/sql-style-guide
· An opinionated guide for writing clean, maintainable SQL. - mattm/sql-style-guide · Shared by 7, including Martina Pugliese