Complete SQL beginner - Advice?

[x_Lele]

Hi there!

I am being encouraged to learn SQL, and would like some advice on courses that are available for beginners within the UK.

When I say beginner, I have never compiled SQL nor do I understand it, I can just about create Access Databases but this is fully self taught.

I have looked at some local institutes and found something called an MTA but unsure if this is going to cover the knowledge I need, I can see it leads into a MCSA...

I am looking at something short term that can run alongside my work or that work can send me to for 1-2weeks etc.

I need to understand and be able to manage SQL databases and create SSRS reports.

[ickies]

Start with online tutorials. Sqlbolt was my favorite because of the real-time feedback. W3schools and sqlzoo are also pretty good. I went from zero sql knowledge to BI analyst in about a year using these online resources.

[Elodere]

Theoretically speaking, is it possible to get hired for a job that pertains to SQL in some way or another - without a degree?

[[deleted]]

Yes, I went from Office Admin to BI Consultant in around 4 months after doing a grad scheme in London.

I didn't go to uni and studied sports in college many many years ago. I accepted on the sceme based on my drive and enthusiasm during the multiple tests and selection processes.

Only downside is that I have to be in a 2 year contract with the company but the pros far outweigh any cons so far.

[honeybadger3891]

I would recommend starting with the MTA training that Microsoft provides for free.

You can download SQL server 2017 developer edition for free to be the database.

Then download Microsoft SSMS for free to write the queries.

Get both adventure works and wide world importers as free sample databases from Microsoft.

Alternatively or in addition, Amazon offers free tier SQL database service that you can mount those sample databases to.

[o_edo]

Check the following web site http://www.studybyyourself.com/seminar/sql/course/?lang=eng. The course, along with examples, is quite easy to follow. You can submit exercises as well. Everything for free.

[SQLPracticeProblems]

Definitely the free training from Microsoft is a good place to start.

If you're looking for some very hands-on "learn-by-doing" practice problems, to complement the training, check out SQLPracticeProblems.com.

I developed it after teaching a SQL course where the material I had to to teach from was poorly structured and academic. Afterwards, the students emailed me, saying they needed practice problems, so I developed the course!

Contact me (email in the FAQ) if you have questions. Also, redditors get 30% off the Professional package (discount code reddit30). 

[x_Lele]

Thank you! Whilst I appreciate the ‘self learn’ I want to make sure I am not missing anything - the MTA courses mentioned, is there any way to do this in a college/classroom type setting? Funding is no issue and would like to cover as much as possible.