https://www.sql-practice.online/interview/level-1-beginner 2024-01-29T14:40:18.138Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/communication-prompt 2024-12-17T01:27:52.500Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/communication-prompt/q-10-communication-prompt-60-second-answer 2026-05-01T13:28:56.764Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/debugging 2026-04-07T05:13:13.543Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/debugging/q-5-query-review-employee-lookup 2024-10-25T13:01:37.962Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/descriptive 2024-07-06T13:23:48.030Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/descriptive/q-2-where-vs-having 2024-12-31T10:35:01.511Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/fill-in-blank 2025-04-15T12:23:06.652Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/fill-in-blank/q-9-fill-in-order-by-limit 2025-01-16T23:48:06.686Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/multiple-choice 2025-08-13T22:49:11.049Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/multiple-choice/q-3-recent-orders-query-mcq 2024-07-09T06:05:27.360Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/optimization 2025-08-19T10:13:37.591Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/optimization/q-8-optimization-lite-pick-better-query 2025-03-29T14:32:00.301Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/output-prediction 2024-06-04T13:09:23.552Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/output-prediction/q-6-output-prediction-order-by-limit 2024-08-27T19:43:32.766Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/query-based 2024-12-20T10:18:46.396Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/query-based/q-1-top-sales-employees 2024-06-08T17:39:14.579Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/scenario-based 2025-08-23T01:00:10.348Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/scenario-based/q-7-scenario-inventory-reorder-list 2024-06-05T15:38:16.591Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/true-false 2024-12-15T00:07:40.182Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/true-false/q-4-count-and-null-behavior 2024-06-20T00:46:23.163Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master 2025-06-03T23:02:39.968Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/communication-prompt 2025-04-22T10:40:06.187Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1005-architecture-communication-round-read-model-strategy 2024-08-22T07:39:52.014Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1013-communication-2-minute-incident-reliability-brief 2025-05-16T19:18:00.300Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1021-communication-compliance-design-defense 2026-03-13T03:20:19.685Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging 2024-09-24T22:46:50.047Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/debugging/q-1004-debug-non-sargable-architecture-audit-query 2024-10-02T10:47:29.861Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1012-debug-idempotency-lookup-query 2025-07-15T13:17:34.081Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1018-debug-row-level-security-filter 2025-11-21T19:42:11.912Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1020-debug-runaway-full-table-scan-in-compliance-job 2025-05-15T22:08:32.728Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1028-debug-partition-pruning-miss 2025-03-22T03:23:54.619Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive 2024-01-19T19:26:05.690Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1002-domain-ownership-boundaries-in-data-systems 2024-05-08T00:34:28.460Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1007-descriptive-audit-ready-temporal-modeling 2025-06-13T18:15:33.973Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1010-rpo-rto-design-trade-off-explanation 2025-05-12T18:34:43.357Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1015-descriptive-split-brain-prevention-in-failover 2024-01-15T16:54:10.596Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1023-descriptive-governance-operating-model 2024-10-21T03:29:00.923Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1026-descriptive-slo-driven-capacity-planning 2024-07-15T21:18:59.229Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1030-descriptive-workload-classes-and-admission-control 2024-05-09T08:40:18.223Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1034-descriptive-architecture-decision-memo-structure 2024-07-18T04:52:36.799Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1037-descriptive-decision-acceptance-criteria 2025-10-26T03:41:25.694Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1039-descriptive-cross-functional-trade-off-negotiation 2024-02-07T19:56:18.174Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/module/m1-end-to-end-data-architecture 2024-09-14T21:55:29.199Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m2-reliability-ha-dr-multi-region 2024-03-10T21:41:11.733Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m3-governance-security-cost-control 2026-04-19T23:17:51.032Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m4-platform-performance-capacity-strategy 2025-01-22T13:14:14.922Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m5-architecture-leadership-decision-rounds 2024-03-11T15:33:01.091Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/optimization 2026-06-16T22:34:02.580Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/optimization/q-1003-optimization-event-time-filter-strategy-for-serving-api 2025-04-28T05:13:53.884Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1011-optimization-better-replication-lag-monitor-query 2025-09-11T00:09:03.318Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1019-optimization-cost-efficient-long-range-report-query 2025-05-29T00:39:56.660Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1027-optimization-better-queue-backlog-query 2026-01-25T01:40:57.482Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1031-optimization-better-refresh-strategy-query 2025-05-21T20:30:27.066Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1035-optimization-safer-backfill-rollout-strategy 2024-12-01T15:28:35.262Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1040-optimization-better-progressive-rollout-query 2025-05-12T19:05:07.267Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/query-based 2026-03-20T07:03:46.958Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/query-based/q-1033-executive-architecture-scoreboard-query 2024-06-08T03:53:38.925Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based 2025-04-02T12:02:34.967Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1001-global-commerce-data-platform-blueprint 2025-11-25T18:35:21.297Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1006-scenario-cdc-vs-batch-for-revenue-publishing 2024-05-02T14:08:03.596Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1008-scenario-contract-evolution-without-consumer-breakage 2025-10-23T20:43:28.860Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1009-scenario-active-active-payment-writes 2024-01-16T11:38:20.207Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1014-scenario-read-after-write-in-multi-region-api 2026-01-21T02:37:08.411Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1016-scenario-dr-drill-design-for-critical-ledger 2026-05-19T17:28:30.505Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1017-scenario-pii-residency-architecture 2025-07-27T18:32:16.075Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1022-scenario-retention-vs-legal-hold-conflict 2026-01-09T01:43:35.045Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1024-scenario-finops-guardrails-for-analytics-explosion 2025-03-31T19:15:25.945Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1025-scenario-noisy-neighbor-isolation-in-shared-cluster 2025-04-14T01:17:55.971Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1029-scenario-black-friday-auto-scaling-strategy 2026-06-08T00:31:13.857Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1032-scenario-hot-partition-mitigation-plan 2025-03-08T16:19:23.841Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1036-scenario-legacy-pipeline-retirement-plan 2024-08-27T20:01:49.370Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1038-scenario-production-outage-command-for-data-plane 2025-07-06T09:15:15.720Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior 2024-05-29T20:43:25.204Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/debugging 2025-04-22T02:04:56.342Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/debugging/q-213-debugging-group-by-mismatch 2026-05-03T19:41:52.596Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/debugging/q-214-debugging-left-join-filter-trap 2024-04-06T02:27:04.910Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/descriptive 2025-11-02T19:37:44.867Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/descriptive/q-207-inner-join-vs-left-join 2026-01-04T00:46:28.575Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice 2026-07-01T05:35:36.054Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-208-mcq-correct-having-usage 2024-01-15T12:41:13.233Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-209-mcq-count-unique-customers 2024-07-27T22:48:22.845Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-210-mcq-keep-all-customers 2024-06-12T00:42:34.247Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/optimization 2025-04-15T09:13:53.768Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/optimization/q-220-optimization-lite-date-filter-and-column-hygiene 2026-05-02T21:02:57.383Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/output-prediction 2024-10-01T22:22:33.253Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/output-prediction/q-215-output-above-average-orders 2024-07-13T23:31:40.176Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/output-prediction/q-216-output-left-join-unmatched-row 2025-09-25T21:50:45.308Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based 2024-03-25T15:59:30.446Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/query-based/q-201-customer-spend-summary 2024-03-22T13:44:50.670Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-202-find-customers-with-no-orders 2026-02-04T18:59:54.407Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-203-department-payroll-snapshot 2024-06-18T01:30:47.307Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-204-monthly-revenue-report-2025 2026-06-05T00:54:54.040Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-205-top-2-products-by-units-sold 2026-06-12T21:11:45.897Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-206-employee-and-manager-names 2024-09-09T17:55:16.061Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based 2024-02-11T17:02:55.188Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-217-scenario-renewal-risk-watchlist 2025-10-17T13:02:02.244Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-218-scenario-top-support-load-customers 2025-09-05T00:21:21.425Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-219-scenario-weekly-team-capacity-view 2025-09-03T23:00:09.639Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/true-false 2025-02-03T13:59:33.966Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/true-false/q-211-true-false-count-and-null 2025-09-15T16:49:27.702Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/true-false/q-212-true-false-aggregate-in-where 2024-12-01T23:32:52.912Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate 2024-03-26T06:22:17.916Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/communication-prompt 2024-08-15T22:28:03.278Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/communication-prompt/q-336-communication-explain-a-query-trade-off 2024-09-17T18:35:48.924Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging 2024-05-22T15:21:41.979Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-316-debugging-left-join-dropping-rows 2024-05-29T17:04:55.351Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-317-debugging-group-by-non-aggregated-column 2025-09-29T21:28:38.169Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-318-debugging-window-alias-in-where 2024-08-31T11:32:39.003Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-319-debugging-duplicate-explosion-in-join 2025-06-15T04:15:42.109Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-320-debugging-non-sargable-date-predicate 2026-05-06T22:08:01.382Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/descriptive 2025-10-21T16:40:28.628Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/descriptive/q-312-in-vs-exists 2024-03-29T03:34:56.366Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/descriptive/q-313-row-number-vs-rank-vs-dense-rank 2026-07-02T16:04:14.263Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/fill-in-blank 2025-03-28T03:19:26.626Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/fill-in-blank/q-335-fill-in-window-ranking-clause 2026-04-17T19:38:55.093Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/multiple-choice 2024-03-15T12:01:17.330Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/multiple-choice/q-314-mcq-top-1-order-per-customer 2024-04-06T15:49:53.848Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization 2024-10-21T07:25:38.484Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-331-optimization-date-predicate-and-projection 2024-12-07T10:11:34.588Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-332-optimization-exists-vs-join-for-presence-check 2024-07-10T18:39:31.808Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-333-optimization-pre-aggregate-before-join 2025-06-14T12:37:04.384Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-334-optimization-or-predicate-rewrite 2024-09-05T22:54:53.405Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction 2024-03-04T16:28:57.192Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-321-output-running-total 2024-05-02T03:31:02.163Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-322-output-rank-with-ties 2025-09-27T04:49:16.363Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-323-output-above-department-average-count 2024-01-06T05:52:38.197Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-324-output-unmatched-customer-count 2024-01-30T18:27:39.721Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based 2024-03-22T21:22:30.775Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-301-top-customers-by-90-day-revenue 2026-03-20T17:33:54.347Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-302-customer-first-order-and-order-count 2025-06-22T18:12:56.059Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-303-products-never-sold 2024-10-16T13:05:54.139Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-304-employees-above-department-average 2024-10-10T21:38:41.425Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-305-latest-order-per-customer 2026-05-02T00:19:13.272Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-306-daily-active-users-with-7-day-rolling-average 2026-03-14T11:12:05.068Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-307-category-conversion-rate 2024-11-11T14:25:04.979Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-308-duplicate-email-detection 2025-03-07T05:15:01.733Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-309-second-highest-salary-per-department 2024-03-02T23:53:30.801Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-310-orders-and-returned-item-count 2026-04-30T13:14:02.928Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-311-monthly-new-customers-and-cumulative-total 2025-04-23T17:46:15.576Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based 2026-06-09T19:27:22.071Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-325-scenario-failed-login-risk-alert 2024-04-10T14:16:04.919Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-326-scenario-low-stock-without-open-purchase-orders 2024-10-12T23:10:34.359Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-327-scenario-churn-risk-candidates 2024-11-08T18:57:40.179Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-328-scenario-first-touch-campaign-attribution 2024-11-01T15:23:55.476Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-329-scenario-sla-breach-dashboard 2025-05-06T06:47:02.763Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-330-scenario-order-payment-reconciliation 2024-08-02T21:00:34.663Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/true-false 2024-02-06T21:00:14.340Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/true-false/q-315-true-false-left-join-filter-semantics 2025-07-03T07:02:43.046Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level 2025-02-28T14:37:59.969Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt 2025-07-13T11:04:59.375Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt/q-449-communication-explain-top-n-per-group-strategy 2025-04-25T15:56:05.298Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt/q-450-communication-defend-cte-vs-temp-table-choice 2024-09-01T07:07:24.063Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging 2026-05-12T15:42:18.557Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-423-debug-window-alias-used-in-where 2025-03-04T16:01:56.674Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-424-debug-cte-missing-as-keyword 2025-02-09T08:30:34.944Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-425-debug-wrong-partition-in-running-total 2024-02-05T14:31:26.450Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-426-debug-duplicate-rows-after-cte-join 2025-03-03T17:34:52.560Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-427-debug-incorrect-lag-ordering 2024-01-29T16:11:15.932Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-428-debug-recursive-cte-without-stop-guard 2024-12-24T23:07:16.567Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-429-debug-non-sargable-filter-in-cte 2026-01-04T01:17:44.394Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive 2024-05-30T16:01:19.417Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-440-cte-vs-subquery-vs-temp-table 2025-05-12T13:38:30.671Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-441-window-frame-types 2025-09-01T20:37:20.483Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-442-recursive-cte-design-principles 2025-01-08T12:37:16.372Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank 2025-09-25T11:06:41.981Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank/q-447-fillblank-running-total-frame 2026-02-19T05:29:38.935Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank/q-448-fillblank-recursive-cte-keywords 2026-06-19T16:53:16.573Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice 2026-03-24T01:45:59.593Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice/q-443-mcq-correct-window-filtering 2025-10-23T23:43:04.048Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice/q-444-mcq-recursive-cte-components 2025-10-10T23:06:40.287Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization 2024-03-08T02:56:49.639Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-435-optimization-window-pre-filter 2024-02-10T14:52:35.796Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-436-optimization-top-n-per-group-strategy 2024-10-31T07:43:35.456Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-437-optimization-cte-materialization-risk 2024-09-20T09:25:30.638Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-438-optimization-recursive-cte-boundaries 2026-01-16T03:23:00.795Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-439-optimization-filter-placement-with-left-join 2026-04-07T06:49:06.201Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction 2024-05-16T21:45:03.888Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-430-output-running-revenue-at-day-3 2025-03-22T12:16:37.344Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-431-output-dense-rank-with-salary-ties 2024-11-16T20:23:01.732Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-432-output-previous-week-revenue 2025-09-29T12:47:57.456Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-433-output-top-2-per-category-count 2026-02-25T13:49:26.016Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-434-output-first-event-per-user 2025-05-23T21:08:09.681Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based 2025-06-12T12:44:07.272Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-401-top-3-products-per-month-window-rank 2025-04-07T01:28:12.497Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-402-users-active-in-consecutive-months 2025-03-01T15:25:55.435Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-403-latest-ticket-status-per-ticket 2025-10-21T23:53:48.506Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-404-running-account-balance 2026-02-14T12:16:22.574Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-405-days-to-first-purchase 2024-04-28T12:14:39.503Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-406-month-1-cohort-retention 2025-03-08T11:46:44.106Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-407-ntile-salary-banding-by-department 2025-01-08T01:38:29.117Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-408-customers-with-30-day-purchase-gap 2026-01-14T03:22:40.327Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-409-weekly-revenue-with-wow-delta 2024-03-04T19:04:16.102Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-410-cumulative-unique-customers-by-month 2025-06-25T23:24:37.577Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-411-department-median-salary-window-approach 2026-02-22T18:10:43.293Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-412-3-day-moving-average-orders 2025-02-02T14:27:14.701Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-413-daily-funnel-conversion-session-to-purchase 2025-08-25T13:22:33.836Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-414-top-2-categories-by-region 2026-01-27T17:10:26.688Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based 2024-11-12T11:26:15.566Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-415-fraud-spike-detection-hourly 2024-03-05T02:39:14.775Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-416-sla-breach-with-reopen-awareness 2024-12-30T04:21:47.607Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-417-inventory-forecast-risk 2025-08-30T11:29:45.968Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-418-subscription-downgrade-risk 2025-09-26T09:38:43.331Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-419-marketplace-seller-reliability 2024-03-04T14:38:41.515Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-420-first-response-time-by-agent 2024-01-07T06:47:59.283Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-421-experiment-lift-by-cohort-week 2026-04-27T01:19:46.056Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-422-finance-accrual-vs-cash-variance 2024-07-09T21:33:42.911Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/true-false 2025-08-11T21:43:51.072Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/true-false/q-445-true-false-window-functions-in-where 2026-01-29T23:25:11.910Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/true-false/q-446-true-false-range-and-duplicate-values 2024-02-01T05:28:42.732Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior 2024-02-29T12:47:17.203Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/communication-prompt 2025-03-23T23:41:11.918Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/communication-prompt/q-565-communication-defend-index-strategy 2024-04-12T10:02:25.662Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/communication-prompt/q-566-communication-explain-safe-migration-plan 2024-12-10T10:09:37.489Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging 2024-04-11T02:57:06.480Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/debugging/q-539-debug-invalid-check-constraint-logic 2025-07-23T01:30:57.211Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-540-debug-broken-composite-index-order 2026-05-06T18:10:25.085Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-541-debug-fk-added-without-supporting-index 2024-07-19T17:48:10.228Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-542-debug-partition-key-function-prevents-pruning 2024-04-06T18:49:57.608Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-543-debug-duplicate-rows-after-join 2024-09-17T06:11:22.070Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-544-debug-unsafe-drop-column-migration 2025-03-31T04:20:02.513Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-545-debug-misused-unique-constraint-for-soft-delete 2025-12-25T01:21:53.047Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-546-debug-slow-top-n-query 2025-09-19T07:40:52.734Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive 2025-08-09T02:33:09.802Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-547-explain-expand-contract-migration-strategy 2025-12-15T03:45:28.762Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-548-composite-index-design-heuristics 2026-05-06T20:59:57.080Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-549-partitioning-trade-offs 2025-01-02T10:27:33.339Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-550-materialized-view-refresh-strategy 2024-06-16T04:56:15.989Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-551-ddl-governance-in-ci-cd 2025-06-19T16:42:31.219Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank 2025-02-09T10:45:04.364Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-562-fillblank-composite-index-ddl 2024-07-31T21:18:17.105Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-563-fillblank-add-foreign-key 2025-06-25T05:15:17.296Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-564-fillblank-partitioned-table-syntax 2025-06-12T09:21:10.974Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice 2024-12-29T09:11:30.866Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-552-mcq-best-index-for-query-pattern 2026-04-06T00:24:50.345Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-553-mcq-safe-not-null-migration 2024-02-29T00:54:56.527Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-554-mcq-partition-key-choice 2024-04-16T22:07:51.801Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-555-mcq-fk-performance-requirement 2026-05-20T13:10:48.666Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization 2025-11-05T20:26:59.521Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/optimization/q-527-optimization-sargable-date-filter 2024-04-04T21:04:31.730Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-528-optimization-exists-vs-in-large-subquery 2025-10-18T00:30:06.648Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-529-optimization-left-join-filter-placement 2025-06-15T19:04:33.350Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-530-optimization-pre-aggregate-before-join 2025-02-14T00:02:25.789Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-531-optimization-distinct-vs-window-dedupe 2024-06-11T04:39:09.510Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-532-optimization-avoid-select-star-on-hot-path 2025-04-06T14:48:28.239Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-533-optimization-or-predicate-rewrite 2024-01-02T01:03:55.624Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-534-optimization-count-strategy 2026-01-31T03:22:46.973Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-535-optimization-anti-join-pattern 2024-10-10T05:27:15.267Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-536-optimization-batch-delete-strategy 2025-07-18T03:07:13.116Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-537-optimization-join-key-data-type-mismatch 2025-07-12T16:32:07.448Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-538-optimization-filter-before-window 2026-01-28T08:58:44.830Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction 2025-02-02T15:01:06.843Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-559-output-composite-index-usability 2026-04-10T20:23:00.878Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-560-output-dedupe-keep-latest 2025-11-21T18:25:10.569Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-561-output-partial-unique-constraint 2024-10-08T16:14:08.421Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based 2025-12-24T19:43:05.519Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/query-based/q-501-design-orders-table-for-production 2024-06-04T23:45:08.716Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-502-safe-add-not-null-column-with-backfill 2025-02-08T17:01:59.256Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-503-create-idempotent-index-migration 2024-01-17T18:57:30.148Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-504-partition-event-table-by-month 2024-09-16T10:39:47.919Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-505-add-unique-constraint-after-data-cleanup 2024-08-31T15:37:27.935Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-506-build-rollup-table-for-dashboard 2024-12-27T20:58:56.311Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-507-create-covering-index-for-ticket-search 2025-08-21T04:58:03.034Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-508-online-rename-strategy-via-view-shield 2024-10-31T22:42:19.511Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-509-create-foreign-key-with-action-rules 2025-12-06T19:54:56.704Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-510-materialized-view-for-monthly-kpis 2024-05-22T02:16:35.420Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-511-build-partial-index-for-hot-subset 2024-10-24T17:35:36.545Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-512-implement-soft-delete-with-constraint-safety 2024-08-28T14:14:51.875Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-513-backfill-surrogate-key-safely 2024-06-16T03:02:00.424Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-514-create-historical-archive-table 2026-02-07T11:55:34.145Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based 2025-08-24T01:50:16.781Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-515-scenario-zero-downtime-add-enum-like-status 2024-09-19T04:21:41.634Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-516-scenario-fast-tenant-purge 2024-06-30T12:18:38.880Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-517-scenario-add-fk-to-dirty-legacy-data 2024-12-02T08:08:31.476Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-518-scenario-migration-from-int-to-bigint-pk 2025-05-26T02:52:22.398Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-519-scenario-hotfix-for-blocking-ddl 2024-10-02T04:27:38.897Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-520-scenario-enforce-exactly-one-primary-address 2025-05-23T16:27:18.800Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-521-scenario-daily-incremental-aggregate-refresh 2025-04-24T18:55:53.582Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-522-scenario-guard-against-negative-inventory 2026-03-17T05:28:31.897Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-523-scenario-partition-pruning-failure 2024-01-26T02:41:01.625Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-524-scenario-introduce-multi-column-business-key 2026-04-23T14:18:53.567Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-525-scenario-recover-from-dropped-index 2024-01-13T07:58:38.833Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-526-scenario-split-monolithic-table 2026-03-25T11:56:47.723Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false 2024-08-09T16:58:07.999Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/true-false/q-556-true-false-not-in-with-nulls 2026-01-25T01:53:36.479Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false/q-557-true-false-concurrent-index-build 2026-01-10T22:28:51.307Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false/q-558-true-false-function-on-indexed-column 2025-04-24T06:28:33.265Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert 2025-04-08T06:18:27.870Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/communication-prompt 2024-11-26T14:27:24.721Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-609-explain-why-you-chose-a-history-table 2026-02-11T05:24:18.596Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-610-defend-composite-uniqueness-strategy 2024-02-26T15:27:24.927Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-640-explain-why-atomic-update-beats-read-then-write 2025-12-15T14:48:53.446Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-641-defend-transactional-outbox 2024-12-07T15:37:44.927Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-657-explain-multi-tenant-choice-to-interviewer 2025-06-29T01:57:27.765Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-658-defend-event-sourcing-vs-snapshot-only 2024-09-02T21:38:04.162Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-672-explain-your-rollback-plan 2025-11-19T20:21:23.095Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-673-defend-why-you-delay-column-drop 2025-09-02T21:18:42.136Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging 2026-03-24T15:45:08.938Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/debugging/q-611-fix-non-deterministic-current-plan-query 2026-02-09T10:58:21.658Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-612-repair-overlapping-temporal-ranges 2024-04-23T17:28:25.372Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-625-debugging-non-sargable-date-predicate 2025-03-25T15:05:09.945Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-626-debugging-wrong-index-column-order 2024-07-01T14:42:56.545Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-642-debugging-lost-update-pattern 2024-02-24T11:48:33.552Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-643-debugging-duplicate-idempotency-key-inserts 2026-05-18T16:31:38.761Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-644-debugging-orphan-child-rows 2026-03-06T06:00:26.625Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-661-debugging-double-counting-revenue 2025-07-14T04:26:39.610Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-678-debugging-breaking-migration-order 2025-05-12T19:40:43.011Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-679-debugging-unsafe-destructive-change 2025-01-29T21:08:13.099Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive 2025-02-26T23:30:54.546Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-601-oltp-normalization-vs-read-model-denormalization 2026-05-21T16:35:13.753Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-602-surrogate-key-vs-natural-key-at-scale 2025-11-07T18:47:52.285Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-603-temporal-modeling-for-customer-plans 2025-04-07T10:35:49.640Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-604-soft-delete-vs-archive-table 2025-02-05T18:36:57.740Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-632-composite-index-prefix-strategy 2025-09-14T15:58:32.355Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-633-isolation-level-trade-off-for-checkout 2026-05-10T12:09:11.593Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-634-idempotency-in-payment-write-path 2024-10-17T11:51:41.766Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-635-deferrable-constraint-use-case 2025-06-16T03:57:36.940Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-649-e-commerce-order-domain-boundaries 2024-04-06T04:28:14.953Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-650-fintech-ledger-vs-balance-table 2024-05-29T08:11:35.068Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-651-multi-tenant-isolation-models 2025-06-09T17:42:31.184Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-665-expand-contract-migration-strategy 2024-03-12T11:25:02.698Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-666-backfill-risk-controls 2025-05-19T19:13:08.670Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-667-backward-compatibility-in-api-db-evolution 2025-10-21T09:17:09.722Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/fill-in-blank 2024-04-30T08:59:48.048Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/fill-in-blank/q-680-fillblank-add-safe-constraint 2025-12-10T13:30:05.552Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/module/m1-data-modeling 2024-07-18T12:51:19.557Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m2-performance-schema 2024-04-19T11:56:54.100Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m3-consistency-integrity 2025-12-10T20:59:38.804Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m4-domain-design-cases 2025-03-09T12:00:17.818Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m5-schema-evolution 2024-02-29T17:01:03.281Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/multiple-choice 2024-11-16T06:14:10.747Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-614-mcq-best-key-strategy-for-user-profile 2026-03-10T21:02:05.020Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-629-mcq-best-index-for-query-pattern 2026-02-14T14:36:15.198Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-646-mcq-best-pattern-for-exactly-once-business-effect 2025-05-20T05:58:39.023Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-664-mcq-best-multi-tenant-uniqueness-constraint 2024-04-02T18:13:42.656Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization 2024-06-04T09:54:40.631Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/optimization/q-617-optimization-partition-pruning-candidate 2026-02-03T01:59:04.860Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-618-optimization-covering-index-friendly-query 2025-05-29T00:30:09.984Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-619-optimization-sargable-status-filter 2024-01-13T18:48:06.946Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-620-optimization-top-n-per-group-pattern 2025-04-25T02:44:00.200Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-621-optimization-exists-vs-distinct-join 2025-10-27T17:51:06.642Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-648-optimization-conflict-handling-path 2024-06-14T10:39:35.091Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-659-optimization-cohort-query-pattern 2025-01-05T13:00:55.014Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-660-optimization-anti-join-for-churn-candidates 2026-04-21T13:17:53.933Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-674-optimization-safer-migration-write-path 2026-03-07T04:16:33.342Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-675-optimization-batch-backfill-pattern 2025-02-05T01:33:06.145Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-676-optimization-contract-phase-safety 2026-07-04T10:06:07.816Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-677-optimization-index-migration-sequence 2026-06-06T00:05:23.164Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction 2026-06-02T02:02:27.281Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-613-output-identify-duplicate-natural-key 2026-05-04T08:20:45.014Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-627-output-partition-range-match-count 2025-11-10T04:09:07.348Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-628-output-covering-style-projection 2024-06-20T03:36:33.204Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-645-output-idempotency-unique-constraint-effect 2025-06-07T22:46:43.105Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-662-output-first-touch-attribution-result 2026-04-08T15:41:25.585Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-663-output-breach-count-calculation 2025-11-14T14:48:26.701Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/query-based 2024-08-06T04:18:35.178Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/query-based/q-616-ddl-append-only-ledger-entry-table 2025-10-23T13:04:41.375Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/query-based/q-631-query-top-tenants-by-7-day-write-volume 2026-04-24T01:23:12.783Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based 2025-07-12T09:34:38.579Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-605-schema-for-product-variant-catalog 2025-03-20T06:21:31.720Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-606-audit-ready-payment-state-model 2025-11-12T18:16:11.642Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-607-reference-data-governance-model 2025-03-13T09:26:15.061Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-608-identity-and-alias-resolution 2024-10-20T23:42:24.347Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-622-scenario-time-series-event-storage 2025-12-20T15:17:21.129Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-623-scenario-hot-cold-order-table-split 2024-04-06T17:31:47.239Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-624-scenario-multi-column-index-choice 2025-03-23T16:59:55.373Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-636-scenario-idempotent-job-execution-table 2025-01-12T03:56:49.431Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-637-scenario-enforce-non-negative-inventory-updates 2024-10-20T14:32:26.940Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-638-scenario-parent-child-integrity-with-soft-delete 2026-06-06T06:45:47.448Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-639-scenario-transactional-outbox-schema 2025-01-31T01:54:48.383Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-652-scenario-saas-tenant-usage-metering 2026-06-04T09:41:31.098Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-653-scenario-fraud-rule-evaluation-trace 2025-03-22T06:19:11.008Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-654-scenario-marketplace-settlement-model 2024-04-16T14:51:47.737Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-655-scenario-analytics-attribution-first-touch 2024-01-09T16:14:53.330Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-656-scenario-sla-breach-dashboard-by-team 2025-03-20T21:26:55.123Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-668-scenario-add-non-null-column-safely 2024-06-30T20:35:56.326Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-669-scenario-introduce-new-status-enum-values 2024-06-11T07:40:34.151Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-670-scenario-rebuild-index-online 2026-03-30T17:06:25.922Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-671-scenario-split-monolithic-address-column 2025-08-16T07:24:35.500Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false 2025-01-12T12:36:36.573Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/true-false/q-615-true-false-3nf-is-always-slower 2025-05-22T16:43:11.571Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false/q-630-true-false-select-is-neutral 2025-03-07T05:21:16.811Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false/q-647-true-false-retry-without-idempotency-is-safe 2024-09-16T11:01:16.022Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect 2025-11-04T20:31:53.013Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/communication-prompt 2025-10-28T21:30:38.747Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-761-explain-model-choice-to-vp-of-analytics 2024-05-06T05:33:57.220Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-766-explain-freshness-vs-cost-trade-off 2025-08-17T09:22:54.808Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-776-explain-incident-plan-to-sre-during-latency-spike 2024-03-10T22:20:03.501Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-785-explain-rollback-decision-under-incident-pressure 2025-03-28T09:15:02.610Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging 2025-02-06T04:06:41.168Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/debugging/q-703-debug-non-sargable-email-lookup 2024-04-16T12:04:50.353Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-710-debug-leading-wildcard-search 2025-06-30T09:48:28.149Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-717-debug-or-predicate-that-defeats-index-path 2025-05-24T08:08:28.282Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-727-debug-distinct-masking-join-explosion 2025-04-23T07:13:47.776Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-731-debug-correlated-subquery-re-execution-cost 2024-02-23T18:22:48.370Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-736-debug-unnecessary-order-by-in-subquery 2025-06-10T23:34:18.319Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-747-debug-cast-preventing-partition-pruning 2026-01-29T05:00:26.909Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-755-debug-non-prunable-between-on-timestamp-boundaries 2026-05-21T22:08:03.028Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-771-debug-plan-regression-from-stale-statistics 2025-05-13T17:43:09.357Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-775-debug-implicit-type-conversion-causing-scan 2024-10-18T07:54:14.421Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-778-debug-hash-join-spill-to-disk 2025-08-05T16:19:56.819Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-781-debug-lock-contention-from-long-transaction 2024-10-25T10:11:31.485Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-784-debug-nested-loop-explosion-on-large-join 2024-10-17T07:34:08.941Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-787-debug-high-rows-removed-by-filter 2025-09-24T07:49:01.425Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive 2024-10-08T20:43:47.023Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-718-b-tree-vs-hash-vs-full-text-index-decision 2025-07-30T10:45:48.069Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-738-cte-vs-temp-table-decision-in-performance-tuning 2024-03-06T03:42:05.450Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-745-range-vs-hash-partitioning-trade-off 2024-07-17T02:43:40.888Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-752-when-to-subpartition-by-tenant 2025-11-21T12:40:25.901Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-758-fact-grain-decision-and-performance-impact 2026-01-28T22:33:05.732Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-763-conformed-dimensions-in-multi-domain-analytics 2025-11-27T12:01:47.333Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-769-snapshot-fact-vs-transaction-fact 2024-04-17T22:07:01.064Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/fill-in-blank 2024-03-28T23:37:30.329Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/fill-in-blank/q-734-fillblank-keyset-pagination-predicate 2025-05-07T19:20:26.105Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/module/m1-indexing-strategy 2024-09-14T07:48:44.165Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m2-query-shape-optimization 2025-03-06T07:21:03.559Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m3-partitioning-lifecycle 2026-01-02T22:16:28.366Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m4-dimensional-performance-models 2025-11-09T07:14:39.996Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m5-plan-forensics-production-tuning 2024-08-13T09:02:02.899Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/multiple-choice 2025-11-06T15:31:32.620Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/multiple-choice/q-721-mcq-best-composite-index-for-recent-paid-orders 2024-08-10T06:47:05.591Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/multiple-choice/q-790-mcq-first-response-to-sudden-query-regression 2025-09-02T08:07:33.624Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization 2025-11-04T17:46:28.286Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/optimization/q-705-optimization-showdown-active-users-lookup 2026-03-28T02:12:59.803Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-709-optimization-showdown-keyset-vs-offset-pagination 2024-04-16T19:47:36.450Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-714-optimization-showdown-covering-projection 2024-06-18T08:30:24.512Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-720-optimization-showdown-function-index-trade-off 2024-07-21T12:51:09.596Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-726-optimization-showdown-anti-join-pattern 2025-08-05T05:32:17.156Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-730-optimization-showdown-union-vs-union-all 2024-06-18T17:51:36.820Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-739-optimization-showdown-in-vs-exists-for-large-subquery 2026-04-03T19:22:26.382Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-743-optimization-showdown-partition-prunable-predicate 2025-08-27T11:30:49.171Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-748-optimization-showdown-local-vs-global-index-filter 2026-06-22T20:01:20.769Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-753-optimization-showdown-retention-job-shape 2025-12-19T20:40:40.708Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-764-optimization-showdown-raw-fact-vs-aggregate-table 2026-07-02T07:03:21.483Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-772-optimization-showdown-parameter-sniffing-mitigation 2025-03-15T23:27:28.981Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-777-optimization-showdown-chunked-backfill-vs-single-massive-update 2026-02-07T16:53:04.164Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-782-optimization-showdown-leading-table-in-join-order 2025-04-07T22:31:57.874Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-786-optimization-showdown-seek-friendly-date-window 2024-04-25T04:40:15.752Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-789-optimization-showdown-covering-index-for-sort-filter 2024-12-15T11:57:50.530Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction 2025-10-15T13:40:36.834Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-713-output-which-candidate-is-more-index-friendly 2025-06-17T21:57:40.225Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-729-output-exists-vs-join-distinct-row-semantics 2025-09-25T00:54:50.251Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-737-output-count-after-inner-join-with-missing-matches 2026-02-12T17:57:57.942Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-756-output-partition-scan-count 2024-05-01T02:09:49.282Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-768-output-star-join-row-multiplication 2024-07-05T05:16:00.201Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based 2024-08-01T16:52:11.101Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/query-based/q-701-top-slow-endpoints-by-p95-in-last-7-days 2026-01-02T12:40:49.186Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-702-partition-pruned-monthly-revenue-query 2026-06-17T15:52:23.144Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-706-covering-index-candidate-for-recent-paid-orders 2025-02-19T06:52:57.317Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-707-partial-index-friendly-subscription-scan 2026-06-06T16:23:36.095Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-708-composite-index-aligned-queue-fetch 2025-08-29T11:07:51.141Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-712-index-safe-last-login-dashboard-query 2025-08-14T13:39:58.079Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-716-top-n-by-composite-sort-for-fraud-queue 2025-06-02T19:02:04.611Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-719-index-only-candidate-for-comment-feed 2024-05-13T08:09:22.800Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-723-exists-for-active-customers-in-last-30-days 2024-08-17T09:37:34.657Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-724-top-3-orders-per-customer-window-shape 2025-06-08T14:51:12.137Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-725-predicate-pushdown-before-heavy-join 2025-08-15T07:36:12.730Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-728-pre-aggregate-before-joining-large-dimensions 2025-10-20T12:46:48.237Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-732-semi-join-for-recently-active-products 2026-05-29T06:38:53.754Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-735-shape-query-for-top-categories-by-revenue 2024-09-09T23:44:38.594Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-740-rewrite-optional-filter-query-without-coalesce-trap 2024-09-25T14:51:27.066Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-744-partition-friendly-weekly-revenue-query 2024-08-22T20:46:50.756Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-749-monthly-partition-revenue-by-tenant 2024-11-18T20:49:12.808Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-751-partition-metadata-driven-retention-sql 2026-04-28T04:39:45.871Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-760-star-query-monthly-revenue-by-region 2025-05-15T13:47:04.340Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-765-top-products-by-revenue-in-star-model 2025-04-07T22:25:38.005Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-774-find-top-cpu-queries-in-last-hour 2026-06-28T16:41:16.917Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-780-query-plans-with-high-temp-spill 2025-01-24T22:40:17.957Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-788-find-worst-fingerprints-by-p99-latency-regression 2024-03-17T18:01:43.560Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based 2026-02-28T10:32:08.654Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-704-scenario-multi-tenant-events-index-strategy 2026-05-05T22:52:25.843Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-711-scenario-index-budget-on-write-heavy-ledger 2024-12-11T01:24:47.989Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-715-scenario-geo-search-and-secondary-index-choice 2025-05-12T02:26:16.067Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-733-scenario-query-shape-for-multi-widget-dashboard 2025-09-28T15:12:22.132Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-741-scenario-partition-key-choice-for-orders-at-10b-rows 2025-12-05T15:08:21.718Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-742-scenario-retention-deletes-vs-partition-drops 2026-05-27T19:54:05.037Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-746-scenario-hot-cold-storage-split-strategy 2025-12-06T04:42:44.739Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-750-scenario-multi-tenant-partitioning-by-time-tenant 2025-05-14T14:03:40.222Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-754-scenario-backfill-new-partition-key-without-downtime 2024-07-04T20:58:56.950Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-757-scenario-star-vs-snowflake-for-self-serve-bi 2025-05-28T22:31:00.762Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-759-scenario-scd2-dimension-join-performance 2025-02-08T12:26:35.855Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-762-scenario-late-arriving-facts-handling 2025-06-15T14:40:28.713Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-767-scenario-bridge-table-for-many-to-many-attribution 2026-02-08T00:30:11.287Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-770-scenario-semantic-layer-and-sql-performance 2026-01-02T07:40:00.746Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-773-scenario-production-tuning-rollout-guardrails 2026-02-02T09:51:32.990Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-779-scenario-read-replica-offload-without-stale-kpi-risk 2025-07-15T01:51:17.817Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-783-scenario-plan-instability-across-deployments 2024-12-06T22:46:50.694Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/true-false 2026-04-08T23:44:22.556Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/true-false/q-722-true-false-more-indexes-always-means-better-performance 2026-05-16T04:00:48.249Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal 2025-12-08T15:25:03.753Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/communication-prompt 2026-03-28T07:04:17.974Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-820-60-second-defense-shard-key-decision 2025-01-16T13:58:13.041Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-842-60-second-consistency-choice 2025-07-06T02:23:51.581Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-860-60-second-failover-trade-off-explanation 2025-10-12T08:39:05.484Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-880-60-second-cdc-correctness-narrative 2024-12-05T12:03:05.108Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-895-60-second-multi-region-architecture-pitch 2024-12-25T19:34:47.074Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-896-60-second-incident-governance-update 2025-06-17T21:34:45.820Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-897-60-second-cost-reduction-story 2026-02-07T17:09:34.615Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-898-60-second-residency-audit-readiness 2025-10-07T05:21:03.425Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-899-60-second-quorum-cost-justification 2026-02-24T21:27:10.655Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-900-60-second-global-schema-rollout 2025-05-19T07:10:00.062Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging 2024-02-20T14:39:20.551Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/debugging/q-804-debug-cast-on-shard-key 2025-05-08T21:22:13.689Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-805-debug-missing-tenant-predicate 2024-03-21T23:39:19.330Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-828-debug-missing-group-by-in-settlement 2025-11-03T21:32:22.673Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-829-debug-retry-dedupe-predicate 2025-05-14T10:39:14.983Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-830-debug-negative-inventory-risk 2025-03-14T08:37:36.301Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-831-debug-replay-ordering 2026-02-28T20:40:26.649Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-850-debug-region-filter-precedence 2026-02-24T19:11:38.770Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-851-debug-failover-candidate-ordering 2025-06-13T02:39:39.395Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-852-debug-missing-health-constraint 2024-02-23T00:26:17.451Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-868-debug-invalid-latest-row-aggregation 2024-05-13T17:47:15.554Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-869-debug-late-event-window-filter 2024-10-10T11:34:40.509Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-885-debug-region-filter-in-cost-query 2025-10-22T09:37:45.192Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive 2025-07-02T17:15:15.265Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-815-consistent-hashing-vs-range-sharding 2026-06-05T08:37:04.872Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-816-ownership-boundaries-to-avoid-global-transactions 2026-01-05T12:23:42.877Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-817-replicate-small-dimensions-vs-cross-shard-join 2025-03-30T15:47:37.050Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-822-saga-vs-2pc-trade-off 2026-05-11T21:28:47.497Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-823-idempotency-key-enforcement 2024-03-09T04:53:43.817Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-824-isolation-choice-for-inventory-reservation 2026-04-24T17:02:23.171Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-825-why-transactional-outbox-works 2026-03-04T08:05:57.658Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-844-rpo-and-rto-in-design-decisions 2024-10-13T17:07:52.940Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-845-async-vs-sync-replication-decision 2025-10-27T02:14:10.431Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-846-split-brain-prevention-controls 2024-02-04T01:24:56.684Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-847-read-after-write-in-replica-topologies 2025-06-24T18:53:35.210Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-863-exactly-once-vs-at-least-once-semantics 2024-01-09T23:36:48.257Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-864-global-vs-per-key-ordering 2026-03-14T04:46:04.706Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-865-backpressure-control-plan 2024-10-12T10:00:13.278Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-866-safe-replay-strategy 2025-05-16T02:23:54.316Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-882-latency-vs-cost-in-multi-region-writes 2024-07-17T06:28:13.761Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-883-data-residency-enforcement-controls 2025-07-12T17:16:50.448Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-884-capacity-planning-leading-indicators 2025-12-13T23:29:11.894Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank 2024-04-24T02:08:14.875Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank/q-841-fillblank-conflict-no-op-clause 2024-06-24T04:41:18.702Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank/q-879-fillblank-window-ordering-token 2025-03-12T07:54:08.494Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/module/m1-distributed-data-architecture 2025-07-25T06:30:29.116Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m2-consistency-transactions-scale 2024-05-11T00:29:35.970Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m3-replication-ha-dr 2024-11-06T22:36:23.433Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m4-streaming-cdc-events 2026-06-02T23:40:37.541Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m5-multi-region-cost-governance 2025-09-24T11:17:15.259Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/multiple-choice 2024-06-05T21:59:36.474Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-819-mcq-best-shard-key-characteristic 2024-11-18T07:47:11.217Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-826-mcq-duplicate-charge-prevention 2026-04-03T00:21:47.555Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-848-mcq-safest-promotion-signal 2025-05-29T06:21:18.664Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-867-mcq-best-cdc-dedup-key 2025-04-06T23:53:42.056Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization 2025-10-06T13:24:49.707Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/optimization/q-811-optimization-date-vs-range-on-partition-key 2024-11-24T01:33:48.705Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-812-optimization-routed-join 2026-01-10T15:42:30.328Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-813-optimization-composite-index-column-order 2025-05-05T20:23:58.173Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-814-optimization-uuid-vs-ordered-ids 2024-01-15T05:40:22.108Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-839-optimization-idempotent-insert-pattern 2025-12-04T01:21:27.030Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-840-optimization-atomic-stock-decrement 2025-08-17T16:32:50.823Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-858-optimization-freshness-predicate-form 2025-02-01T07:23:57.603Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-859-optimization-region-health-dashboard-query 2024-06-02T03:11:24.308Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-877-optimization-distinct-vs-window-dedup 2024-07-08T19:45:20.060Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-878-optimization-full-recompute-vs-incremental 2025-05-21T23:08:33.259Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-891-optimization-read-routing-policy 2024-02-08T20:31:51.209Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-892-optimization-storage-tiering-strategy 2026-06-14T10:38:17.943Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-893-optimization-multi-region-index-policy 2026-06-15T16:11:12.892Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-894-optimization-governance-enforcement-mechanism 2024-07-25T01:59:26.208Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction 2024-10-30T09:00:17.032Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-818-output-routed-or-broadcast 2026-03-10T06:34:06.101Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-832-output-locking-pattern-for-lost-update 2025-10-21T19:57:39.252Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-853-output-promote-or-wait-decision 2024-09-16T20:39:38.617Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-870-output-deduped-version-count 2024-06-18T23:54:38.123Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-871-output-watermark-admission 2025-01-02T05:32:59.316Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-886-output-budget-alert-trigger 2025-01-06T06:26:33.394Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based 2025-04-05T22:07:49.700Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/query-based/q-801-tenant-checkout-feed-in-last-7-days 2024-05-24T17:08:27.362Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-802-single-shard-active-session-pull 2024-09-16T20:20:13.267Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-803-region-partition-product-reads 2024-01-28T15:37:37.676Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-821-outbox-polling-window 2025-02-04T10:09:53.888Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-843-replica-lag-breach-query 2026-04-12T20:34:39.599Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-861-latest-version-per-customer-from-cdc 2025-02-21T11:54:27.789Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-862-ingestion-lag-by-pipeline 2025-11-29T13:04:42.219Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-881-cross-region-storage-cost-top-services 2024-05-04T19:14:51.142Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based 2026-03-01T18:57:33.035Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-806-shard-key-choice-for-marketplace-orders 2025-03-26T19:25:57.102Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-807-zero-downtime-re-sharding-plan 2024-03-15T13:18:20.127Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-808-noisy-neighbor-isolation-without-replatform 2024-09-29T10:46:14.516Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-809-global-id-strategy-across-regions 2025-02-17T03:14:24.811Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-810-reference-data-placement-strategy 2025-07-21T17:57:59.419Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-833-payment-success-but-inventory-fail 2024-03-25T04:32:32.484Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-834-duplicate-event-consumption 2024-05-15T13:34:48.729Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-835-hot-counter-correctness 2024-08-30T00:54:12.505Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-836-reservation-timeout-release-flow 2024-05-22T08:33:36.318Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-837-per-aggregate-ordering-under-partitioned-streams 2024-11-23T02:29:49.460Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-838-fast-ux-with-reliable-side-effects 2024-02-21T07:13:40.032Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-854-regional-outage-failover-sequence 2024-08-14T20:19:57.290Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-855-read-routing-during-lag-spikes 2025-02-19T04:02:23.425Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-856-disaster-recovery-drill-design 2024-11-27T12:49:58.427Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-857-cross-region-quorum-strategy 2024-07-10T14:24:24.218Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-872-reliable-db-kafka-write-pattern 2025-09-27T10:07:43.794Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-873-late-event-revenue-corrections 2024-12-01T19:58:27.840Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-874-exactly-once-sink-to-warehouse 2025-05-08T18:01:01.907Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-875-poison-message-policy 2025-09-25T12:42:43.238Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-876-event-contract-evolution-rollout 2025-02-26T03:03:22.547Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-887-topology-decision-for-global-checkout 2024-03-01T17:47:29.316Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-888-cross-region-egress-spike-response 2024-07-03T15:58:51.801Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-889-compliance-aware-dr-failover 2024-06-12T01:01:33.518Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-890-cost-performance-governance-model 2025-02-07T11:44:27.297Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/true-false 2024-12-04T09:22:10.296Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/true-false/q-827-true-false-eventual-consistency-implies-data-loss 2026-06-12T00:53:50.386Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/true-false/q-849-true-false-async-replication-zero-loss 2024-10-05T00:45:37.226Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished 2025-05-05T11:50:08.825Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/debugging 2025-01-28T17:26:39.556Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-903-debug-function-wrapped-predicate 2025-02-16T08:33:49.748Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-914-debug-heap-fetch-heavy-read 2025-10-18T11:29:16.036Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-921-debug-opposite-lock-ordering 2024-10-05T20:48:39.254Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-926-debug-missing-predicate-lock-scope 2024-12-31T12:29:16.291Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-932-debug-read-after-write-staleness 2025-08-13T21:22:58.324Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-942-debug-unbounded-cross-shard-fan-out 2025-09-05T21:07:24.765Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive 2025-10-04T09:59:12.135Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-902-cardinality-misestimation-and-wrong-join-plans 2026-06-02T11:37:41.231Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-906-stale-stats-vs-histogram-quality 2024-06-13T16:12:33.888Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-910-nested-loop-vs-hash-join-trade-off 2025-09-25T00:49:31.439Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-911-mvcc-bloat-and-cleanup-strategy 2025-02-21T15:38:20.662Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-916-covering-index-vs-heap-lookup-trade-off 2024-07-22T19:36:15.028Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-919-hot-updates-and-fillfactor 2026-01-27T16:28:09.611Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-920-isolation-levels-and-anomaly-prevention 2024-09-05T02:57:07.789Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-925-preventing-phantom-like-business-violations 2025-05-15T18:51:44.988Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-931-rpo-rto-trade-offs-for-critical-workloads 2024-03-21T17:57:28.659Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-936-read-consistency-contract-across-failover 2024-06-24T11:50:38.308Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-940-shard-key-evolution-strategy 2026-06-21T05:00:49.896Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-941-consistency-model-for-user-wallet 2025-09-16T10:00:50.354Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/module/m1-optimizer-cardinality-internals 2025-01-14T08:31:59.896Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m2-storage-index-mvcc-internals 2024-02-01T07:16:10.830Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m3-concurrency-isolation-deadlocks 2026-02-25T18:34:42.124Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m4-replication-recovery-failover 2024-08-05T23:29:22.170Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m5-distributed-sql-sharding-consistency 2024-01-14T12:59:14.004Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/optimization 2026-04-20T13:02:35.713Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-905-optimization-date-function-vs-range-predicate 2025-02-03T14:32:33.390Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-909-optimization-late-filter-vs-early-filter 2025-08-08T21:23:08.392Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-913-optimization-function-index-vs-plain-predicate 2024-09-02T17:25:00.507Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-918-optimization-composite-index-column-order 2025-03-29T06:25:45.726Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-930-optimization-replica-safe-daily-paid-orders 2026-01-20T15:03:31.351Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-935-optimization-commit-mode-for-payment-writes 2024-04-25T17:34:28.640Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-944-optimization-routed-query-vs-global-query 2024-12-09T12:14:44.754Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-945-optimization-global-index-vs-local-lookup 2025-07-09T05:33:57.027Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction 2026-06-07T11:06:26.795Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction/q-923-output-deadlock-victim-result 2025-03-23T19:59:42.498Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction/q-933-output-pitr-target-semantics 2024-11-29T01:51:09.818Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based 2025-06-09T07:04:17.314Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-901-top-failed-merchants-in-last-24-hours 2025-03-14T01:34:30.150Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-907-selectivity-probe-for-fraud-rules 2025-07-19T22:32:02.041Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-912-latest-active-catalog-version 2025-08-12T09:33:48.543Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-917-version-chain-head-query 2025-06-30T14:55:30.988Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-924-find-long-running-open-transactions 2025-05-22T12:33:55.557Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-938-shard-local-balance-snapshot 2024-07-07T19:15:40.837Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-939-cross-shard-transaction-frequency 2025-09-08T00:24:38.147Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based 2024-11-08T06:38:10.300Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-904-join-explosion-in-revenue-rollup 2026-06-18T11:31:26.926Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-908-plan-instability-from-parameter-sniffing 2024-06-29T07:01:01.681Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-915-vacuum-backlog-under-write-bursts 2024-10-24T10:16:56.624Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-922-retry-and-idempotency-for-deadlock-victims 2026-06-21T10:33:31.508Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-927-contention-control-in-flash-sale-checkout 2025-02-27T03:13:34.038Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-928-isolation-choice-for-mixed-oltp-analytics 2024-12-10T03:51:56.719Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-929-failover-runbook-after-region-outage 2024-04-17T15:27:50.781Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-934-backup-restore-validation-plan 2026-06-30T03:58:14.072Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-937-split-brain-prevention-controls 2024-07-25T05:07:14.258Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-943-hot-shard-rebalancing-plan 2025-11-05T09:48:25.374Z weekly 0.7 https://www.sql-practice.online/interview/topic/acid-properties 2025-06-14T06:58:35.739Z weekly 0.8 https://www.sql-practice.online/interview/topic/aggregations 2025-04-15T15:27:41.542Z weekly 0.8 https://www.sql-practice.online/interview/topic/ctes 2024-03-22T07:03:03.798Z weekly 0.8 https://www.sql-practice.online/interview/topic/database-design 2026-04-08T19:14:47.545Z weekly 0.8 https://www.sql-practice.online/interview/topic/indexing 2025-04-29T14:38:35.272Z weekly 0.8 https://www.sql-practice.online/interview/topic/joins-and-relationships 2025-05-28T19:55:10.189Z weekly 0.8 https://www.sql-practice.online/interview/topic/normalization 2025-07-22T04:41:26.277Z weekly 0.8 https://www.sql-practice.online/interview/topic/performance-tuning 2026-06-20T18:31:46.793Z weekly 0.8 https://www.sql-practice.online/interview/topic/query-optimization 2026-05-12T14:12:06.305Z weekly 0.8 https://www.sql-practice.online/interview/topic/sql-basics 2024-10-12T16:40:05.594Z weekly 0.8 https://www.sql-practice.online/interview/topic/stored-procedures 2026-02-26T17:16:58.245Z weekly 0.8 https://www.sql-practice.online/interview/topic/subqueries 2025-06-29T14:35:02.555Z weekly 0.8 https://www.sql-practice.online/interview/topic/transactions 2024-05-04T07:57:18.747Z weekly 0.8 https://www.sql-practice.online/interview/topic/triggers 2024-03-16T21:12:08.445Z weekly 0.8 https://www.sql-practice.online/interview/topic/window-functions 2025-08-27T12:11:43.542Z weekly 0.8