I will writing new sql queries
About this Gig
I will write new SQL queries and optimize existing queries for better performance, accuracy, and readability. I can help with simple to complex SQL queries, JOINs, CTEs, subqueries, window functions, data analysis, debugging, and query performance tuning. I work with SQL databases including Snowflake, Redshift, PostgreSQL, and other relational databases.
Expertise:
Data extraction
•
Data validation
•
ETL
•
Transformation
•
SQL
Technology:
Amazon Redshift
•
BigQuery
•
SQL
•
Snowflake
•
Oracle
Other Data Engineering Services I Offer
FAQ
What information do you need to write an SQL query?
Please provide the database type, table structure/schema, column details, and a clear explanation of the required output. Sample data is helpful but optional.
Can you write a new SQL query from scratch?
Yes. I can create SQL queries based on your business or data requirements, from simple queries to complex SQL logic.
Can you optimize my existing SQL query?
Yes. I can review your existing query and optimize it for better performance, readability, and efficiency.
Which databases do you support?
I can work with SQL databases such as Snowflake, Amazon Redshift, PostgreSQL, Oracle and other relational databases.
Can you work with complex SQL queries?
Yes. I can work with JOINs, CTEs, subqueries, window functions, aggregations, CASE statements, and other advanced SQL concepts.
Can you fix errors in my SQL query?
Yes. Please provide the query and error message. I can identify the issue and provide a corrected SQL query.
Do you provide explanations with the SQL query?
Yes. I can provide a brief explanation of the query logic and important optimization changes.

