IT training in SQL Server/VB.NET etc
IT training in SQL Server/VB.NET etc
Author
Discussion

Z064life

Original Poster:

1,926 posts

279 months

Sunday 22nd July 2007
quotequote all
I'm a budding programmer/web developer etc, and my experience on projects is increasing.

However, whenever I build a system there is also a need to stop and find out how to implement some sort of functionality. This is despite me reading books and practising tutorials, making my own stuff. I'm thinking about doing a course on what I want to improve on, to cure this problem. I want to be excellent at what I do (I.T.).

My question to you PHers is, has anyone here done a course on SQL Server/ADO.NET/VB.NET? If I master this, I'd really fulfill my potential. Books etc are all good, but sitting in a class on a course is better as you've spent money and cannot just walk away from the lesson like you can when you teach yourself (I've taught myself a lot of stuff on the above skills but still need to learn more). This is what I want to perfect. I know ASP.NET quite well - well I know it well enough to find it easier to learn and understand. Do these courses help? I live in London so would like to do a proper course in London. Any recommendations or experiences I should know?

kiwisr

9,335 posts

238 months

Sunday 22nd July 2007
quotequote all
To be honest there isn't that much to learn about SQL Server.

tigger1

8,486 posts

252 months

Monday 23rd July 2007
quotequote all
I asked a similar question recently and didn't get any response - I think it's more acase of just "playing" with it.

slapmatt

1,132 posts

253 months

Monday 23rd July 2007
quotequote all
I used to work for a large IT training company, QA, and got to go on several of their courses. Whilst the courses are excellent, I'm not sure they are worth the money at up to a grand for five days.

What kind of things are up hoping to learn. Most courses start from scratch, so if you are currently working as a developer you are likely to find that you know alot of it.

From personal experience, I would much rather learn from online tutorials or colleagues than sit in a classroom.

Don

28,378 posts

315 months

Monday 23rd July 2007
quotequote all
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe

GnuBee

1,339 posts

246 months

Monday 23rd July 2007
quotequote all
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Hmm, not entirely sure that this is correct. Certainly in a production context with multiple database instances SQL Server in the enterprise is still not an install and forget product and to be fair probably never will be.

From the OP's question it would seem he's a developer and so I suspect his requirements with regards SQL Server are around things like data modeling, stored procedures, CLR integration in which case there's a lot to learn to do it well.

Judging by some of the tat that I've reviewed from "consultants" from a well known company who's name may or may not be somewhat similar to Accidenture there's a fairly poor grasp of even rudimentary database design practices.

sp60

524 posts

290 months

Monday 23rd July 2007
quotequote all
[quote=Z064life]
However, whenever I build a system there is also a need to stop and find out how to implement some sort of functionality. This is despite me reading books and practising tutorials, making my own stuff. I'm thinking about doing a course on what I want to improve on, to cure this problem. I want to be excellent at what I do (I.T.).
quote]

I've been doing development in C# since the beta days, forms ado, asp, pretty much all aspects. I've learned a lot, but still have to stop and find out how to implement new functionality as we do continually varied work. Unless you do the same thing all the time day in day out that functions the same, you are always going to come up against this 'problem'. It's one of the small things that makes this job enjoyable. I've worked with people of all ages and experiences and they all have to stop and find out how to do something from time to time. Once you understand the fundamentals of development, its as much a research job as anything else. What may help is if you are personally well organised and build up a collection of functions/routines/classes etc.. as you go. I wish i had done this along the way as my memory is rubbish!

Just as an aside, being good at I.T. is like saying I'm good at cars! If you want to be a developer in c# vb or whatever, then you will need to narrow your focus a bit. I'm not saying don't get good at other aspects of the I.T. industry, as it will always help, but you are never going to be able to be brilliant at all aspects as there is simply too much to learn and it's constantly moving.

Good luck and enjoy!

Don

28,378 posts

315 months

Monday 23rd July 2007
quotequote all
GnuBee said:
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Hmm, not entirely sure that this is correct. Certainly in a production context with multiple database instances SQL Server in the enterprise is still not an install and forget product and to be fair probably never will be.

From the OP's question it would seem he's a developer and so I suspect his requirements with regards SQL Server are around things like data modeling, stored procedures, CLR integration in which case there's a lot to learn to do it well.

Judging by some of the tat that I've reviewed from "consultants" from a well known company who's name may or may not be somewhat similar to Accidenture there's a fairly poor grasp of even rudimentary database design practices.
I'm a database systems specialist of many years and agree totally that the majority of database applications you see are fairly appalling. Mind you - the damn thing runs so fast these days that any lack of design for performance is fairly irrelevant.

We run an app that supports 4000 concurrent users every Friday afternoon (Timesheets!). Runs on just one big-iron SQL Server database system. No load balancing. No nothing. It just works. Fan-flippin-tastic in comparison to the dreadful tuning and fiddling you used to have to do...

ATG

23,877 posts

303 months

Monday 23rd July 2007
quotequote all
I'd echo the view that the courses tend to be fairly basic, short and expensive. That isn't to say they are worthless, far from it, but I'd only consider one if someone else was paying for it. You could buy a hell of a lot of books for the cost of a course.

mattley

3,039 posts

253 months

Monday 23rd July 2007
quotequote all
Z064life said:
However, whenever I build a system there is also a need to stop and find out how to implement some sort of functionality.
In programming terms you always will have. It's what makes it fun. I don't know what sort of projects you do, but you will always get that, and courses don't teach anything that helps as the client WILL find you something that wasn't on the course.

As mentioned above, there isn't too much to SQL, however knowing good SQL can save alot of programming. Also if you're in a MS SQL 2005 environment, there's a lot more to the product than just SQL, and that could well be money well spent.

The last thing I'd add is, don't do the course untill you need to use the material. A course in anything is money wasted if you don't get to use the material within a week or so.

kiwisr

9,335 posts

238 months

Monday 23rd July 2007
quotequote all
GnuBee said:
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Don said:
kiwisr said:
To be honest there isn't that much to learn about SQL Server.
Used to be that you had to know a world of utter poo in order to make the damn thing work. Now you install it, connect to it and forget it. Until you run out of disk space, of course.... hehe
Hmm, not entirely sure that this is correct. Certainly in a production context with multiple database instances SQL Server in the enterprise is still not an install and forget product and to be fair probably never will be.

From the OP's question it would seem he's a developer and so I suspect his requirements with regards SQL Server are around things like data modeling, stored procedures, CLR integration in which case there's a lot to learn to do it well.

Judging by some of the tat that I've reviewed from "consultants" from a well known company who's name may or may not be somewhat similar to Accidenture there's a fairly poor grasp of even rudimentary database design practices.
I started life as a DB designer having done several papers at university on the subject as part of a maths degree (Unsurprisingly relational databases can be described using mathematic formalae).

Try talking to 95% of database people about tuples, relations, set theory, logical schema design etc and their eyes start to glaze over.

There is certainly a lot more to learn if you are going to go into that sort of detail, but I think you'll find the courses that are on offer for 2-3-4 days on MS SQL Server are very basic indeed, and are aimed more at the vendors product and DBA style training.

It's definitely not just set and forget though, but may as well be with the general skill level of most people who install and maintain MS SQL (Oracle people tend to be a bit more switched on, but not by much)



Edited by kiwisr on Monday 23 July 23:49