+ Reply to Thread
Results 1 to 14 of 14
  1. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #1

    Default Going for the MCSE: Data Management and Analytics

    Hello All,

    Currently I have passed the exams: Microsoft 70-620, 70-642, 70-640, 70-462. I want to hold MCSE: Data Management and Analytics for a year.

    I'm starting to prepare for the exam 70-461: Querying Microsoft SQL Server 2012/2014 or 70-761 Querying Data with Transact-SQL and 70-762 Developing SQL Databases.

    I use offical traing kit for 70-461 exam. I was reading chapter 1, 2, 3, 4, 5, 6, 7 8. I need to go back to XML and Full Text Search, especially Semantic Search Functions. So far, I was install SQL Server 2014 SP2 on Windows 8.1 64-bit and I create test database from the script attach to the 70-461 Traing Kit.

    I was starting to prepare two month ago, but I broke off because of private issues and workload. I went back to study this week. I feel the topic is demanding. The biggest progress I make during weekends. In this weekend I read full "Chapter 8 Creating Tables and Enforcing Data Integrity".

    I try to test the solutions presented in the book in a practical way. For example, I processing data from XML file using OPENXML for import data about blocked prescriptions numbers from an XML file into a database and then display the content of the selected node of XML file.

    I make a notes into file at Google Docs. This is my first topic of this type. I will try to update it 2-3 times a month. If I understand correctly, for achieve MCSE: Data Management and Analytics just pass the exams:
    - First way: MCSA: SQL Server 2012/2014 (70-461, 70-462, 70-463) and 70-473, 70-475, 70-464, 70-465, 70-466 or 70-467 exams.
    - Second way: MCSA: SQL 2016 Database Development (70-761/70-762) and 70-473, 70-475, 70-464, 70-465, 70-466 or 70-467 exams.

    Sombody currently preparing for 70-461, 70-761 or 70-762 exams? What materials do you use?
    Reply With Quote Quote  

  2. SS -->
  3. Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    97

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #2
    I'm aiming for MCSE: Data Management and Analytics as well.

    I already have MCSA: SQL Server 2012/2014, which involved passing 70-461. I thought it was one of the easier MS exams, the MS "Training Kit" book covered it quite well. I probably benefitted from having about 20 years general SQL Server experience, which helped guide my guesses when I hadn't studied a topic enough. I found it easier (and more job-relevant) than 462 or 463.

    I've just ordered the MS book for 70-762. That exam looks like a real bargain for me. If I pass it, I will get both MCSA: SQL Server 2016 and MCSE: Data Management and Analytics.

    Also, I think MS have just expanded the list of electives for the MCSE, which is nice:
    https://buildazure.com/2017/02/14/mc...certification/
    Last edited by EagerDinosaur; 07-08-2017 at 05:25 PM.
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #3
    From end of June, I was read over 200 pages of 70-461 training kit. There are 130 pages left, I will probably read them within 2 weeks. Sometimes it is difficult to find time to study in the day after work. Sometimes they are topics over which I spend more time than I would like.
    I make notes in the form of short (1-2 minutes) video recordings and blog notes. Also I make notes in google docs. In the coming months I will probably publish these notes in an orderly form.
    Recently I was read and I labbing topics such as:
    • Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms
    • Chapter 10 Inserting, Updating, and Deleting Data
    • Chapter 11 Other Data Modification Aspects
    • Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL
    Today I have day off and I read about stored procedures and triggers.
    After finishing the book we will all practice again. I have no memory for the code. I have heard that on the exam It is important knowledge of syntax. I have an idea for a database for exercises and some tasks. If you have any ideas for exercises - let me know.

    @EagerDinosaur: thans for you answer. When you plan to pass 70-762?
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,560

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #4
    Glad those days are over. 461 was rough.
    Position: Data Junky
    Reformed Cert Addict.
    Reply With Quote Quote  

  6. Senior Member aaronchristenson's Avatar
    Join Date
    Nov 2003
    Posts
    252

    Certifications
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+
    #5
    70-464 Developing Microsoft SQL Server Databases is next on my list of exams to take. I am taking the 5 day course from New Horizons in a few weeks. We had some training vouchers at work that were about to expire so I signed up to use them. This will complete the MCSE Data Management & Analytics.
    Aaron
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+, Virtualization with Windows Server Hyper-V and System Center Specialist
    Reply With Quote Quote  

  7. Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    97

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #6
    Quote Originally Posted by adam9870 View Post
    @EagerDinosaur: thans for you answer. When you plan to pass 70-762?
    I passed it about a week ago, MS confirmed the MCSE about 24 hours later. 762 seemed difficult while I was taking it, but I think the scoring criteria must have been fairly generous. It was quite interesting, lots of questions about what kind of index to choose for a particular business scenario. It covers some of the same data-warehouse design issues that 70-463 covers.
    Reply With Quote Quote  

  8. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #7
    I just finished reading chapter 15 of 70-461 trainig kit (about topics such as indexes, statistics etc.)
    Currently I do not feel the indexes are my strength. As for me, this is poorly explained in the book.
    I watched a webcast about indexes, I have to sit down to him again after when I finish the book.

    @aaronchristenson: Please let me know how it went after the exam. It may interest not only me.

    @EagerDinosaur: What materials to use to prepare for 70-463? The training kit does not have good ratings on the internet. Or on what topics to focus on? On the forum someone recommended this book
    https://www.amazon.com/Microsoft-Ser.../dp/0470525762
    what do You think about it?
    What plans after passing the MCSE?
    Reply With Quote Quote  

  9. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #8
    Today I'm done 70-461 Training Kit.
    Now it's time to repeat the material, sample tasks etc.
    I plan to take the exam 17 October. (Orientation)
    Reply With Quote Quote  

  10. 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
    #9
    Good luck with your studying!
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    May 2016
    Posts
    1,560

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #10
    Adam good luck on your goals. Stay calm and cool and let the information that you have learned come to the fore front of your mind. You'll do fine....
    Position: Data Junky
    Reformed Cert Addict.
    Reply With Quote Quote  

  12. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #11
    @nachodba / @ DatabaseHead - Thanks.

    I spent the weekend reading Microsoft Docs about XML in SQL Server, including FOR XML AUTO, FOR XML RAW, FOR XML PATH.

    I heard that in the book (Training Kit 70-461) this topic is very modest compared to what is on the exam.

    I like the most FOR XML PATH because it gives you the greatest control of XML structure. In work I prepare XML fileaccording to the guidelines of another system to which my XML file will be imported.

    In my plans I have to try to generate XML according to what I see everyday in the work to exchange data with national health fund.

    I also found a record of a video session about XML in SQL Server from the TechEd conference.
    Reply With Quote Quote  

  13. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #12
    Interesing artice

    Data type precedence (Transact-SQL)
    https://docs.microsoft.com/en-us/sql...e-transact-sql
    Last edited by adam9870; 09-16-2017 at 05:56 PM.
    Reply With Quote Quote  

  14. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #13
    Example: how store binary data in the database (for example: .DOC file)

    Code:
    CREATE TABLE [dbo].[doc]
    (
    id int identity(1,1) not null,
    "file" varbinary(max),
    fileextension nvarchar (10),
    filename nvarchar(255),
    title nvarchar(255)
    )
    Code:
    INSERT INTO [dbo].[doc]
    (fileextension,
    filename,
    title,
    "file"
    )
    SELECT 
    N'doc',
    N'test1.doc',
    N'Lewis Hamilton wins in Singapore after Ferrari crash',
    bulkcolumn
    FROM OPENROWSET(BULK 'C:\test\test1.doc',
    SINGLE_BLOB) AS doc;
    Reply With Quote Quote  

  15. Junior Member
    Join Date
    Jul 2016
    Posts
    24

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #14
    I am playing with Full-Text-Search.
    It is very important to write queries in practice, create tables, keys, consider what columns and data types to create, how to insert long text into columns, how to insert text with an apostrophe in the middle etc.
    Recently I use FTS to see if the comments are positive or negative.
    I continue to work...
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks