Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "postgres"

26 prompts matching "postgres"

"postgres" ✕ Clear all ✕
data Intermediate

ChatGPT Prompt: SQL Window Function Tutorial With Practical Examples

You are a SQL teacher. Walk me through window functions using realistic examples...

#data #sql #window-functions
👁 29 views
data Advanced

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

#cohort analysis #retention #sql
👁 18 views
data Advanced

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...

#ETL #data warehouse #data pipeline
👁 15 views
data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

#sql #optimization #performance
👁 14 views
data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres
👁 14 views
coding Advanced

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

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

#database migration #schema change #postgres
👁 13 views
coding Intermediate

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

#coding #database #migration
👁 13 views
coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

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

#sql migration prompt #rollback safe deployment #database schema change
👁 12 views
coding Advanced

SQL Query Optimizer With EXPLAIN Plan Walk-Through

I have a slow SQL query against [DB ENGINE — Postgres / MySQL / SQL Server]. The...

#coding #sql #performance
👁 12 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

#data #sql #cohort-analysis
👁 12 views
coding Advanced

Write a Postgres Migration That Adds a NOT NULL Column to a Large Table

Write a safe Postgres migration for a 50M-row production table (heavy write traf...

#coding #postgres #migration
👁 12 views
data advanced

Data Pipeline Monitoring Alerting Strategy Production

Design a monitoring and alerting strategy for a production data pipeline. My pip...

#data pipeline #monitoring #data quality
👁 9 views
data Advanced

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql
👁 9 views
data Advanced

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort
👁 9 views
data Intermediate

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#data #SQL #funnel analysis
👁 7 views
coding Advanced

Write a Migration Plan for Renaming a Database Column

Plan a zero-downtime rename of database column [OLD_NAME] to [NEW_NAME] on table...

#coding #database #migration
👁 6 views
data Advanced

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

#data #cohort analysis #retention
👁 5 views
data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query
👁 5 views
data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#data #sql #query-optimization
👁 4 views
data Advanced

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention
👁 4 views
excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision
👁 4 views
data Intermediate

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn
👁 4 views
data Intermediate

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

#sql #analytics #business-questions
👁 4 views
coding Advanced

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

#coding #sql #performance
👁 3 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval