SQL development question

taylor34

Senior member
Nov 12, 1999
298
0
0
Hey--

Question to all of you programmers out there. I may have the opportunity to do some 'on the side' work using sql in the next couple months. I have these questions:

1) How hard is it to learn sql and get up to speed on it? I've got about 5 1/2 years of experience (computer engineer) using ada, C, visual basic, etc.

2) The application would be a sql database with 5 to 10 people connected to it. Not a complicated database or anything, in fact the actual database may not need changing at all, just the front end that they're actually using. From what I understand, their current sql application was wrote years ago but it doesn't really do what they want it to do (kind of limited). They want me to redo the interface to provide more functionality, and then later on add in web capability. Is that something that somebody like me could pick up and achieve in a reasonable time frame?

3) Are there any good IDE's out there for this type of work? Speed is a definitely a major factor, they can't have anything that's slow. I know that a lot of times IDE's aren't very efficient. I've used QT before for C/C++, something like that for sql might be good.

4) Lastly, what kind of time frame would you estimate for somebody to pull something like this off?

Thanks for the help guys (and gals). I basically know nothing about databases so I thought I'd ask here first.

Taylor34
 

Furor

Golden Member
Mar 31, 2001
1,895
0
0
You never really said what you're going to be doing..or what type of sql you will be using

1. Obviously depends what you will be doing, but the basics are pretty easy..building complex views, stored procedures, triggers etc can be tricky

2. How are they using the database? is the front end a program, webpage, etc?

3. For MS Sql Server..I use enterprise manager or management studio

 

taylor34

Senior member
Nov 12, 1999
298
0
0
I believe that their current database is some form of microsoft sql (not totally sure). Since I'm not really database literate at all, I can only approximate what they are trying to do. I believe that currently they use forms to enter in information, stuff that somebody else wrote a while ago. I believe that part of the problem is that the forms no longer fit their needs, and they need a lot more stuff added in at some point (web capability, etc.) None of the users are particularly tech savy or anything, so what looks extremely difficult to them actually may not be that bad.

Taylor34
 

homercles337

Diamond Member
Dec 29, 2004
6,340
3
71
It sounds like you will be designing (redesigning?) their database. Look into normalization and design.
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |