Search: "database-tuning"

#database design #SQL #schema

coding advanced

Database Schema Design E-Commerce Platform

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

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

Docker Containerization for Python Flask Applications

You are a DevOps engineer specializing in containerization. I need to containeri...

#coding #docker #python

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

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

#Python #pandas #data cleaning

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

#SQL #GROUP BY #window functions

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

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

#XLOOKUP #VLOOKUP #Excel formulas

excel Intermediate

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#Docker #Docker Compose #containers

Docker Compose: Multi-Service Application Setup and Configuration Guide

Help me set up a Docker Compose configuration for a multi-service application. I...

#Node.js #Express #REST API

Node.js Express API: CRUD Operations with Authentication Boilerplate

Help me build a production-ready Node.js REST API with Express. I need a complet...

#coding #database #schema

Database Schema Designer for Web Application

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

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#nextjs #app-router #server-components

Next.js App Router: Server Components & Data Fetching Patterns

Help me master Next.js 14+ App Router with Server Components. My situation: Pro...

#coding #sql #query optimization

coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#sql #churn analysis #customer retention

data Advanced

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

coding Advanced

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

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

#coding #docker #docker-compose

Docker Compose Setup for Full-Stack Application

Write a complete docker-compose.yml for a full-stack application with the follow...

#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

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

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

#Python #web scraping #BeautifulSoup

Python Web Scraping: BeautifulSoup & Requests Data Extraction

Help me write a Python web scraper to extract [type of data] from [website descr...

#python #web scraping #beautifulsoup

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

data advanced

SQL Query Optimization: Fix Slow Database Performance

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

#data #sql #optimization

#kubernetes #k8s #deployment

coding advanced

Kubernetes Deployment Configuration: Production Best Practices Guide

Help me create a production-ready Kubernetes deployment configuration. My applic...