10 articles tagged #sql
All English for IT articles related to #sql.
-
DuckDB Extensions Vocabulary: English for In-Process Analytics Discussions
Learn the English vocabulary analytics engineers and data scientists use when discussing DuckDB extensions, ATTACH, and in-process analytics workflows.
-
dbt Snapshots and SCD2: English Vocabulary for Data Engineers
Learn English vocabulary for dbt snapshots and slowly changing dimensions to speak confidently in data engineering standups and design reviews.
-
Database Schema Reviews in English: Vocabulary for Data-Intensive Systems
Master the English vocabulary for database schema reviews — migration strategy, backward compatibility, indexing decisions, normalisation, and schema design language.
-
PostgreSQL JSONB & Advanced Query Vocabulary for Backend Developers
Master PostgreSQL JSONB operators, GIN indexes, window functions, CTEs, lateral joins, and query plan vocabulary — with real SQL examples and developer conversation phrases.
-
PostgreSQL Vocabulary: 30 Terms Every Developer Should Know
Learn essential PostgreSQL vocabulary — MVCC, WAL, VACUUM, index types, EXPLAIN ANALYZE, CTEs, window functions, replication, and 20+ more terms explained for developers.
-
SQL Performance Tuning Vocabulary Explained
50 essential SQL performance tuning terms for DBAs and developers: query plans, indexes, statistics, lock types, and optimiser vocabulary — with plain English explanations.
-
Data Modelling Vocabulary: ER Diagrams, Normalisation, and Schema Design
Master data modelling English vocabulary: entities, relationships, normalisation, foreign keys, indexes, and dbt model types including staging, mart, and snapshot layers.
-
Database Vocabulary: SQL, NoSQL, Indexing, and Transactions Explained
Essential database vocabulary for developers: SQL vs NoSQL, ACID properties, indexing, transactions, normalization, sharding, replication, and 25 more terms.
-
Database Vocabulary: 80 Terms Every DBA Must Know
The complete DBA vocabulary guide: ACID, indexes, execution plans, replication, failover, RPO/RTO, sharding, partitioning, and 70 more essential database terms.
-
How to Pronounce SQL, GIF, nginx, and Other Tricky Tech Words
The definitive answer on SQL vs. sequel, GIF with a hard or soft G, nginx pronunciation, and 15 more tech terms everyone debates.