Several chapters then explore key topics such as database programming, security, performance tuning, backup and recovery, data integration, and system monitoring. The text opens with information on the latest version of Microsoft SQL Server, offering step-by-step guidance on selecting an edition and completing initial installation and configuration. Ideal for formal courses, self-study, or professional reference, this detailed text employs a lab-based approach to help users develop the core knowledge and practical skills they need to master Microsoft SQL Server administration in an enterprise environment and pass Microsoft Certified Solutions Associate Exam 70-462. Professional Microsoft SQL Server 2012 Reporting Servicesīy: Paul Turley Robert M.MCSA GUIDE TO MICROSOFT® SQL SERVER® 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career success. Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Modelīy: Marco Russo, Alberto Ferrari, and Chris Webb SQL Server Analysis Services 2012 Cube Development Cookbookīy: Baya Dewald Paul Turley Steve Hughes I passed the 70-466 exam with the help of. However my reply maybe helpful for someone. Overall there is a lot to know for the exam: SSRS - both Native and Sharepoint mode, SSAS - both Multidimensional and Tabular, Data Warehouse architecture so I would suggest that anybody takes their time. Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide ( ) - This book is very abstract and will over prepare you for the performance based questions ![]() Just make sure to read it twice, since the material is difficult. Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model - I had no experience with the Tabular model prior to this book and even though DAX is extremely difficult to grasp compared to the Multidimensional Model and MDX, this book does a good job of guiding you through. ![]() ![]() Professional Microsoft SQL Server 2012 Reporting Services - very detailed book on SSRS (both Sharepoint and Native mode) Pro Sql Server 2012 BI Solutions - A very straight forward, step by step general overview of BI with SQL Server Microsoft SQL Server Analysis Services 2008 Step by Step Microsoft SQL Server 2008 MDX Step By Step Steve - The list in the link is a bit exhausting but I prepared with the following materials: I suspect that this is the reason why none of these training kits (464,465,466,467) have been published yet since they intend on updating the objectives and exam content in a few months. Also in March 2014, recertification options for maintaining the MCSE credentials will be made available.The exam numbers will remain the same.Īt least one month prior to the update, details on the original and revised exam objectives will be made available for review in the Skills measured section of each exam detail webpage. In March 2014, the MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams will be appropriately updated with SQL Server 2014 topics.No MCSA: SQL Server 2014 credential will be offered. The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without any alterations.As a result, the following updates are planned: The new product features focus on performance tuning and high availability and are best suited for the MCSE level. ![]() Q.How will the updates for SQL Server 2014 impact official Microsoft training and certifications?Ī.SQL Server 2014 certifications will only be offered at the MCSE level. From the Microsoft certification site ( ):
0 Comments
Leave a Reply. |