In Progress

Basic SQL work: SQL queries, inserting, searching for fields

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!

Skills: Data Processing, Database Administration, Microsoft Access, MySQL, SQL

See more: what you need to know about freelancer, what skills does a freelancer need, what is the work of a freelancer, what does freelancer, t sql freelancer, technical freelancer search, sql queries freelancer, searching for work, searching for a freelancer, people search work, linked in freelancer, linked freelancer, get work on freelancer, freelancer sql database, freelancer sql c#, freelancer search sql, freelancer questions and answers, freelancer it sql, freelancer in it fields, freelancer for fluent, freelancer fields, freelancer databases, freelancer back out, freelancer answers, english basic skills

About the Employer:
( 22 reviews ) New York, United States

Project ID: #1305026

Awarded to:

sikandermandal

Please See PMB.

$100 USD in 2 days
(15 Reviews)
5.1

29 freelancers are bidding on average $141 for this job

forrestwang

hi sir, i just checked your spec, check details.

$200 USD in 4 days
(12 Reviews)
5.3
thanhlongfree

Hello. Please check PM

$30 USD in 1 day
(20 Reviews)
5.3
MattThrower

I have over 8 years of SQL experience.

$200 USD in 1 day
(17 Reviews)
5.2
dataconsultants

Please check PMB for details. Thank you

$60 USD in 1 day
(58 Reviews)
5.1
VBAWhizz

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 multi More

$250 USD in 2 days
(8 Reviews)
4.8
marasinghe82

Dear Sir, I'm ok for start right now. Thanks, Jinesh

$50 USD in 1 day
(30 Reviews)
4.8
instech

Kindly see the PM for my comments and bid details.

$165 USD in 3 days
(7 Reviews)
4.7
ifaisal

Hello I can do this for you. Please read my private message for more details. Regards Faisal

$150 USD in 1 day
(11 Reviews)
4.4
PerfectSquare

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

$30 USD in 0 days
(34 Reviews)
4.4
GediminasB

Hello, I am certificated .NET/C# programmer working in this region since 2002. Main specialization is creating WEB/WCF services and MS SQL server programming. All your tasks are clear except searching. What do mean More

$240 USD in 7 days
(3 Reviews)
4.4
DeoTech

Hi! I have 11 years experience in MS SQL and Access. I created difficult account systems on C# and (Access or MS SQL). Regards.

$200 USD in 2 days
(5 Reviews)
4.1
rfuentescruz

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

$100 USD in 1 day
(2 Reviews)
3.0
manohartvs

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

$100 USD in 1 day
(3 Reviews)
2.9
inus

Hi, I'm a native English speaker with MySQL knowledge. I can do this project quickly and articulately. Thanks for your time.

$150 USD in 3 days
(1 Review)
2.0
mshahadi

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.

$150 USD in 3 days
(1 Review)
2.0
sweetuu4u

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.

$200 USD in 4 days
(0 Reviews)
0.0
a2zprogrammer

6 years of SQL experience. Fluent in SQL

$200 USD in 2 days
(0 Reviews)
0.0
solutionanyway

hi, please see pm!

$48 USD in 1 day
(0 Reviews)
0.0
hoangdat

Dear sir, Please take a look at private message for proposal

$100 USD in 3 days
(0 Reviews)
0.0
instaDBA

Hello, I've worked as a SQL Server DBA for over 10 years and I am a native English speaker. Regards, Brian

$250 USD in 3 days
(0 Reviews)
0.0