Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
MJP
Jun 17, 2007

Are you looking at me Senpai?

Grimey Drawer

"[oMa posted:

Whackster" post="411306767"]
I did the 40-417 last week, which is basically 3 mini-exams of 410, 411 and 412. It was reasonably straightforward; my best tip is make sure you know how to do all the routine server role/feature installation on a core installation. I'd recommend looking at the jumpstart guides from Microsoft itself as there's some excellent stuff on there. The 2-day 70-417 jumpstart course in particular is really good and will give you a great overview of what's required for all three exams. It was a live event, but it's now streamable on demand after registering.

Sorry but do you mean "core installation" as in Server Core, or was it just on a basic install as in "here's a server, install 2k12 on it"? They still test on that?

Christ, there's lots of useful stuff that I covered on the MCITP 2k8 certs I took but Server Core was the least useful, and that's saying a lot given how much the MS exams expect you to know.

Adbot
ADBOT LOVES YOU

Nebulis01
Dec 30, 2003
Technical Support Ninny

MJP posted:

Sorry but do you mean "core installation" as in Server Core, or was it just on a basic install as in "here's a server, install 2k12 on it"? They still test on that?

Christ, there's lots of useful stuff that I covered on the MCITP 2k8 certs I took but Server Core was the least useful, and that's saying a lot given how much the MS exams expect you to know.

I passed 70-417 on Friday, he means Server Core. You should also know the PoSH cmdlets for AD administration (group policy especially), and the proper places to manage a Windows Server Cluster and its settings.

1000101
May 14, 2003

BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY FRUITCAKE!
Took TSHOOT under pressure from the network practice manager and passed it. I scored pretty high. After preparing for SWITCH and ROUTE this test was kind of a fun walk through the park.

duck hunt
Dec 22, 2010

MJP posted:

Sorry but do you mean "core installation" as in Server Core, or was it just on a basic install as in "here's a server, install 2k12 on it"? They still test on that?

Christ, there's lots of useful stuff that I covered on the MCITP 2k8 certs I took but Server Core was the least useful, and that's saying a lot given how much the MS exams expect you to know.

There were some changes with 2012 with regard to Server core. Honestly, most of it has stayed the same. Server core questions for 2012 are a lot like they were in 2008r2. I think now that you don't have to enable remote management in sconfig (the cli interface for setting up server core instanaces). I could be wrong here.

vty
Nov 8, 2007

oh dott, oh dott!
Anybody using any sort of online course/learning site (coursesites, something like Khan) to plan out their studies/labs? While I do my VCP5 and CCIE I was hoping to set up something so other people can go through them (vids, lab setups, etc). Mostly to motivate myself to actually study and lab various stuff, but also so other people could contribute, have discussions, etc.

Not to mention one of my real goals is getting into more of an advisory/teaching arena (currently IT manager, etc). I'd really, really love to take the generic "bootcamp" style of training and give it a real-world spin which most bootcamps seem to seriously lack, or they're just prohibitvely expensive.

Most of what I've seen are simple Wordpress blogs, or Forums.. which I don't really think are the most conducive to what I'm after.

vty fucked around with this message at 07:48 on Feb 5, 2013

1000101
May 14, 2003

BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY FRUITCAKE!

vty posted:

Anybody using any sort of online course/learning site (coursesites, something like Khan) to plan out their studies/labs? While I do my VCP5 and CCIE I was hoping to set up something so other people can go through them (vids, lab setups, etc). Mostly to motivate myself to actually study and lab various stuff, but also so other people could contribute, have discussions, etc.

Not to mention one of my real goals is getting into more of an advisory/teaching arena (currently IT manager, etc). I'd really, really love to take the generic "bootcamp" style of training and give it a real-world spin which most bootcamps seem to seriously lack, or they're just prohibitvely expensive.

Most of what I've seen are simple Wordpress blogs, or Forums.. which I don't really think are the most conducive to what I'm after.

I can't think of anything off the top of my head. I know blog.ine.com recently laid out an 18 month learning plan to become a voice CCIE.

That said I'd definitely set milestones for yourself that are achievable in smaller pieces. I was given the opportunity to pursue a CCIE data center on someone else's dime about 6 months ago. I told the people who offered it that it would take me 18 months and then I sat down and figured out how that was going to play out.

It basically went something like this:

Re-certify CCNA
CCNP Switch
CCNP Route
CCNP Tshoot

DCUFI (Nexus/unified fabric)
ICSNS (whatever cisco's network cert is)

That's where I'm at today having completed all of the above. Now I'm going to go deeper and prepare for the CCIE written and then pound for the lab. Yeah you can actually start with the CCIE if you want but I probably wouldn't. I found that going through each step of the CCNP and other tests were very helpful in building confidence and filling in gaps in my knowledge. After going through that process I can generally predict behavior much better now when you hand me a switch configuration and overall I'm a much better network engineer than I was 8 months ago.

I find that saying "my goal is a CCIE" does a LOT to kill any motivation you may have because it's so far down the road you may feel like you'll never be ready for it. Then you're always "currently pursuing a CCIE" while making no real progress. You'll end up doing a weekend every month or so trying to get back on track but you'll never full commit.

On the VCP5 there are dozens of resources out there as it's not too involved. Take 1 class and pass 1 test and you're golden.

vty
Nov 8, 2007

oh dott, oh dott!
I feel ya. I'm actually already a VCPdv4/MCITP/CCNP/blahblah. I'm more or less trying to figure out a teaching tool. Essentialy what INE does, I'd like to be able to go to my employees and say "Hey, if you want your CCNP, I did it last year, made a curriculum to follow that includes labs and videos.. have at it."

I've realized over the years that I learn FAR, FAR more whilst teaching others than I do sitting down with a book and a lab.

I setup a Coursesite (free version of Blackboard) but then I realized I know absolutely nothing about making curriculums and the minutiae involved.

1000101 posted:

I can't think of anything off the top of my head. I know blog.ine.com recently laid out an 18 month learning plan to become a voice CCIE.

That said I'd definitely set milestones for yourself that are achievable in smaller pieces. I was given the opportunity to pursue a CCIE data center on someone else's dime about 6 months ago. I told the people who offered it that it would take me 18 months and then I sat down and figured out how that was going to play out.

It basically went something like this:

Re-certify CCNA
CCNP Switch
CCNP Route
CCNP Tshoot

DCUFI (Nexus/unified fabric)
ICSNS (whatever cisco's network cert is)

That's where I'm at today having completed all of the above. Now I'm going to go deeper and prepare for the CCIE written and then pound for the lab. Yeah you can actually start with the CCIE if you want but I probably wouldn't. I found that going through each step of the CCNP and other tests were very helpful in building confidence and filling in gaps in my knowledge. After going through that process I can generally predict behavior much better now when you hand me a switch configuration and overall I'm a much better network engineer than I was 8 months ago.

I find that saying "my goal is a CCIE" does a LOT to kill any motivation you may have because it's so far down the road you may feel like you'll never be ready for it. Then you're always "currently pursuing a CCIE" while making no real progress. You'll end up doing a weekend every month or so trying to get back on track but you'll never full commit.

On the VCP5 there are dozens of resources out there as it's not too involved. Take 1 class and pass 1 test and you're golden.

skipdogg
Nov 29, 2004
Resident SRT-4 Expert

Check out Moodle, it's a popular free Learning Management System.

wheez the roux
Aug 2, 2004
THEY SHOULD'VE GIVEN IT TO LYNCH

Death to the Seahawks. Death to Seahawks posters.

skipdogg posted:

Check out Moodle, it's a popular free Learning Management System.

The ForLang department at my university used it, and it's super intuitive. Students, professors, and techs all loved it. Especially compared to the total loving piece of poo poo trash that is Blackboard. gently caress Blackboard forever.

trotski
Mar 26, 2009
Anyone have experience with VTC: http://www.vtc.com/products/Red-Hat-Certified-System-Administrator-RHCSA-Tutorials.htm

$30 isn't bad, but I was wondering about the quality. I'm starting to study for the RHCSA.

duck hunt
Dec 22, 2010
Any Juniper goons in this thread? I have my JNCIS-FWV and JNCIS-SEC. Apparently I have to re-certify this year. I found out that Juniper now does their exams through Pearson as opposed to Prometric. Anyone taken any of the newer Juniper exams?

ApocalypseMeow
Mar 4, 2008

I love the smell of Catnip in the morning....Smells like Victory.
Passed my 70-410 exam on saturday morning. There were surprisingly fewer PowerShell related questions than I was expecting but I'm still glad I studied up on that anyway.

Now I can relax a bit before 411 and 412 as the books aren't even available to buy yet :downs:

trunkwontopen
Apr 7, 2007
I am a CARTOON BEAR!

duck hunt posted:

Any Juniper goons in this thread? I have my JNCIS-FWV and JNCIS-SEC. Apparently I have to re-certify this year. I found out that Juniper now does their exams through Pearson as opposed to Prometric. Anyone taken any of the newer Juniper exams?

I was interested in taking this at my old job, but it would be worthless now at my current job (we do not use Juniper), but from what I understand, the newer exams as of about 1-2 years ago, all it takes is basic networking experience, and some memorization from PDF documents freely found on the Juniper website. At least, this was the case for JNCIA.

Jelmylicious
Dec 6, 2007
Buy Dr. Quack's miracle juice! Now with patented H-twenty!
The jncia is the ccent or ccna of juniper, and yes: it truely was that easy. I should hope that the harder ones are actually harder.
If I recall correctly, the exams used to be both pearson vue and prometric. They just dropped the one. The exams should stil feel the same.

vty
Nov 8, 2007

oh dott, oh dott!

trotski posted:

Anyone have experience with VTC: http://www.vtc.com/products/Red-Hat-Certified-System-Administrator-RHCSA-Tutorials.htm

$30 isn't bad, but I was wondering about the quality. I'm starting to study for the RHCSA.

I just checked out one of the free videos, the guy is reading from a script or something. I absolutely hate his style. When you watch INE videos, etc, they're more like a conversation with personality. I don't want somebody to read the book to me with a video, I want you to tell me what the gently caress and why the gently caress. The books usually contain 20% of the information you really need to know in the real world.

For example; https://www.youtube.com/watch?v=4VRuLPIp06A

vty fucked around with this message at 18:53 on Feb 6, 2013

duck hunt
Dec 22, 2010
JNCIA is the first Juniper cert you get. It is the per-requisite to all other certification tracks. That is to say, for you to have your specialist or pro level credential in a track, you have to have the JNCIA. It is a basic test of the JunOS operating system. It also has very basic routing, firewall, and switching questions on it. Nothing that you couldn't pass if you already have CCNA and have some experience working with unix or FreeBSD (JunOS runs on FreeBSD). There also are a lot of great free stuff that you can study right from Juniper.net

Juniper's specialist and pro test are very difficult. I failed the JNCIS-SEC the first time around. It is a good mix of looking at outputs, logs, knowledge questions, and commands. JNCIS-SEC covers most of the SRX platform. I also have the older JNCIS-FVW which is Juniper's specialist test for the ScreenOS firewalls. Very different (ealrier) OS. FVW covers the SSG series platforms.

The thing I like about Juniper's certs are that there are much much fewer of them. Seems like there is a literal zoo of Cisco certs out there. Juniper's cert tracks are also nice and tidy. A lot of the time it is just taking 3 or 4 exams and you are done. The path from JNCIA to JNCIE, which there aren't JNCIE exams for all the tracks yet, is brutal. I feel, personal opinion, like Juniper test are also better than Cisco test. The questions are worded better, and there is more variety.

Frag Viper
May 20, 2001

Fuck that shit
IPv6 question.

When shortening an IPv6 address, specifically one containing a string of zeroes it says you can use a pair of colons to represent a string of consecutive groups with a value of zero.

For example
2001:0:0:3210:800:200C:CF:1234 becomes 2001::3210:800:200C:CF:1234

I get how that works in the instance above.

But when its 3 consecutive number sets is where i'm having an issue.

Example 2
FEDC:0000:0000:0000:00CF:0000:BA98:1234 gets shortened to FEDC::CF:0:BA98:1234

In this case, what happens to the third set of zeroes? It looks like it just skipped it and went to the next group (CF). Shouldn't the leading zeroes be dropped and that's it? Why is this third group completely missing? This book doesn't say why.

Frag Viper fucked around with this message at 08:22 on Feb 7, 2013

MC Fruit Stripe
Nov 26, 2002

around and around we go
The :0: indicates that there is a group of zeroes there. The :: indicates that, when all is said and done, put as many sets of zeroes in as you'd need to flesh out the address.

So aaaa::ffff would be aaaa:0000:0000:0000:0000:0000:0000:ffff

You'd never have two sets of :: because it would blow your mind.

aaaa::cccc:0:ffff -> aaaa:0000:000:0000:0000:cccc:0000:ffff

Don't know if that makes a lick of sense.

I think you're thinking of consecutive as "two consecutive", that distinction might be your mental block.

e: Put another way, consecutive is as many as you want. Your loopback address is ::1. 0000:0000:0000:0000:0000:0000:0000:0001.

MC Fruit Stripe fucked around with this message at 08:27 on Feb 7, 2013

1000101
May 14, 2003

BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY BIRTHDAY FRUITCAKE!

Frag Viper posted:

IPv6 question.

When shortening an IPv6 address, specifically one containing a string of zeroes it says you can use a pair of colons to represent a string of consecutive groups with a value of zero.

For example
2001:0:0:3210:800:200C:CF:1234 becomes 2001::3210:800:200C:CF:1234

I get how that works in the instance above.

But when its 3 consecutive number sets is where i'm having an issue.

Example 2
FEDC:0000:0000:0000:00CF:0000:BA98:1234 gets shortened to FEDC::CF:0:BA98:1234

In this case, what happens to the third set of zeroes? It looks like it just skipped it and went to the next group (CF). Shouldn't the leading zeroes be dropped and that's it? Why is this third group completely missing? This book doesn't say why.

Taking a stab after MC:

You can take a large string of contiguous zeroes and replace them exactly once with ::.

You can also just omit leading zeroes in an IPV6 address.

That said this:

FEDC:0000:0000:0000:00CF:0000:BA98:1234

Can be represented all of these ways:
FEDC::00CF:0000:BA98:1234
FEDC::CF:0:BA98:1234
FEDC:0:0:0:CF::BA98:1234
FEDC:0:0:0:CF:0:BA98:1234

When you do :: it assumes all zeroes between two different groups.

I'm tired and sort of split focused but I hope between these two responses you can make sense of it.

Jelmylicious
Dec 6, 2007
Buy Dr. Quack's miracle juice! Now with patented H-twenty!
Don't forget that you can only use :: once in an address.

2001:0000:0000:b00b:0000:0000:0000:0a55 should be shortened to 2001:0:0:b00b::a55. If you would do 2001::b00b::a55, it could also mean (for instance) 2001:0:0:0:0:0b00b:0:a55. Rule is: do it once, do the longest consecutive 0's as ::, and use :0: for the others. If there is a tie in 0-length, than I believe you should do the first string.

Recreating an address is easy. You know the length of every IPv6 address: 128 bits, or 8 "octets" (should that be hexidecitets?). So, ::1 will expand to 8 octets long, 0's are only abbreviated from the start of an octet. Let's start with making 8 octets: 0:0:0:0:0:0:0:1. Now, lets perpend the 0's to make each octet 4 digits wide: 0000:0000:0000:0000:0000:0000:0000:0001

e:

1000101 posted:

FEDC:0000:0000:0000:00CF:0000:BA98:1234

Can be represented all of these ways:
FEDC::00CF:0000:BA98:1234
FEDC::CF:0:BA98:1234
FEDC:0:0:0:CF::BA98:1234
FEDC:0:0:0:CF:0:BA98:1234
Except that only a few are according to the conventions, so you should only use:
FEDC:0000:0000:0000:00CF:0000:BA98:1234 or FEDC::CF:0:BA98:1234
If you abbreviate, abbreviate fully, or don't do it at all. Otherwise you will just cause confusion. The other versions are just intermediate steps for abbreviations.

Jelmylicious fucked around with this message at 09:02 on Feb 7, 2013

Frag Viper
May 20, 2001

Fuck that shit

MC Fruit Stripe posted:

The :0: indicates that there is a group of zeroes there. The :: indicates that, when all is said and done, put as many sets of zeroes in as you'd need to flesh out the address.

So aaaa::ffff would be aaaa:0000:0000:0000:0000:0000:0000:ffff

You'd never have two sets of :: because it would blow your mind.

aaaa::cccc:0:ffff -> aaaa:0000:000:0000:0000:cccc:0000:ffff

Don't know if that makes a lick of sense.

I think you're thinking of consecutive as "two consecutive", that distinction might be your mental block.

e: Put another way, consecutive is as many as you want. Your loopback address is ::1. 0000:0000:0000:0000:0000:0000:0000:0001.

It makes perfect sense, thanks for clearing it up.

This book never said that :: could represent as many zeroes (in this case 0000:0000:0000) that I needed to finish out the address. It was just like "put these fuckers here to represent strings". I do know that you cant use a second set of :: because then you'd never know how many sets were in each group.

So far IPv6 isn't as bad as I thought it was going to be.

Edit:
Thanks for the additional comments

CrazyLittle
Sep 11, 2001





Clapping Larry

Jelmylicious posted:

If there is a tie in 0-length, than I believe you should do the first string.

Yes, because you're referencing the network number and then the device's individual address.

hayden.
Sep 11, 2007

here's a goat on a pig or something
Can someone explain the difference between these two?

Database Certification: 11g Certified Database Administrators
(http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:Datab11g)

and

Oracle Certified Associate, MySQL 5
(http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:MYSQL5)

I don't work in IT right now but I'm sort of looking into shifting my career towards there. I'm a data analyst right now and use SQL a lot. I've reading through the threads here on SA to figure out which type of IT role would fit me best, so I don't really know where to start.

vty
Nov 8, 2007

oh dott, oh dott!
That's.. easy. One is Oracle 11g and one is MySQL. Completely different database systems (gently caress Oracle, but it's the one that will get you a high paying lovely analyst job at every govt/defense contractor).

On the flip side, every neckbeard who has ever run a website knows mysql.

hayden. posted:

Can someone explain the difference between these two?

Database Certification: 11g Certified Database Administrators
(http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:Datab11g)

and

Oracle Certified Associate, MySQL 5
(http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:MYSQL5)

I don't work in IT right now but I'm sort of looking into shifting my career towards there. I'm a data analyst right now and use SQL a lot. I've reading through the threads here on SA to figure out which type of IT role would fit me best, so I don't really know where to start.

hayden.
Sep 11, 2007

here's a goat on a pig or something
Thanks for that, I blame being really tired today. Considering my current job doesn't use MySQL and I'm pretty familiar with what appears to be a lot of the subject matter, and my current job also doesn't use Oracle and I don't know if a future one will, should I focus on CCNA or maybe MSCA instead? I was hoping to find something a little related to my current job tasks, which I guess the MSCA for SQL Server would, so maybe I should try that.

hayden. fucked around with this message at 05:22 on Feb 8, 2013

MrKatharsis
Nov 29, 2003

feel the bern
What database system does your company use? If you're a data analyst, you may want to check into a Microsoft reporting/BI cert as a bridge into a more techy role. You should consider yourself lucky that you're not shoehorned into an Oracle track. Their tests are maddening.

hayden.
Sep 11, 2007

here's a goat on a pig or something
Just edited my reply before your post. They use Microsoft stuff. BI looks like it'd be pretty applicable to my current job, but I also want something to make me easily employable in the future as well and I don't know if business intelligence will be anywhere as common as regular sys admin stuff.

edit: looks like BI is just the SQL Server certification with two extra exams on top, so I guess I'd have both if I did BI. Neat.

hayden. fucked around with this message at 05:27 on Feb 8, 2013

MrKatharsis
Nov 29, 2003

feel the bern
Where I live, there are literally hundreds of job postings for analysts with SQL Server Reporting Services skills. The MS business intel certs appear to have a fair amount of DBA type knowledge required anyway:
http://www.microsoft.com/learning/en/us/sql-certification.aspx

If you're looking for a sysadmin job, CCNA and Red Hat will get you there. You may need a lateral transfer to tech support to get your foot in the door though.

Graves
Feb 10, 2002

Ask me about the time I posted a thread in GBS with a full confession on how I stabbed a man to death with my pocket knife

MrKatharsis posted:

How did you find OCA? I'm thinking about taking it soon.

Honestly, they're a little "gotcha" oriented. The querying test is a pain in the rear end, as it is pretty pedantic and a race against time. They are testing things that you don't really need to know in the real world, like memorizing function syntax. The admin test has a lot of questions that are basically written to trick you. Don't get me wrong, if you know the material you will pass it, but they're fairly frustrating tests.

hayden.
Sep 11, 2007

here's a goat on a pig or something

MrKatharsis posted:

Where I live, there are literally hundreds of job postings for analysts with SQL Server Reporting Services skills. The MS business intel certs appear to have a fair amount of DBA type knowledge required anyway:
http://www.microsoft.com/learning/en/us/sql-certification.aspx

If you're looking for a sysadmin job, CCNA and Red Hat will get you there. You may need a lateral transfer to tech support to get your foot in the door though.

I hope I manage a lateral transition because help desk work would be a pretty big demotion in pay and responsibilities from my current position. I'm trying to get into something more IT related since the only upward mobility I have from an analyst position would be staying at one place long enough to make it into upper management and as soon as I start somewhere new I'm back to the bottom. I don't really know where I'm going with this and it's sort of off topic. Thanks for the feedback!

Graves
Feb 10, 2002

Ask me about the time I posted a thread in GBS with a full confession on how I stabbed a man to death with my pocket knife

hayden. posted:

Thanks for that, I blame being really tired today. Considering my current job doesn't use MySQL and I'm pretty familiar with what appears to be a lot of the subject matter, and my current job also doesn't use Oracle and I don't know if a future one will, should I focus on CCNA or maybe MSCA instead? I was hoping to find something a little related to my current job tasks, which I guess the MSCA for SQL Server would, so maybe I should try that.

Just going to reply to your last few posts in general. I work as a DBA, previously in Oracle and currently in SQL Server. People give Oracle a lot of poo poo, mostly because they don't understand it. They think because they know a smaller scale system like MySQL or SQL Server they'll be able to function in it, and that is just not anywhere near the case. Oracle is the Unix of the RDBMS world. Most people don't know how to use it, it's overly complicated and difficult to learn, but once you know it it is the most powerful system in its category.

That being said, you really shouldn't try to jump into the RDBMS world with Oracle, because it really is harder to learn and use, there's not much of a community around it, the company itself is awful and, as stated, the tests are a bitch. The jobs also tend to sort of suck. They pay more, but the environment will be either government (which I personally hate working for) or some other equally soul-crushing mega-corporation.

On a more general level, if you don't work in IT, and never have, transitioning from being a data analyst to a DBA isn't really viable. You'll need a lot of steps in between. Generally, there are two groups of people who become DBAs: developer and experienced sys admins. You need to understand hardware, the OS and a decent bit of development practices to be a good DBA - probably also web applications/servers and network infrastructure to a lesser degree, depending on what you're doing. If you're lucky, you can train under a senior DBA after putting in some time as a sys admin.

I don't mean to discourage you, I would actually say if you're interested you should really go after it. It's a great career and extremely rewarding and interesting work. Just be aware it's not something you can read a couple of books, pass a test or two, and be ready to do. Feel free to PM me if you feel like it.

hayden.
Sep 11, 2007

here's a goat on a pig or something
Thanks for the detailed response, I really do appreciate it. Got an email I can use instead since I don't have PMs (or you can just email me if you don't want to post it here: haydendotsa@gmail.com)?

It is a little discouraging since I had the impression (obviously incorrect) that a DBA would be an easier and more entry level position than a sys admin, but I'll take it private with you since that isn't really what this thread is about.

hayden. fucked around with this message at 06:02 on Feb 8, 2013

Graves
Feb 10, 2002

Ask me about the time I posted a thread in GBS with a full confession on how I stabbed a man to death with my pocket knife

hayden. posted:

Thanks for the detailed response, I really do appreciate it. Got an email I can use instead since I don't have PMs (or you can just email me if you don't want to post it here: haydendotsa@gmail.com).

It is a little discouraging since I had the impression (obviously incorrect) that a DBA would be an easier and more entry level position than a sys admin, but I'll take it private with you since that isn't really what this thread is about.

Sure thing, hit me up at Graves138 at gmail dot com

vty
Nov 8, 2007

oh dott, oh dott!
Yep. I know mssql, postgres, and mysql like the back of my hand, and I'll never forget the first time I had to do an Oracle migration.

Good god. It was like trying to work on a Chinese system when I only knew English. All of the names, configuration, everything was completely different.

Graves posted:

Just going to reply to your last few posts in general. I work as a DBA, previously in Oracle and currently in SQL Server. People give Oracle a lot of poo poo, mostly because they don't understand it. They think because they know a smaller scale system like MySQL or SQL Server they'll be able to function in it, and that is just not anywhere near the case. Oracle is the Unix of the RDBMS world. Most people don't know how to use it, it's overly complicated and difficult to learn, but once you know it it is the most powerful system in its category.

That being said, you really shouldn't try to jump into the RDBMS world with Oracle, because it really is harder to learn and use, there's not much of a community around it, the company itself is awful and, as stated, the tests are a bitch. The jobs also tend to sort of suck. They pay more, but the environment will be either government (which I personally hate working for) or some other equally soul-crushing mega-corporation.

On a more general level, if you don't work in IT, and never have, transitioning from being a data analyst to a DBA isn't really viable. You'll need a lot of steps in between. Generally, there are two groups of people who become DBAs: developer and experienced sys admins. You need to understand hardware, the OS and a decent bit of development practices to be a good DBA - probably also web applications/servers and network infrastructure to a lesser degree, depending on what you're doing. If you're lucky, you can train under a senior DBA after putting in some time as a sys admin.

I don't mean to discourage you, I would actually say if you're interested you should really go after it. It's a great career and extremely rewarding and interesting work. Just be aware it's not something you can read a couple of books, pass a test or two, and be ready to do. Feel free to PM me if you feel like it.

keseph
Oct 21, 2010

beep bawk boop bawk

hayden. posted:

Just edited my reply before your post. They use Microsoft stuff. BI looks like it'd be pretty applicable to my current job, but I also want something to make me easily employable in the future as well and I don't know if business intelligence will be anywhere as common as regular sys admin stuff.

edit: looks like BI is just the SQL Server certification with two extra exams on top, so I guess I'd have both if I did BI. Neat.

DBA is the more established role, but MS has been pushing extremely hard on their BI stack and the industry for it is growing pretty quickly. Both types have a high reliance on domain knowledge, as Graves noted, but BI's is about the business and you'll spend a lot more time talking to management types and app developers than a strict (non-Application) DBA would.

Internet Explorer
Jun 1, 2005





Just as a counter-point, my fiance moved from paralegal to BI/entry-level DBA fairly easily. She has decent computer knowledge, but I would have in no way categorized her as "IT". She started off assisting IT with a case management software rollout, acting as the liaison between the legal side and the tech side. They liked her so much they brought her in to do the training and admining for the case management software. From there it was an easy transition into BI reports. From there she was exposed to the DBA side of things. Now she is branching out to do BI/DBA for other apps.

vty
Nov 8, 2007

oh dott, oh dott!

Internet Explorer posted:

Just as a counter-point, my fiance moved from paralegal to BI/entry-level DBA fairly easily. She has decent computer knowledge, but I would have in no way categorized her as "IT". She started off assisting IT with a case management software rollout, acting as the liaison between the legal side and the tech side. They liked her so much they brought her in to do the training and admining for the case management software. From there it was an easy transition into BI reports. From there she was exposed to the DBA side of things. Now she is branching out to do BI/DBA for other apps.

I would consider very few "DBAs" to be "IT" people. They're typically data analysts with some a compsci/math degree who talk about Latex constantly.

It's like programmers as well, I typically work with huge groups of programmers and they are some of the least computer/network savvy people I've ever met. It's all about specialization with these groups, which I rather miss.

Graves above mentioned that a big portion of them are ex-advanced sysadmins. I think most advanced sysadmins run screaming from that job.

Gucci Loafers
May 20, 2006

Ask yourself, do you really want to talk to pair of really nice gaudy shoes?


What the hell is business intelligence exactly?

GOOCHY
Sep 17, 2003

In an interstellar burst I'm back to save the universe!

Tab8715 posted:

What the hell is business intelligence exactly?

Knowing how to take it in the rear end from a C-level with a smile. :downsrim:

Adbot
ADBOT LOVES YOU

keseph
Oct 21, 2010

beep bawk boop bawk

Tab8715 posted:

What the hell is business intelligence exactly?

MS provides a sample DB based on a theoretical bicycle sales company, so you'll see examples couched in that framework. Such as: how much of a particular bicycle did you sell in 2012 by region/gender/etc. You would use that to answer questions like: Were your advertising dollars worth it (did revenue go up enough compared to previous year), how many units should you stock in the warehouse/store shelves (because there's a lead time on mfr), are certain products selling much better in the B&M vs the website. Knowing what questions make sense is the business part, working the data analysis tools is the intelligence part. There's also a lot of admin knowledge that goes into administering things like the SSRS service, the SSIS packages, the MDM store, etc, even if you never write a report.

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply