I will write fix and explain your sql query in sql server oracle or mysql
Backend Developer
About this Gig
I write, fix and explain SQL queries - clearly, and in plain English or Greek.
I work with SQL Server, Oracle, PL/SQL, PostgreSQL, MySQL and MariaDB
as a technical consultant on a business ERP system, so I am used to
real production schemas, not textbook examples.
WHAT YOU GET
Your query, written from scratch or repaired
A short explanation of how it works, so you can adapt it yourself later
Results exported to CSV or Excel (Standard and Premium)
TYPICAL REQUESTS I HANDLE
"I need a report showing X, grouped by Y"
"This query returns the wrong number of rows"
"This JOIN is duplicating my data"
"How do I combine these three tables into one result?"
WHAT I NEED FROM YOU
Your table structure - CREATE TABLE statements, a screenshot, or an export
A few rows of sample data (anonymised or made-up is fine)
A plain description of the result you want
WHAT I DO NOT DO
Performance tuning, indexing strategy or server configuration
Database administration, migrations or backups
Database type:
Centralized database
•
Relational database
Platform:
MariaDB
•
MySQL
•
Oracle
•
PL/SQL
•
PostgreSQL
•
SQLite
•
SQL Server
Expertise:
Data structure
•
Design
•
ERD
•
Normalization
•
SQL
FAQ
Do you need access to my database?
No. Send me your table structure (CREATE TABLE statements or an export) plus a few sample rows, and I rebuild your tables on my own machine to test the query before I deliver it. Your data and credentials stay with you.
How do I get my table structure?
Most database tools have a "script table as CREATE" or "export schema" option. If you are not sure how, message me which platform you use and I will send you the exact steps. A screenshot of the columns works too.
My data is confidential. What can I send?
Made-up sample data is fine, and often better. I only need to see the column names, types and how the tables relate. Two or three fake rows are enough for me to test correctly.
Can you make my slow query run faster?
That is performance tuning, and it is not what this gig covers. I write and fix queries so they return the right result. If speed is your main problem, you want a seller who specialises in indexing and execution plans.
What if the result is not what I expected?
Message me and I will fix it within your package's revisions, as long as it matches what you originally described. If the requirements change after delivery, I will send you a small custom offer instead.

