+ Reply to Thread
Page 1 of 4 1 234 Last
Results 1 to 25 of 90
  1. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #1

    Default MCSE - Business Intelligence Thread

    A little background.

    Failed 70-461 2 times already however I strictly went with the book the first 2 times, not a good idea, at least for me.

    See below my history so far on studying for the 3rd time.

    I am using CBT Nuggets and the book, more Nuggets.

    I've been back at it for 3 days and I am through chapter 5, not all chapters align with the training kit, but I look at the training kit more as a knowledge filler. Hopefully I can deliver the full MCSE BI. I am feeling it this time and have full buy in from my family.

    I'll keep this thread updated and I will bring home a passing score for 70-461.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #2
    Went through some additional training through the virtual lab, I prefer my production SQL client at work or my home express version, but the scripts are set up and can be very convenient especially through the chapters that are more review.

    The virtual lab screen is relatively small and the performance was very slow tonight. Still I learned a lot going over all the constraints. I find that this additional knowledge can further bring me along in my journey.

    Next up is Triggers, not very useful, but part of the exam so I'll go through the lesson plan and review the training kit if time permits.
    Last edited by DatabaseHead; 07-15-2016 at 06:42 AM.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #3
    Right now my approach is going to be 70-461 then 70-463 then 70-462. The reason for this strategy is due to my work experience.

    I would really like to do 466 next because that is where I am at right now, but........ For the sake of getting the MCSA first I will go with the original plan. Now on to work and studying.
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #4
    Completed CBT Nugget chapter 5 Triggers, nested, recursive, update, delete, insert. Everything you want to know about triggers and then some, even shared a script sending out an email utilizing the SP_Configured Stored Proc to email users when tables have been modified. This is a new concept to me so it was a good learning nugget. Normally I would use SSIS to do these sorts of things, but it's still cool to know.

    Next up Querying Data using SELECT (59 min)


    And

    Implementing Subqueries (34 min)

    And

    Implementing Data Types (40 min)



    3 listed above are next, I won't be labbing those, just watching the videos. After those 3 then comes the XML and I will be spending quite a bit of time on that. If I remember correctly, both of my fails had 7 XML questions.

    Overall I like the Nuggets but 84 dollars a month is a lot so.......... I'm not sure I endorse it fully. I am going to keep it until I take the 70-461 exam. If I pass then it will make a believer out of me and I'll roll into 463.
    Last edited by DatabaseHead; 07-18-2016 at 02:39 AM.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #5
    Just finished up Querying Data Using Select. Most of this was an overview but did go over some really interesting tips and tricks using the case statement, such as in the order by etc. It went over some windowing functions, rank over and row number. It was a useful nugget.

    Next up will be another review subqueries and data types. Plan is to plow through those two tomorrow and then spend a few days working through the XML and then eventually finishing out the training. I'll be scheduling my test for 461 in the next week or so.

    Still plan on skipping 462 and moving onto 463 once I pass this exam.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #6
    Finished up sub queries, just discovered the 1.5x speed option, not sure why I just discovered this..... This module covered Pivot, Unpivot CTE's and Sub queries. It was a good refresher but mostly review, ~90% review. Plan on banging out Implementing Data Types tonight when I get home and then tomorrow spending ~ a week on XML. I really have to spend a lot of time on this module. I plan on reading the training kit as well in down times covering XML.

    My free trial ends today and so i'll be on an 84 USD re occuring charge until I pass. I'll be able to use their practice test once the trial ends so I am looking forward to that. I'll post again once I complete the next module.

    So far I give the training a B, it's much better than the Lynda.com one.
    Reply With Quote Quote  

  8. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #7
    You seem to be making good progress. I need to complete my MCSE Data Platform so your in progress review of the CBT nuggets material is helpful.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #8
    Yeah man - Keep at it love that another person is going through this trial with me. It's not easy, if anyone could do it everyone would have the certification and not many do.

    Thanks for chiming in I appreciate it.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #9
    Just completed implementing data types, used some work time to power through. Fairly informative, I'll lab a little bit for the data types I am not familiar with, such as spatial queries and the variant. I am going to review the aggregation module next getting close to to finishing up, lesson 10 out of 20 so.......

    Hopefully I'll have one more post before I am done for the night.

    I ended up getting through 10 minutes before burning out, heading home to get something to eat and run. Once things settle down I'll get back on and finish up this module, ~30 minutes left but I plan on running through the lab to hone my skills a bit.

    I'm putting in quite a bit of effort hopefully this time I get a pass.
    Last edited by DatabaseHead; 07-19-2016 at 11:46 PM.
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #10
    Just completed advanced aggregates, covering grouping sets, group by, windowing and spatial aggregation. ~45 minutes, it was very informative, I learned a lot from this nugget. I plan on moving into XML next, I am going to review the book now (throughout today) and then move on to the CBT nugget. Pace is the name of the game now, I don't want to burn out. I'll take it slow this next chapter via book and cbt nugget.
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #11
    Made it through half the XML nugget. Brutal, elements and attributes! I'm going to the chiro and then exercising hopefully I'll have time to get on this. Painful.........

    I'm going to do it but painful.....
    Reply With Quote Quote  

  13. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #12
    Tried to get through it tonight after some sprints at the track. Brutal, got back and just didn't have it. Oh well always tomorrow :/
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #13
    Pass or Fail I am learning a little bit here and there from viewing the material, which directly helps me with my job. Just saying
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #14
    Took the weekend off, beginning to review the XML training module on the CBT Nugget series. On this particular chapter I am taking detailed notes, very detailed. I will follow up once I complete this lesson today. I will continue to review for the next couple of days though before moving on to Stored Procedures.
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #15
    Completed XML - CBT Nuggets

    Went over a lot of material in 45 minutes

    XML RAW, AUTO, Root, Elements, Name Spaces, Attributes, Indexs, Primary, Secondary, XML Schema Collections, BCP and OpenXml and With OPENROWSET.

    I'm going to continue to read the Murach SQL Server book in regards to XML. I gotta keep at this for a while. I am of the belief if I can master the XML component and review the ALL, Ranking etc I will pass this exam.
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #16
    Completed Stored Procedures.

    This was a really good nugget, very informative. Covered all the basics, inputs, outputs and data layer S procs. Most of this I learned in school and on the job, but the instructor did uncover some neat coding techniques when working with branching logic. Overall a good module, probably better for real world issues than the exam.
    Reply With Quote Quote  

  18. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #17
    I'm going to have to check out this training. It sounds very good.
    Reply With Quote Quote  

  19. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #18
    So far so good..... I am hoping this training does the trick.
    Reply With Quote Quote  

  20. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #19
    Quote Originally Posted by DatabaseHead View Post
    Pass or Fail I am learning a little bit here and there from viewing the material, which directly helps me with my job. Just saying
    That's how I am with the 70-458 exam I take on Sunday (the day it expires), if I pass, I have my MCSA. If I fail, I will have had a 5 day crash course on Data Warehousing.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  21. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #20
    Sounds like a plan! Honestly any of this stuff isn't worth much unless you have real world experience. That's why I am so reluctant to take 462 when it comes time. 463 is in my wheelhouse, but we shall see how far I get with 461.
    Reply With Quote Quote  

  22. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #21
    Just completed Modifying Data with T-SQL, Nugget # 13 out of 20. Took the day off to get some stuff done and thought I would utilize a work free morning (usually NEVER the case) to get one completed, depending how I feel I may roll into # 14 Combine Data Sets. It's only 22 minutes ( the shortest of the nuggets) and with the 1.6x speed turned on 13.75 minutes.........


    Lot's of good real world examples in this. TBH I feel like this training is better for real world than the exam. I'll refocus on triggers and XML once I complete all nuggets. I remember both of those being on the exam so...... Def need to know your triggers and XML.
    Reply With Quote Quote  

  23. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #22
    Completed (Joining Datasets) Nugget 15 out of 20

    Covered Union, Union All, Intersect, Except and Merge.

    Union and Union All was review, Union is distinct whereas All is All, pretty easy to remember. Intersect and Except is easy as well. I did like when the instructor used an intersect/except in the IN statement on a subquery.

    IN ( SELECT EmployeeID FROM Employees
    Except
    SELECT EmployeeID from Sales
    )

    The Merge statement is extremely powerful and useful. Love being able to insert, update and delete using WITH statements like an a Case. Also learned about using $action, to show in OUTPUT your action that occurred. I believe you can alias it if you would like.
    Reply With Quote Quote  

  24. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #23
    Plan today is to review the XML section in the training guide. Get used to reviewing the elements/tagging and other components of XML documents. Focusing on the output piece now, Auto, Path, Raw. The next video is ~45 minutes so that will have to wait unless for some crazy reason I can free up some bandwidth at work.
    Reply With Quote Quote  

  25. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #24
    Tried getting through the functions tonight. ROUGH...... Just nothing there for me never used one may never use one. I may skip this nugget and roll onto another. I want this to be enjoyable and that wasn't at all....... Got about 15 minutes through a 45 minute nugget. Wow rough!
    Reply With Quote Quote  

  26. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #25
    Completed Nugget ~18 skipped over a few, this one was ~22 minutes long. This one went over Cursors, UDF's and the difference between Row and Set theory. It was fairly light although some of the scripting was a tad bit daunting, especially if you never used it before, but the instructor covered it well. I may grab one more training session before I head out. Currently smoking a brisket which takes a long time so this frees up some Saturday bandwidth.
    Reply With Quote Quote  

+ Reply to Thread
Page 1 of 4 1 234 Last

Social Networking & Bookmarks