Basic SQL work: SQL queries, inserting, searching for fields
$30-250 USD
Paid on delivery
Hi there,
I need an individual who is fluent in SQL. I have a number of technical questions that need to be answered. You must be fluent in SQL and understand SQL queries. In short, you must be able to:
. Query to return all data linked to a primary key
. Query to search full database and return information based on a specific keyword - e.g. return all entries in the database that have the name: "ABC"
. Query to add or drop data
. Query to return total number of entries
. Query to make one field equal to another
The technical aspect of this is fairly simple. What is most important is that you able to understand English to a high level: you must be able to read and write well.
I am going to repeat this, because it seems as though so many people on Freelancer don't actually read the project descriptions properly:
=====================================================================================
***
You must be able to read and write English properly. For this project, you will need to write out the correct answers. Essentially, you need to write out the correct SQL query, and then explain why you chose that query (as opposed to another query) and what it does. You will also need to respond a couple of other technical questions about modifying data and managing databases.
**
=====================================================================================
Please get back to me as soon as possible as this is on a tight timeline.
This is a very straightforward and simple project, but I have gone into a lot of detail because lately I have been disappointed many of the people who get back to me.
*****In your responses to me, please demonstrate to me that you understand SQL, and that you have good English language skills. Broken English and incomprehensible responses will be ignored.*****
Let me know if you have any questions!
Project ID: #1305026
About the project
Awarded to:
29 freelancers are bidding on average $141 for this job
Hello I can do this for you. Please read my private message for more details. Regards Faisal
Hi I am interested in this project, I have oracle, pl/sql experience. I have written these basic queries many time. I am ready to start the project. Thanks
Hi! I have 11 years experience in MS SQL and Access. I created difficult account systems on C# and (Access or MS SQL). Regards.
Is this an assignment? LOL. Just kiddin'. Based on the description that you provided, it seems that my SQL knowledge is just enough for those queries. You can try sending me some questions, I'll give you the answ More
Hi, I can write out a detailed and comprehensible summary for the queries I write. To better support by bid, I've sent you a PM with information I would rather not have displayed publicly. Thanks MAV_IT
Hi, I'm a native English speaker with MySQL knowledge. I can do this project quickly and articulately. Thanks for your time.
Hello! I am a Microsoft Certified Technology Specialist in SQL Server 2008 (MCTS), i have a very good experience in SQL Server 2000,2005 and 2008. provide me with the details to begin. Thank you. Maen Shahadi.
Hi I can do this project for you. I have 3 years of rich experience in SQL. We can start working on this ASAP. Please share the details.
I'm a GNIIT student. I have done many projects based on SQL queries that return data to front end. I can explain the use of each query clearly. I request you to grant this project to me. Thank you.
Sir, As I have read the job description carefully and would like to offer my services for this job. I have 5 years database development experience using Oracle, mysql and MS Access. I have also developed business More