You are here:
- Home
- Industry
- Data Management
- Database Programming
Database Programming/Questions Answered by Expert Iain M Watson
| Subject | Date Asked |
| DB by PHP & MySQL | 1/22/2010 |
| Q: I'm looking for a best friendly and easy Administrative front-end Database using PHP & MySQL. I ... A: I know AppGini is free and I have heard good things about it, although I have never used it myself. ... | |
| embed video in a database | 1/7/2010 |
| Q: Hey, I recently got into web designing and decided to make a website to stream videos and I just ... A: Yes you will need an OBJECT database like ORACLE to embed video, graphics audio, graphs, and photos ... | |
| Question about query | 11/15/2009 |
| Q: I have the following query: SELECT * FROM PickListDetails WHERE Quantity=(SELECT MAX(Quantity) from ... A: Your problem is that you need a GROUP BY statement at the end of the SQL statement for the columns ... | |
| conceptual database design | 10/4/2009 |
| Q: I have a question on a homework problem asking me to Identify the mandatory/optional dependencies ... A: this look like a relational databases question ?? If so then we are talking about existence ... | |
| SQL Query | 9/23/2009 |
| Q: In a view I want to count the number of activities (CMTR_WR_ActivityType) per person ... A: I am not sure which database you are using, but most SQL is the same in relational databases. You ... | |
| Which program to use | 9/11/2009 |
| Q: I have built an Access database that I want to re-write in a different program for resell as web ... A: If you want to use the database thru a webserver/browser yuo should probably use MySQL and apache ... | |
| access 2003 inventory database | 8/19/2009 |
| Q: My question is that I need to create and inventory database that can be added to and subtracted from ... A: I am not completely clear on what you need. But a basic Inventory database has an Inventory table ... | |
| Dbms | 7/17/2009 |
| Q: what is the basic difference between DBMS & RDBMS? A: RDBMS is "Relational database management system", DBMS is the same minus the relational. There are ... | |
| calculations in databases | 7/13/2009 |
| Q: how do i create an expression that affects two fields in two different tables in a form A: You can use the POST_TRIGGER command. You can have a block level POST_INSERT trigger on one table ... | |
| Database and caller id | 7/10/2009 |
| Q: My friends parents run a small cleaning company. They have some database that was written by someone ... A: This is not an area of my expertise, but there are a few companies that I have found on the ... | |
Database Programming
Answers by Expert:
Iain M Watson
Top Expert on this page
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
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.
©2012 About.com, a part of The New York Times Company. All rights reserved.