Updating Your SQL Server Skills to Microsoft SQL Server 2014

At Course Completion

• Describe key features and capabilities of SQL Server 2014.
• Leverage new and enhanced features to develop database in SQL Server 2014.
• Use in-memory database capabilities in SQL Server 2014.
• Manage SQL Server 2014 by using dynamic management views and PowerShell.
• Implement security in SQL Server 2014.
• Implement high-availability and data recovery techniques in SQL Server 2014.
• Use SQL Server 2014 Integration Services.
• Use SQL Server 2014 Data Quality Services.
• Use SQL Server 2014 Master Data Services.
• Manage SQL Server 2012 Agent and Jobs.
• Implement a tabular data model in SQL Server 2014 Analysis Services.
• Implement a Self-Service BI solution with Microsoft Excel 2013.
• Describe key elements of cloud solutions for data.
• Implement a database in Microsoft Azure SQL Database.
• Implement a SQL Server database in a Microsoft Azure virtual machine.
• Implement a Big Data solution with Microsoft Azure HDInsight and the Microsoft Azure Marketplace.

Course Requirements:

Students looking to take this course (10977) must already have the following technical knowledge:

• Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2008.
• Familiarity with the Windows Server 2012 operating system and networking.
• Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.