How we define, document, and work with data structures, including database schemas and SQL styles.

---

• Create and manage database tables, schemas, constraints

• Data types, naming conventions, purposes
• Keep a data dictionary or catalog

---

• Uppercase vs lowercase keywords
• Preferred naming conventions (snake_case, etc.)

• Use CTEs, window functions for clarity
• Comment complex queries

• Provide simple queries that follow the style