Search: "database"

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

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

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

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

#SQL #window functions #analytics

SQL Window Functions Advanced Analytics Queries

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

coding intermediate

Docker Containerization for Python Flask Applications

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

#coding #docker #python

#data #etl #data-warehouse

ETL Pipeline Design for Cloud Data Warehouse

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

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

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

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

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

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

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

#Power BI #DAX #dashboard

Power BI Dashboard Design Executive Sales Report

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

SQL Query Optimization: Fix Slow Database Performance

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

#data #sql #optimization

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

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

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