Search: "database-tuning"

productivity Intermediate

Notion Database System for Project and Task Management

Act as a Notion power user and productivity systems designer. Create a complete ...

#productivity #Notion #project management

coding intermediate

Python FastAPI: Build Production-Ready REST APIs

Act as a senior Python backend engineer experienced with FastAPI. Help me build ...

#coding #python #fastapi

#coding #database #schema

coding intermediate

Database Schema Designer for Web Application

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

#database design #schema #SQL

Database Schema Design from Requirements

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

👁 18 views

data Intermediate

Customer Segmentation Analysis with RFM Model

Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...

#RFM analysis #customer segmentation #data analysis

👁 18 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

#coding #Docker #docker-compose

Docker Compose for Full Stack App

Write a docker-compose.yml for a full stack application with: 1) Frontend (React...

#data dictionary #analytics schema #documentation

data Intermediate

ChatGPT Prompt for Data Dictionary from a Messy Analytics Schema

Help me create a clear data dictionary from a messy analytics database so busine...

productivity intermediate

Notion Second Brain Setup Personal Knowledge Management

You are a productivity systems expert and certified Building a Second Brain prac...

#productivity #notion #pkm

#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...

#python #fastapi #rest-api

Python FastAPI REST API Production-Ready Setup Guide

Build a production-ready Python FastAPI REST API from scratch with enterprise pa...

#microservices #architecture #design-patterns

Microservices Architecture: Design Patterns & Communication Strategies

Design a microservices architecture for my system. Context: System description:...

#JWT #authentication #refresh tokens

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

#sql review #board reporting #metric qa

data Advanced

ChatGPT Prompt for SQL Query Review Before Sharing a Board Report

Review my SQL query before I use it in an executive or board report where mistak...

#coding #sql #stored-procedure

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

#database design #SQL #schema

Database Schema Design E-Commerce Platform

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

SQL Query Optimization for Slow Database Queries

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

#coding #sql #database

#power query #M code #data transformation

excel advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#data #etl #data-warehouse

data advanced

ETL Pipeline Design for Cloud Data Warehouse

You are a data engineer specializing in cloud data infrastructure. I need to des...

#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...

#nextjs #app-router #server-components

coding intermediate

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

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