Databases & SQL

183 commands · 3 subcategories

Subcategories

Parameterize and secure against injection an aggregation query — e.g. total revenue by region and month.

Databases & SQLadvanced#aggregate#groupby

Write data-dictionary documentation for an e-commerce database schema — e.g. products, orders, customers and inventory tables.

Databases & SQLadvanced#ecommerce#schema

Review and reduce the running cost of a production database cluster — e.g. a Postgres cluster serving a checkout system.

Databases & SQLadvanced#cluster#production

Explain step by step what a stored procedure — e.g. a procedure that recalculates loyalty points nightly.

Databases & SQLmedium#stored-procedure#plsql

Design a partitioning strategy for a graph-like relational structure — e.g. modeling friendships in a social app using a relational database.

Databases & SQLmedium#graph#relations

Set up health monitoring for a failover and disaster recovery plan — e.g. switching to a standby region within five minutes of an.

Databases & SQLmedium#failover#dr