SQL

TODO

Articles

• What ORMs have taught me: just learn SQL

• SQL vs NoSQL is the Wrong Distinction

• Write an SQL query builder in 150 lines of Python!

• Why You Should Learn SQL

• Against SQL

• SQL Join Types Explained Visually

• SQL Query Optimization: Understanding Key Principle

• Efficient SQL on Pandas with DuckDB

• Best practices for writing SQL queries

• How to create a 1M record table with a single query

• How Materialize and other databases optimize SQL subqueries

• SQL and aggregated data: is there a better way?

• Reasons why SELECT * is bad for SQL performance

• SQL Cheat Sheet: Top 10 Most Important SQL Commands To Know

• How to level up your SQL skills

• We Can Do Better Than SQL

• Implementing subqueries in go-mysql-server

• Scaling relational SQL databases

• Some SQL Tricks of an Application DBA

• SQL for the rest of us

• SELECT wat FROM sql

• Writing a SQL database from scratch in Go: 1. SELECT, INSERT, CREATE and a REPL

• Domain Logic and SQL

• NULL Values in SQL Queries

• When an SQL database makes a great Pub/Sub

• How a SQL database works

• SQL queries don't start with SELECT

• 5 заданий по SQL с реальных собеседований

• Что такое DDL, DML, DCL и TCL в языке SQL

• Оконные функции в SQL — что это и зачем они нужны

• 6 SQL-запросов, о которых должен знать каждый дата-инженер

Courses / Videos

• Introduction to Databases and SQL Querying

• Databases and SQL for Data Science with Python

• Introduction to SQL

• Joining Data in SQL

• Intermediate SQL - (DataCamp)

• Advanced SQL Questions From Amazon (Handling complex logic in data science interviews)

• SQL Tutorial for Beginners

• Cracking the SQL coding interview

• SQL Tutorial - Full Database Course for Beginners

• SQL на котиках: Джоины (Joins)

Books

• Руководство по SQL

• Язык SQL. Базовый курс

• SQL и реляционная теория. как грамотно писать код на sql (К.ДЖ.Дейт)

Links

• Solve challenge (SQL)

• SQL train

• SQL bolt

• SQL Templates

• Learn SQL

• SQLizer - Convert your excel file into a MySQL script with a table definition and multiple INSERT statements.

• SQL overview

• Advanced SQL and database books and resources

• Mastery with SQL

• Modern SQL

• Learn X in Y minutes Where X=SQL

• SQL joins cheatsheet

• Comparison of different SQL implementations

• SQL linter

• Falcon - Free, open-source SQL client for Windows and Mac

• Quick SQL Cheatsheet