Sql
Explore recommended reads, summarized by AI
Advanced SQL Techniques
Specialized SQL features and patterns for complex analytical queries.
Common Table Expressions
Joins and Subqueries
Window Functions
AI and Automation
Explorations of using artificial intelligence to generate and work with SQL queries.
LLMs for Query Generation
Cloud Data Platforms
Guides to working with cloud-based data warehouses and their SQL capabilities.
BigQuery and ClickHouse
Databricks and Spark SQL
Snowflake Features and ETL
Data Quality
Methods for cleaning, validating, and deduplicating data using SQL.
Data Cleaning with SQL
Data Transformation Tools
Approaches to building and managing data pipelines with transformation frameworks.
dbt Workflows
Database Architecture
Comparisons and fundamentals of different database systems and their design choices.
Relational vs NoSQL Databases
Streaming Databases
Database Security
Vulnerabilities and protections related to SQL databases and query interfaces.
SQL Injection
Learning and Career Development
Resources for building SQL skills and applying them in data careers.
Learning SQL for Data Roles
SQL in Data Science
Query Performance
Techniques for writing faster queries and avoiding common performance pitfalls.
Database Performance Tuning
SQL Optimization Techniques
SQL and Python Integration
Techniques for bridging SQL databases with Python data analysis tools.
DuckDB and Pandas
SQL Fundamentals
Introductory guides to core SQL concepts and database structures.
