Anyone here have a job which involves a lot of SQL Commands?

grandmaster · 18 Oct 2011 at 20:00

I wanna chat with some people about jobs that use SQL and the ways in which you use it etc.

Well thats it really, like, if you work for said company, what do you with SQL? What kind of commands do you use and what for?

Not creating databases - I dont wanna know about that just yet.
Existing DB only.

grandmaster · 18 Oct 2011 at 20:03

Yea it does!
Is this in the industry?
Or at uni?

grandmaster · 18 Oct 2011 at 20:20

Thats fantastic!
Congrats on being in the industry for so long :-)

Im looking for someone on an advisory basis to be honest.

I wanna get into a role that involves SQL. In a junior role.
I'd like to know how SQL is used on a day to day basis.
So like, what would a company have you do?

I probably sound retarded lol

EDIT - You couldnt use SELECT??
When you say logical deletion what do you mean?
Why wouldnt they allow you to do so?

Any work in SQL welcome! Even MSQL Server!

grandmaster · 18 Oct 2011 at 20:40

Ive got a book to be honest and im working through it.
i aced it in Uni back in the day som im quite alright with the commands IE following the book.

In terms of careers - a lot of companies are starting to use Microsoft SQL Server so i wanna learn the commands atleast and then mess with MSSQL Server.

Im more curious or anxious about how a company wuld use your skills within their industry.

grandmaster · 18 Oct 2011 at 20:45

scorza said:
No we couldn't DELETE (normally) as we had to preserve the data for good reasons (which I can't explain now ). To logically delete we'd UPDATE the rows, which had columns called From Transaction ID and To Transaction ID. Anything with a non-null To Transaction ID was logically deleted. The From Transaction ID got populated when the row was created.

Edit: just remembered, my job was more Pro*C than PL/SQL lol.

So my job was firstly to learn how the database was supposed to work - what tables were available, what data they contained, how the transaction based architecture was supposed to be used. Then I had to take a detailed design document, or a module specification, and write a package or executable for that module spec, then test it and fix any defects.

We still do plenty of work of this type and constantly require junior people to do it. However these days it's very competitive - best way of doing it is to get a good maths based degree from a decent university (personally I think this makes a lot of our junior people overqualified but hey ho - they need to get experience). There's plenty of competition from Indian developers too

Do i need maths? Lol!
What math based queries will i do?
Im way past the degree stage! Been there done that.
Just never used SQL although i loved it back in Uni..wanna get back into it!

Oh yes - Indian developers are KILLING IT!
These guys know the whole framework at such a young age (ASP,SQL,C# VB Etc)

grandmaster · 18 Oct 2011 at 20:55

Co like from below, how far would a junior role go lol? (Am i being stupid)

Change
List
Append
input
And
Or
Between

Left join
Right Join
Substr
Instr

Triggers?

grandmaster · 18 Oct 2011 at 20:56

kkelly said:
@grandmaster, what do you work as now?

You should also look at Vendor SQL Certification's if you want to start building you CV, assuming you have little or no industry experience.

Anyway good luck

Trying to get in an IT related role to be honest. I was working in since Uni and worked for this company after that for another 6 years until redundancy - But it wasnt anything IT related. :-(

They wont even accept me for 1st Line LOL even though for this company i worked in their Broadband sector for quite some while - Although that differs from the 1st Line a company would want (Active Directory Etc)

Im studying SQL in my own time while im at home instead of watching TV for hours lol

grandmaster · 18 Oct 2011 at 20:57

By the way i appreciate your patience and advice thus far....All of you.

grandmaster · 18 Oct 2011 at 21:00

Haircut said:
A lot of Indian developers have lots of buzzwords on their CVs and claim to know it all, but when actually given a problem to solve will struggle with it.
If you can apply your knowledge and think for yourself then you'll stand above a lot of them.

As for SQL, I've worked with Oracle, SQL Server, Sybase, DB2 and MySQL at various points over my career.
Once you get your head round thinking of data in terms of sets and operations on those sets you shouldn't have any issues with SQL.
Personally I find most database stuff boring these days and try to steer clear of it if I can help it.

I know DB can be veeeery boring lol but sometimes boring is good and im a boring guy to be honest lol

What kind of roles do you enjoy?