help with SQL...

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi everyone, i'm on the way to get MCDST soon, and looking forward to learn about DB's as i always wanted to be in this field, but i don't realy have experience with SQL or whatsoever, so is anyone could advise me where i should start and what certs i would need to do next???
Thanks a lot.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

you do realise the MCDST has nothing to do with SQL and databases?

 

Hi, thanks for reply, i do realise that MCDST is not realy related with DBs, i 'm doing it generally for my self for knowledge, also i have chance to have a job at my work as tech.support, and not too far from doing a freelance job trubleshoot PC and laptops, but learning DB its my personal desire

 

no problem just your post sounded otherwise.

You could get into Microsoft Access that is often a techs first taste of databases, and can use SQL queries.
There are certs for MS Access, called Microsoft Certified Application Specialist (MCAS).

Then there advanced certs for SQL server administration (MCDBA, MCTS and MCITP)

There is also probably some database coverage in the development certs (MCSD)

I would start of with access and learning SQL there are loads of good books.
Also get a good book on general relational database design

 

just be careful there are some real middle man rip off merchants out there

 

Thanks for info man, i will have a look at it!

 

And are an abomination unto man.

MS Access is the biggest abomination ever to have existed, and should never, never be permitted within a corporate environment. In fact, I would go so far as to say that I would happily set anyone caught using it on fire, were I permitted to enact such a policy at work.

 

*quietly shoves the legacy access db front end we haven't replaced yet out of sight*

I've got to agree with this, Access is a hell hole of bad db construction.

You can either grab SQL Express for nothing from Microsoft or look at MySQL (be prepared for the fact that the 2 do have quite a lot of differences and what you learn in 1 may be as useful as a chocolate teapot in the other). If you want to end up working on enterprise DBs these are your place to start, avoid Access at all costs/