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?