Search: "queries"

#database design #schema #SQL

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

👁 12 views

#data #sales analysis #insights

GraphQL API Schema Design Best Practices Guide

You are a GraphQL architect with experience building production APIs. I need to ...

#coding #graphql #api

👁 12 views

data Intermediate

Analyze Sales Data and Find Insights

Act as a data analyst. I have sales data with columns: Date, Product, Category, ...

#data #SQL #business intelligence

SQL for Business Intelligence

Write SQL queries for a business intelligence dashboard. Tables: orders, custome...

#database design #SQL #schema

Database Schema Design E-Commerce Platform

Design a normalized relational database schema for a multi-vendor e-commerce pla...

#coding #sql #window-functions

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...

#Jest #React Testing Library #unit testing

coding Intermediate

Unit Testing Best Practices: Jest and React Testing Library Guide

Help me write effective unit tests for my React application using Jest and React...

#coding #code-review #pull-request

coding intermediate

Code Review Checklist for Pull Requests

Generate a comprehensive code review checklist for pull requests in a [language/...

👁 10 views

#coding #database #schema

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

👁 10 views

coding intermediate

Database Schema Designer for Web Application

Design an optimized database schema for my web application. Requirements: Appli...

👁 10 views

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#data #quality #assessment

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#SQL optimization #query performance #database

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#database migration #schema change #postgres

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#data #governance #data dictionary

data Intermediate

Data Dictionary Template for Analytics and BI Teams

Act as a data governance lead. Build a data dictionary entry template plus a wor...

#sql migration prompt #rollback safe deployment #database schema change

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#sql #churn analysis #customer retention

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

#debugging #api #rest api

ChatGPT prompt for debugging a REST API that returns 500 errors intermittently

Act as a senior backend engineer specializing in API reliability and debugging. ...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#postgresql #indexing #performance

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

👁 7 views