Exciting New Year Offer: Get upto 30% discounts on IT training or a chance to win iPhone XS or XR. Offer valid till Ends In:
Exciting New Year Offer: Get upto 30% discounts on IT training or a chance to win iPhone XS or XR. Offer valid till

10977: Updating Your SQL Server Skills to Microsoft SQL Server 2014

Key Features MONEY BACK GUARANTEE

How this works :

At Learnfly, we greatly value the trust of our patrons. Our courses are designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Instructor Led Training :

Raise refund request within 7 days of commencement of the first batch you are eligible to attend. Money back guarantee is void if the participant has accessed more than 25% content of an e-learning course or has attended Online Classrooms for more than 1 day.

  • Learn with practical projects and hands on real tools.
  • Official Curriculum & Courseware Content.
  • Online Interactive Lab's Access.
  • Adaptive e-Learning with trainer's support.
  • Access Class via PC, Mobile App or on a large screen.
  • Official Exam & Certification.
  • Attend Live HD Training Sessions via Go To MeetingTM. Interact with trainer and peers like in a real classroom via voice, video conference and live chat.

Course Description

About the Course

This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.

Objectives

  • 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 Windows Azure SQL Database.
  • Implement a SQL Server database in a Windows Azure virtual machine.
  • Implement a Big Data solution with Windows Azure HDInsight and the Windows Azure Marketplace.

Target Audience

  • The primary audience for this course is database and business intelligence (BI) professionals who are familiar with SQL Server 2008 and want to update their skills to SQL Server 2014, and become familiar with related Microsoft data technologies.

Prerequisites

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

Course Curriculum

Course # : 10977
Exam : Updating Your SQL Server Skills to Microsoft SQL Server 2014

Drop us a query

Our alumni’s are hired by top brands

Hundreds of employers — have maximized their talent with us.

Ready to enroll for this Course? Book your slot now: