I will write or fix sql queries for oracle and sql server
Full Stack Web Developer
Sobre este Serviço
Need help turning your database records into a useful report, fixing a SQL error or setting up a small relational schema?
I will write or fix SQL queries for Oracle Database or Microsoft SQL Server. My project experience includes donation, delivery, customer, sales and repair records, using joins, reporting views, cursors and exception handling.
Choose a single query, a small reporting query pack or a database setup of up to five related tables. Depending on the package, delivery includes commented SQL scripts, sample output and a short explanation of how to run the work.
Please send your database engine and version, table definitions, anonymised sample data, current query or error, and the output you expect. We will agree on the scope before work begins.
Message me first for PL/SQL procedures, larger schemas or performance work so I can confirm a suitable quote and timeline.
Tipo de banco de dados:
Banco de dados relacional
Plataforma:
Oracle
•
SQL Server
Especialidade:
SQL
•
DDL
•
DQL
•
Diagramas ER
Perguntas frequentes
Which databases do you support?
Oracle Database and Microsoft SQL Server. Please confirm the exact version before ordering.
Do you need access to my live database?
Table definitions and anonymised sample data are usually enough. The standard delivery is a set of scripts you can review and run in your own test environment.
Can you improve a slow query?
Share the query, schema and available execution plan first. Performance work needs an agreed scope, and results depend on the database and data volume.
What will I receive?
Commented SQL scripts and a short explanation. The selected package may also include test examples, a relationship diagram and schema setup instructions.
Do you offer database tutoring?
I can quote for explaining SQL concepts or helping you debug your own work. Any tutoring scope must be agreed separately.
