#SQL
8 articles
What is sqlc? A Practical Introduction to Type-Safe SQL in Go
Learn what sqlc is and how it generates type-safe Go code from SQL. A hands-on introduction using SQLite that covers the schema-to-code workflow, the benefits, and common pitfalls.
A Comprehensive Guide to Database Design: For Those Who Don’t Want to Stop at Beginner Level
A review of a thorough guide to database design for those who don't want to stop at the beginner level. It explains DB design systematically and clearly, covering the essentials of normalization and table design as a guide for stepping beyond the basics.
Beginning SQL, 3rd Edition
A review of Beginning SQL, 3rd Edition. An easy-to-understand SQL primer you will wish you had read early in your career, also just right for revisiting how to write basic queries and the underlying ideas, and easy to recommend to those starting out with SQL.
Practical Introduction to Databases: Efficient SQL through the Relational Model
A review of a practical introduction to databases taught from theory via the relational model. Learning databases from relational theory helps organize how you approach RDBs, grounding the principles behind efficient SQL in set theory and logic.
SQL Anti-Patterns
A review of SQL Antipatterns. A go-to classic that introduces the antipatterns you tend to fall into with databases and SQL, with clear explanations. Knowing common mistakes and how to avoid them helps with design and implementation decisions.
Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition
A review of Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition. A book for learning the varied expressions of SQL beyond the basics. Full of oh-you-can-write-it-this-way moments that expand your repertoire, it suits those who want to step beyond the beginner level.
SQL for Generating Test Data in MySQL
A note on how to generate test data using only MySQL. While generating test data with a script offers more flexibility, when you just want tens of thousands of records for a performance test, plain SQL can be enough. This article shows how to write such SQL.
Approaches to Table Design for Many-to-One Relationships with Multiple Tables
Learn how to handle a table related to multiple tables in many-to-one relationships. Compares polymorphic associations (SQL anti-pattern, no FK constraints) with cross/pivot tables.