SQL courses - recommendations please - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

KathyWoolfe replied

28 October 2008, 11:02
Originally posted by Spacecadet View Post

replacement? from what I can see IMS is still current and hasn't been replaced

Originally posted by darmstadt View Post

Yes and no. It is IBM's relational database but it is not a replacement for IMS which is still going very strong.

Sorry, maybe I should have used the word alternative instead. IMS is only current because of the inertia of companies to re-develop some of their legacy code with newer technology.
Leave a comment:
darmstadt replied

28 October 2008, 10:52
Originally posted by KathyWoolfe View Post

DB2 is IBM's relational database - replacement for IMS.

Yes and no. It is IBM's relational database but it is not a replacement for IMS which is still going very strong. Remember also that DB2 is quite varied across platforms. Most platforms use DB2 UDB so that it is pretty consistent across the various platforms but when you get to DB2 for VM/VSE then there are quite a few differences (as it is still not part of the UDB family) which means that a DB2 application/database/whatever which is fine on z/OS will not function on z/VM.
Leave a comment:
Spacecadet replied

28 October 2008, 10:45
Originally posted by KathyWoolfe View Post

DB2 is IBM's relational database - replacement for IMS.

replacement? from what I can see IMS is still current and hasn't been replaced
Leave a comment:
expat replied

28 October 2008, 10:36
Originally posted by KathyWoolfe View Post

DB2 is IBM's relational database - replacement for IMS.

And is what SQL was made for in the first place.
Leave a comment:
KathyWoolfe replied

27 October 2008, 14:16
Originally posted by Bumfluff View Post

Whats DB2 ?

DB2 is IBM's relational database - replacement for IMS.
Leave a comment:
Bob Dalek replied

27 October 2008, 13:53
Originally posted by TheBigYinJames View Post

Please switch your PC off then on again, then call back, and ask for Arthur.

Ah! You are.
Leave a comment:
TheBigYinJames replied

27 October 2008, 13:50
Originally posted by Bob Dalek View Post

Are you from Mumbai?

Please switch your PC off then on again, then call back, and ask for Arthur.
Leave a comment:
Bob Dalek replied

27 October 2008, 13:46
Originally posted by TheBigYinJames View Post

Yeh I know, I realised when I started I'd get the usual Transact/PL-SQL "you can't do that" comments so I went for some generic pseudoSQL just to get the laboured joke over.

Are you from Mumbai?
Leave a comment:
lightng replied

27 October 2008, 13:17
Basic free online courses:

http://sqlcourse.com

and

http://sqlcourse2.com

update tblInterview
set interviewer_state = 'impressed'
where job_role = 'BA'
and requirements = 'SQL';
Leave a comment:
TheBigYinJames replied

27 October 2008, 12:16
Originally posted by Spacecadet View Post

you're missing some brackets

Yeh I know, I realised when I started I'd get the usual Transact/PL-SQL "you can't do that" comments so I went for some generic pseudoSQL just to get the laboured joke over.
Leave a comment:
Spacecadet replied

27 October 2008, 12:13
Originally posted by TheBigYinJames View Post

SELECT TOP 1 course FROM all_courses
WHERE how_good = 'good'
AND where_it_is = 'down london way'
OR where_it_is = 'Northampton direction'

you're missing some brackets
Leave a comment:
TheBigYinJames replied

27 October 2008, 12:02
Originally posted by norrahe View Post

Does anyone know of a good course, either down London way or Northampton direction.

SELECT TOP 1 course FROM all_courses
WHERE how_good = 'good'
AND where_it_is = 'down london way'
OR where_it_is = 'Northampton direction'
Leave a comment:
norrahe replied

27 October 2008, 12:00
i've ordered the book.

if i read the first few chapters can i apply as well?
Leave a comment:
Bumfluff replied

27 October 2008, 11:44
Originally posted by KathyWoolfe View Post

Can I apply?

I have all that and more SQL as I've been using DB2 for at least 2 decades

Whats DB2 ?
Leave a comment:
KathyWoolfe replied

27 October 2008, 11:19
Originally posted by Bumfluff View Post

I'm interviewing at the moment for a BA and one of the requirements is basic SQL knowledge. My expectations is someone who can do a basic SELECT FROM and join a few tables, and can use aggregate functions like SUM etc and know where to put the GROUP BY. You could get all that from the first couple of chapters.

Can I apply?

I have all that and more SQL as I've been using DB2 for at least 2 decades
Leave a comment: