Learning SQL

BD10NNF · 10 Nov 2015 at 10:25

Hi guys and gals,

I'm wanting to learn SQL. I know a little bit already. I know how to install the software, how to add users, run a query, run a script and make the changes needed, how to edit tables and change security settings for each user on the database.

Is there anything else I need to know that is worth learning?
What reading material is there that would be beneficial (I'm guessing the For Dummies book might not cover what I need)?

Thanks for your help.

BD10NNF · 10 Nov 2015 at 10:31

It will be a bit of everything really. I want to try cover all bases even just learning the basics.
Then when I know that I can look to develop more towards either the database side or the quires and writing code. Depending on what my role in the future requires.

I'm mainly looking for reading material but not sure where to start. Like I said I don't fancy buying those For Dummies books if it's going to cover what I already know. I mainly know the basics of the database side. So Creating a database, running the script needed for that database, finding customer names within that database etc

BD10NNF · 10 Nov 2015 at 10:42

Cruiser said:
you could look at MTA qualifications
http://www.certiport.com/portal/common/documentlibrary/MTA_Skills_Development_Roadmap.pdf

learn and get a certification out of it.

It's getting time to study for the course and attend, my life is chaotic most of the time. I get maybe an hour or 2 in the evening to read if I'm lucky. I'd want to get a qualification when I am more confident in SQL. I know that the courses can be costly if you fail the exam.

BD10NNF · 10 Nov 2015 at 12:22

Burnsy2023 said:
I'll second this. DBA/DB Dev is much of my role at the moment and although I've done a lot of training, the basics are well covered by pluralsight videos.

What DB backends are most prevalent at your work?

It's mainly just SQL 2008. Simple queries like where client_name blah blah blah is use a lot to find people.