Databases & SQL 9 min read
SQL fundamentals: SELECT, WHERE, ORDER BY (with examples)
A practical SenseCentral guide to SQL fundamentals: SELECT, WHERE, ORDER BY (with examples), including examples, comparison tables, checklists, FAQs, resources,…
EXPLORE THE FIELD
Category: Databases & SQL.
Discover thoughtful articles, guides and ideas about this topic.
← Explore all topics Databases & SQL 9 min read
JOINs explained with real tables (INNER/LEFT/RIGHT)
A practical SenseCentral guide to JOINs explained with real tables (INNER/LEFT/RIGHT), including examples, comparison tables, checklists, FAQs, resources, and useful…
Databases & SQL 9 min read
Indexes: when to add them and how to test impact
A practical SenseCentral guide to Indexes: when to add them and how to test impact, including examples, comparison tables, checklists,…
Databases & SQL 9 min read
Normalize vs denormalize: practical trade-offs
A practical SenseCentral guide to Normalize vs denormalize: practical trade-offs, including examples, comparison tables, checklists, FAQs, resources, and useful creator…
Databases & SQL 10 min read
Create a schema for a blog (posts, tags, users)
A practical SenseCentral guide to Create a schema for a blog (posts, tags, users), including examples, comparison tables, checklists, FAQs,…
Databases & SQL 9 min read
Create a schema for an ecommerce store (products, orders)
A practical SenseCentral guide to Create a schema for an ecommerce store (products, orders), including examples, comparison tables, checklists, FAQs,…
Databases & SQL 9 min read
Transactions: avoid data corruption
A practical SenseCentral guide to Transactions: avoid data corruption, including examples, comparison tables, checklists, FAQs, resources, and useful creator tools.
Databases & SQL 9 min read
Constraints: primary keys, foreign keys, unique constraints
A practical SenseCentral guide to Constraints: primary keys, foreign keys, unique constraints, including examples, comparison tables, checklists, FAQs, resources, and…
Databases & SQL 9 min read
Migration workflows: version your database changes
A practical SenseCentral guide to Migration workflows: version your database changes, including examples, comparison tables, checklists, FAQs, resources, and useful…
Databases & SQL 9 min read
Backups: strategies and restore drills
A practical SenseCentral guide to Backups: strategies and restore drills, including examples, comparison tables, checklists, FAQs, resources, and useful creator…
Databases & SQL 9 min read
Pagination in SQL: OFFSET vs keyset pagination
A practical SenseCentral guide to Pagination in SQL: OFFSET vs keyset pagination, including examples, comparison tables, checklists, FAQs, resources, and…
Databases & SQL 9 min read
Full-text search basics in databases
A practical SenseCentral guide to Full-text search basics in databases, including examples, comparison tables, checklists, FAQs, resources, and useful creator…