I will design your sql server, mysql database and write sql queries
About this Gig
I design SQL Server and MySQL databases and write SQL queries from your requirements.
WHAT YOU GET:
- Schema design: tables, keys, relationships and constraints.
- ERD diagram and a ready-to-run SQL script.
- SQL queries: joins, aggregations, filters and reports.
- Fixes for queries that return wrong results.
- Sample data for testing, available as an extra.
WHAT I NEED FROM YOU:
- A description of what the database must store.
- Your existing schema or sample data, if you have one.
- The database system: SQL Server or MySQL.
WHAT I DON'T DO:
- Server setup, hosting or administration.
- Application or back-end development.
ABOUT ME:
Computer Science graduate. I designed the SQL Server database for Equipify, a rental marketplace: 6 tables with relationships, cascade and restrict rules, and unique constraints.
Message me before ordering so we can confirm scope.
Platform:
MySQL
•
Oracle
•
PL/SQL
•
SQL Server
Expertise:
Design
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
Which databases do you work with?
SQL Server and MySQL.
Can you fix my existing database?
Yes, for queries and schema issues. Send the schema and the problem.
Do you host or set up my server?
No. I deliver scripts and diagrams you run yourself.
What do I receive?
A SQL script, an ERD image, and queries as a .sql file.
