+ Reply to Thread
Page 3 of 4 First 123 4 Last
Results 51 to 75 of 76

Thread: 70-461

  1. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #51
    SELECT P.*, D.*
    FROM PERSON AS P
    JOIN DOCUMENTS AS D
    ON D.PersonID = P.PersonID AND P.FIRSTNAME IN ('JOHN', 'MARK', 'DAVID')


    WITH CTE_TEST
    AS
    (

    SELECT *
    FROM PERSON
    WHERE FIRSTNAME IN ('JOHN', 'MARK', 'DAVID')

    );


    SELECT *
    FROM CTE_TEST AS T
    JOIN DOCUMENTS AS D
    ON D.PersonID = T.PersonID

    Any of these work for you?
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #52
    Hopefully my bad SQL didn't scare everyone off! Rest assured I am applying for a Senior Account Manager position. Strictly financially though.....
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #53
    haha na, It's a good query. I just didn't know that was possible when I first started learning SQL. CTEs and derived tables make things easier.

    I just got to Chapters 6 Querying Full Text and 7 Querying XML data. Ya'll weren't lying, these chapters are rough....I'm skipping them and coming back to them later.
    Reply With Quote Quote  

  5. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #54
    How XML heavy is the exam?
    Reply With Quote Quote  

  6. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,938

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #55
    I think there is about 5 or 6 XML questions...
    Never let your fear decide your fate....
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #56
    With two fails under my belt I agree with SoT. There is about 5 - 6 and both times I took the exam they were the first ones right out the gate. <Shakes head>
    Reply With Quote Quote  

  8. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,938

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #57
    Quote Originally Posted by DatabaseHead View Post
    With two fails under my belt I agree with SoT. There is about 5 - 6 and both times I took the exam they were the first ones right out the gate. <Shakes head>
    and talk about deer in the headlights look. LOL. I have failed 2X as well @Databasehead. We should form a club. kidding...
    Never let your fear decide your fate....
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #58
    I just wanted to get up and leave.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #59
    I've come to the conclusion that this exam is for developers not analyst like myself. I think I'm going to finally put my hopes of this certs to bed. I will still encourage and add to this thread. I like it....
    Reply With Quote Quote  

  11. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #60
    Do you think getting an MCSA would help me get a data analyst job? Trying to get out of help desk work...
    Reply With Quote Quote  

  12. Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    98

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #61
    I think MCSA (SQL Server) is useful in re-assuring people that you know at least some SQL Server stuff and can be trusted to some extent. Exam 461 gives broad coverage of hands-on SQL query writing. 462 covers hands-on DBA tasks, but also the design of high-availability configurations. 463 covers SSIS and data warehouse design (which I was surprised to find is quite different to the design of OLTP databases).

    I've recently found out that one of the (slightly paranoid) customers I work for won't let anyone without MS certification login to their SQL Server boxes. I think certifications can open doors in some circumstances.
    Reply With Quote Quote  

  13. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #62
    What Eager said is not what I have seen, not to say he or she is lying I just haven't seen it. I log into boxes all the time and develop code daily. I literally have BIDS (now called something Tools) and SSMS up all the time. If I am not working in SSAS tabular or with cubes I am updating data, creating views out of complex SQL or whatever..... I think for me it's a pride thing but hey I can't seem to pass the exam. But I can set up SSIS packages to use JSON to strip zipped files and have them load into our data warehouse. LOL
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #63
    @Daniel

    I work as a master data analyst and these are the skills I see for junior and even middle level positions.

    MS Access and Excel.
    Beginning level of statistics. Difference between mean and median, standard deviation, cross correlation, variance.
    Specific industry knowledge depending on what type of company you are working for. Health care, Finance etc.

    Nice to haves.

    VBA, you would be shocked but this has really made me shine. Most of the analyst can barely write macros I can build solutions and clean large ugly data sets with VBA, it really helps me stick out. In fact my last promotion was because of the VBA skills I would leverage all the time. I must of worked over 15 VBA projects in 2015 and I was promoted to senior. Just saying....

    Relational database and even more important data warehouses.

    Awesome to haves and things that get you paid.
    Strong understanding of SSAS and cube, tabular technology.
    Ability to build front end applications for ETL and data scrubbing.
    SSIS or Informatica or another ETL tool. We have guys in our company that make about as much as you can make in IT and all they do is set up ETL's, of course they are VERY complex.


    There are other things as well, but the most important thing is attitude. Be a team player and don't toss people under the best, no criticism it's garbage.

    My last note, before you even touch SQL you MUST know how to use Excel and VBA. Everything comes back to the lowest common demominator eventually. Excel formulas and clean up is huge. VBA is part of that. Again this is for a master data analyst position, which is pretty close to what you are looking at except a pure data analyst is going to be more into the statistic and data mining. Right now I do a lot of time series forecasting using ARIMA and ARTxp to trend volume and spend analysis.

    Clear as mud!? Hope this helps man.....
    Last edited by DatabaseHead; 06-14-2016 at 05:09 AM.
    Reply With Quote Quote  

  15. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #64
    Wow, thanks for the info.

    I have a lot to work on.

    I'm okay at excel...that's what I have been using to display data to clients but it's boring and hard to read.

    I recently discovered MS Power BI, seems kind of cool, but I still haven't figured out how to make good visual data.

    I'll have to definitely put some more time in Excel and VBA.
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #65
    Yeah for dashboarding using PowerBI is great, we use Tableau which I prefer but it cost. We also use SSRS and WEBI, so I don't want to take away from reporting dashboard tools they are all nice to have. But when it comes to ANALYSIS those tools only help summarize, you always end back up with Excel usually, unless you fully transitioned to R or SAS or something similiar.


    Just a heads up, there isn't one set way to do this, I just wanted to provide my insights.
    Last edited by DatabaseHead; 06-14-2016 at 04:57 PM.
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #66
    Quote Originally Posted by scaredoftests View Post
    and talk about deer in the headlights look. LOL. I have failed 2X as well @Databasehead. We should form a club. kidding...
    SOT - I had to follow up with this. I'm still laughing every time I read it. I seriously just wanted to get up and leave.

    I'm sitting there click next and guess what's next, another XML question. After 6 of those, I rolled into a challenging merge questions I had no idea about. At that point I just wanted to start guessing.
    Reply With Quote Quote  

  18. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #67
    okay okay okay

    I opened up the training guide just a second ago and I am starting with chapter 7, yes chapter 7. Querying and Managing XML Data. I'm going to stay on this for at least 2 weeks. Why I do this to myself is beyond me.
    Reply With Quote Quote  

  19. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #68
    Thoughts on the way the XML alias are set up after using namespaces? [co:Customer] for instance. Kind of wonky if you ask me.....
    Reply With Quote Quote  

  20. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #69
    I just read the chapter on Clustered Indexes...man, I had to watch some videos to wrap my head around it. It's starting to make sense now haha..
    Reply With Quote Quote  

  21. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,938

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #70
    Quote Originally Posted by DatabaseHead View Post
    okay okay okay

    I opened up the training guide just a second ago and I am starting with chapter 7, yes chapter 7. Querying and Managing XML Data. I'm going to stay on this for at least 2 weeks. Why I do this to myself is beyond me.
    Same here @Databasehead LOL
    Never let your fear decide your fate....
    Reply With Quote Quote  

  22. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #71
    I gotta ask how did you progress?
    Reply With Quote Quote  

  23. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,938

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #72
    Progress in studying, you mean? I am now actually passing (mostly) in transcender tests. Still reading etc.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  24. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #73
    Well that's encouraging. I am currently working through some Lynda certificates that are free from my alma mater. Currently I am in need of ramping up on some machine learning techniques for a project I am working on. Volume and Spend analysis.

    Just when you gain traction something else comes up.
    Reply With Quote Quote  

  25. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #74
    So my boss asked me to create some dynamic reports using Excel. I have created the queries and established the connection to excel but for the life of me I cannot figure out how to parameterize the report to where the user can filter by date. I figured out how to add in a calendar to insert a date into a cell but I dint know how to pass the value of that cell into the query
    Reply With Quote Quote  

  26. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,337

    Certifications
    CISSP
    #75
    Quote Originally Posted by daniel108 View Post
    Do you work as a SQL developer?

    I'm hoping to be able to make the jump from help desk to a DBA type position in a year or so. Not sure if you have any advice.

    I'm starting off with this certification and building my own databases.

    At work, I look for opportunities to write custom reports for our clients to practice joins, declaring variables, subqueries, etc.

    My manager even proposed that we add one of my reports as a supplement to our application for our clients.

    Sorry I missed this question (New Username). I did previously a lot of SQL Dev and DBA work. I think you are on the right track with the other opportunities you look for at work and 70-461 is a great way to advertise those skills. If you have other questions, feel free to message me.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

+ Reply to Thread
Page 3 of 4 First 123 4 Last

Social Networking & Bookmarks