SQL and ITIL Query

The_Hurricane

Hi All,

I've an interview approaching and the recruiter told me that although I don't have any experience on SQL and ITIL it would be advisable o read up on them as this would show the employer that I'm a fast learner. Are there any online courses that would give me a crash course in these two sectors?

Thanks

andrewjf

http://www.w3schools.com/sql/
http://www.sqlcourse.com/index.html

gb12345

The_Hurricane wrote: »

Hi All,

I've an interview approaching and the recruiter told me that although I don't have any experience on SQL and ITIL it would be advisable o read up on them as this would show the employer that I'm a fast learner. Are there any online courses that would give me a crash course in these two sectors?

Thanks

w3schools.com will give you an introduction to SQL.

You would really need to know what flavour of SQL the prospective employer uses, but at least you can learn the general syntax and standard commands.

paddyrg

Just to give a bit of perspective, though, SQL cannot be learned in a day or two. Actually the basic 4 data commands (SELECT, INSERT, UPDATE, DELETE) can be, but they probably aren't what anyone would hire SQL skills for. More likely they need people who understand RDBMS architecture, efficiencies, when to normalise and denormalise, how to optimise query execution, etc. These skills can all be learned, but they're not 'day 1' things.

Just so you're aware going into that interview that it's a deep subject.

andrewjf

paddyrg wrote: »

Just to give a bit of perspective, though, SQL cannot be learned in a day or two. Actually the basic 4 data commands (SELECT, INSERT, UPDATE, DELETE) can be, but they probably aren't what anyone would hire SQL skills for. More likely they need people who understand RDBMS architecture, efficiencies, when to normalise and denormalise, how to optimise query execution, etc. These skills can all be learned, but they're not 'day 1' things.

Just so you're aware going into that interview that it's a deep subject.

I totally agree with those comments. You can probably learn basic queries on a very superficial level, but to really 'get it' you need solid experience. It's a truly massive area of technical knowledge.

Depends what the interviewers are looking for. If they are prepared to take on someone and train them up, fair enough, but if they are looking for specific expertise within the database domain, then no way are you going to convince them that you have that level of knowledge, after taking a couple of crash courses on the subject.

Reggie_Rebel

You have two very different things here. SQL has been well explained. ITL is a best practice policy. You could read up on it but most employees would want you to hold the Foundation Certificate to prove that you understand and can work within the framework

phildamb

This also depends on what exactly the job is. Are you required to perform SQL queries or is this a support job where you simply need awareness to be able to trouble shoot performance or failures. Loads of free resources for ITIL their is a good ITIL article on Wiki that gives you a good outline for for ITILV3. SQL depends entirely on how they are using it but if youve been put forward and you havent got a lot of SQL history or any it may only need you to be aware of it. Even though SQL is upto SQL Server 2012 some companies still use SQL Server 2005.

The_Hurricane

A lot of companies seem to look for ITIL certification, what is the best course to complete online for beginners?

Mr_Toad

start here http://www.itil-officialsite.com

If you have no experience in SQL then the best you can probably hope for is that you demonstrate that you at least know what SQL (Structured Query Language) is and as suggested the w3schools site is a good place to start and get a basic understanding.

Good luck.

albionrovers

SQL can encompass Informix/Oracle/SQL Server/Sybase/DB2 and more ... all different flavours. Maybe ask which flavour(s) are used at interview?

closed

Select * from Google where data = "SQL ITIL FAQ" and wasteoftimefactor <1 order by recruitmentbullfactor