Sql

[Miss Wiggle]

I'm really excited (because I'm incredibly sad) just had my 6 monthly performance review at work adn we were talking about my training needs, got them persuaded to send me on a course to learn SQL script. It's the first 'advanced' IT thing I've ever done, quite nervous about it!

Any of you lot use it? Is it easy to learn? I'm v computer literate but I've never done anything more advanced than your standard user packages.

 

[jimw13uk]

If you are talking about SQL Server - Use it every day - its very powerful.
Very easy to pick up the simple things like "Select * from tablename" - but then you can do so much more complex things like Joins and Cursors etc.

Its a good thing to have on your CV as well as theres lots of work in SQL Server

 

[Miss Wiggle]

If you are talking about SQL Server - Use it every day - its very powerful.
Very easy to pick up the simple things like "Select * from tablename" - but then you can do so much more complex things like Joins and Cursors etc.

Its a good thing to have on your CV as well as theres lots of work in SQL Server

mmm i do some basics, our main database that all project and staffing info for our department is an SQL one, I've done some basic report design and stuff like that which is just the select* tablename type stuff, but I'm talking really basic stuff here.

We've a big modification to the database coming out that I have to be in charge of, lots of software development and my boss wants me to be able to be deeply involved in that not just basic stuff for using it. If that makes sense!?!

I think it'd be really good to go on my CV, I work in Quality Management at the moment, starting to move across to a more Project Management based roll and I think to show that I can at least learn IT stuff to this level will look excellent on my CV even if jobs I go for aren't specifically using SQL.

 

[jimw13uk]

Are you using SQL Server 2005 yet then - cos that is a massiv eleap forward and makes life sooooooo much easier in building Stored Procedures.
If its "old" sql server then its a bit of a pain in the backside cos its very "buggy".

I use it all day long and its a great tool but you have to get used to the in-built quirks that it has (in the old version - we havent upgraded yet)

 

[Miss Wiggle]

not got a clue to be completely honest!

I really don't know much about all this, just been told that I need to learn. It's good though, I'm really feeling like I need a challenge at the moment and this is miles away from anything I've done before.

 

[smurfyy_2k3]

well this is the main stuff you should learn miss w

http/www.w3schools.com/sql/default.asp

thats a great web language site btw

 

[kewskills]

..

 

[Miss Wiggle]

well this is the main stuff you should learn miss w

http/www.w3schools.com/sql/default.asp

thats a great web language site btw

bookmarked that to have a proper look at later, thanks. sounds like the right thing, the database i need it for is an oracle one.

sql scripting can be as easy or hard as you want it to be, im a mcdba and some of the stuff can confuse me still, if you need any help i may be able to help.

whats an mcdba when it's at home! lol

thanks though, much appreciated

 

[kewskills]

..

 

[Miss Wiggle]

mcdba = "microsoft certified database administrator"
thats what i do for a job, design,implement and administer enterprise sql databases.
yes its boring but you gotta earn a living.

aaahhhhh

not half as boring as what i do (you can tell by how much of my working life is spent on this forum ) so don't worry

 

[Squid]

mcdba = "microsoft certified database administrator"
thats what i do for a job, design,implement and administer enterprise sql databases.
yes its boring but you gotta earn a living.

I have worked for Oracle on a Marketing student placement, and then worked for Informix for over 4 years as a pre-sales engineer....

Oracle won the marketing war, but Informix is a fave for some DBAs....


Wiggle.. is it just sql they want you to know, ir is it the whole DBA stuff.

Squid

 

[Miss Wiggle]

what's DBA?

(can you tell i've never done anything like this before)

feel like i'm learning already

 

[jimw13uk]

DBA - DataBase Administrator/Administration

 

[Squid]

what's DBA?

(can you tell i've never done anything like this before)

feel like i'm learning already

Database Administrator..

as kewskills said, he is a microsoft certified DBA mcdba, and so will be certified for MS SQL server product family. Not up to date myself, but prior to some technology specific Extended SQL, there used to be standard relational database SQL such as SQL92 (old now). So that part of the skill set is relatively transferable between database vendors, as is most of the knowledge of how they roughly work. But each database vendor such as Oracle has some specifics for how the manage the DB. tablespaces, blobspaces etc....

 

[Miss Wiggle]

Just SQL for now, it's specifically for one project (although we're talking big 18 month minimum type project) relating to an SQL database, we do a soft of software trialing for the company who make it and my boss wants me to be able to work with it a bit rather than having to go back to them for every little thing that we want to do.

My jobs not IT based so it's unlikely that I'd go further than that into other sorts of databases or anything like that, however I think it'll look really good on my CV to show that I can learn IT stuff to this sort of level