Newd And Screwd

[pinktek]

HEY ALL! I am new to all of this and recently picked up a contract to assist new company with recommendations. The first is that their database is full of info that is outdated. So they want me to query info of people who are inactive and delete. Then they want me to update and make it a relational database. I practiced this in theory but now its time to get to work. the contract starts in June so there is hope how should i proceed without making their system fail

[rmiao]

Take some sql calsses, you still have time to learn.

[pinktek]

I took classes at my local university but it just is not the same! I just couldnt get the practice on this site to work and thats what i need mad practice- I created the table (practice on this site)
insert into
mypeeps_ll0375
('firstname', 'lastname', 'title', age, salary)
values
('Jonie', 'Weber', 'Programmer', 32, 25000.00)
do yall see anything wrong with this?
it kept saying there was an error
thanks in advance

[skhanal]

You should remove single quotes from column names

insert into
mypeeps_ll0375
(firstname, lastname, title, age, salary)
values
('Jonie', 'Weber', 'Programmer', 32, 25000.00)

[stecal]

You could always outsource the database/other parts you don't have the expertise for.

[pinktek]

gotta get our feet wet sometime or other- just wanted advice on how not to lock up their system like what is the current trend for this and any advice you could give a newbie

[rmiao]

Not sure what you are asking for.

[pinktek]

at first I was asking about a couple of mistakes I made but that was cleared up- now i was just asking some general advice like what is the biggest mistakes made when creating relational db? Just really trying to get a feel
thanks for your input

[rmiao]

You may don't like it, it depends. A db design works great for certain case but maybe disaster for others.