You are here:

Database Programming/Expert Profile

Iain M Watson

U.S.

Available

Expertise

I have 15 years of SQL experience in several large scale business catagories. I have many programs involving complicated SQL queires in both DB2 and Orcale databases. I have many years experience dealing with Database administrators in performance/tuning and implementing large scale SQL systems.

Experience in the area

I have designed many complicated SQL queries involving many aspects of the SQL syntax to obtain information from large databases with performance and efficiency as a major consideration.

Education/Credentials

Bachelors degree in Computer Science.

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Jeremy	10/04/09	10	10	10	10
Kelly	09/13/09	9	9	10	10

Recent Answers from Iain M Watson

2009-11-15 Question about query:

Hi, Your problem is that you need a GROUP BY statement at the end of the SQL statement for the columns you want to get unique values for. Also you will need to use the DISTINCT command on the individual

2009-10-04 conceptual database design:

Hi, this look like a relational databases question ?? If so then we are talking about existence dependency. Existence dependency describes whether an entity in a relationship is optional or mandatory.

2009-09-23 SQL Query:

Hi, I am not sure which database you are using, but most SQL is the same in relational databases. You need to use the count and group by verbs to the existing joins you are doing:- Select count(*)

2009-09-11 Which program to use:

Hi, If you want to use the database thru a webserver/browser yuo should probably use MySQL and apache server, also LAMP ( Linux, apache server, MySQL and Pearl - for scripting). MySQL is robust and

2009-08-19 access 2003 inventory database:

Hi, I am not completely clear on what you need. But a basic Inventory database has an Inventory table with stock reference number as the key, with a description, price, date updated, and total items

Answers by Expert:

Browse Answers: