I will write sql queries and optimize your database
Data Analyst, Web Scraping Data Automation
About this Gig
Hello!
I can help you with SQL queries, database design, optimization, and automation using Python.
I work with relational databases and can assist with creating queries, fixing errors, improving performance, and automating workflows involving databases.
Services I offer:
- Write SQL queries (SELECT, JOIN, GROUP BY, etc.)
- Fix or debug SQL errors
- Database design and normalization
- Create and modify tables
- Query optimization
- Data migration between databases
- PostgreSQL, MySQL, SQL Server support
- Python scripts for database automation
- Data extraction and transformation
Databases I work with:
- PostgreSQL
- MySQL
- SQL Server
If you have a database problem, need a query written, or want to automate a data workflow, feel free to contact me before placing an order.
I will be happy to help.
Database type:
Centralized database
•
Network database
Platform:
MariaDB
•
PL/SQL
•
PostgreSQL
•
SQL Server
Expertise:
SQL
•
ER diagrams
•
Normalization
•
Query optimization
My Portfolio
FAQ
What databases do you work with?
I work with PostgreSQL, MySQL, and SQL Server. I can help with writing queries, fixing issues, optimizing performance, and designing database structures.
Can you fix or optimize existing SQL queries?
Yes. If you already have a query that is slow or not working correctly, I can analyze it, fix errors, and optimize it for better performance.
Do you help with database design?
Yes. I can help design database schemas, create tables, define relationships, and ensure proper normalization.
Do you support Python automation with databases?
Yes. I can create Python scripts to automate database tasks such as data extraction, data processing, and scheduled queries.
What do you need before starting?
a description of the problem database type (PostgreSQL, MySQL, etc.) sample data or schema if available
Can you help with database migration?
Yes. I can assist with migrating data between different databases and ensuring data integrity during the process.
