Basic SQL work: SQL queries, inserting, searching for fields
$30-250 USD
Completed
Posted over 12 years ago
$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!
Hi, I am a qualified Microsoft trainer and database designer - specialising in Access and SQL. I am also a SQL Administrator and have extensive experience of SQL views, functions and procedures. I have written multiple technical manuals in English for training courses - one chapter of which is an introduction to SQL. Please see PMB for further details.
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
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 answer and then you decide whether or not to take my bid.
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
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.
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 software like Inventory, accounts, payroll, attendance systems etc.
I have strong command over SQL and tuning the quires. Hope to be considered for this job.
Regards,
Muhammad Muazzam
please give up me the chance to solve yours problem
i working as a database administrator at a election office.
i am perfect for your required project
i have wide experience with msaccess 2003,oracle and sqlite3.
for contact you add me in skype
trignesh_solanki2001