Kategorien durchsuchen
Entdecken
Fiverr Pro
Deutsch
$
USD
I will design mysql database schema and write optimized sql queries
Electrical and Information Engineer, Database and CAD Specialist
I am an Electrical & Information Engineer specializing in database architecture and technical engineering design.
My services cover two dedicated tracks:
1. Database Systems: Normalized MySQL schema...
Über diesen Service
Are slow database queries, bad table relationships, or unorganized records holding your project back?
A poorly designed database causes sluggish apps, high server load, and annoying bugs. I will design a clean, normalized relational database schema or optimize your existing MySQL queries for maximum performance and speed.
What I offer:
Relational Schema Design: Normalized (3NF) structures with primary/foreign keys, constraints, and cascading rules.
Visual ER Diagrams: Clean Entity Relationship Diagrams (ERDs) generated via MySQL Workbench or dbdocs.
Query Optimization: Rewriting slow SELECT queries, fixing joins, and adding composite indexes for instant performance gains.
Custom SQL Scripts: Writing clean views, stored procedures, triggers, and complex CTE queries.
Dummy Seed Data: Providing sample INSERT scripts to test your schema right away.
NoSQL Design: Document modeling and aggregation pipelines for MongoDB or Neo4j.
Deliverables:
1. Executable, fully commented .sql scripts.
2. High-resolution ER diagram (PDF/PNG).
3. Clear instructions on running the scripts in your environment.
Please message me with your requirements before ordering so we can confirm the exact scope!
Plattform:
MongoDB
•
mySQL
•
neo4j
Expertise:
Design
•
erd
•
Normalisierung
•
SQL
FAQ
What format will I receive my delivery in?
You will receive a ZIP file containing the executable .sql script with clean comments, a visual ER diagram in PDF or PNG format, and a brief execution guide.
Do you need access to my live server or hosting?
No. You do not need to share server credentials. You can provide your business rules, requirements, or an offline schema dump, and I will deliver standalone scripts that you can test and run safely.
Can you work with existing databases that are running slowly?
Yes. Share your current table structure and the slow query. I will analyze the execution plan, rewrite the query, and provide index recommendations to boost performance.
Do you support databases other than MySQL?
Yes. While MySQL is my primary engine, I also handle NoSQL collections and aggregation pipelines in MongoDB and graph models in Neo4j.
