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