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




    5 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    This course teaches you to implement the enhancements and new features of SQL Server. Further, it enables you to use the SQL Server 2014 product and other Microsoft data platform components.

    Course Objective:

    On completion of this course, you will be able to learn and implement the following regarding SQL Server 2014

    • Describe its features and capabilities
    • Learn key elements of cloud solutions
    • Use Integration, data quality, and, master data services
    • Use in-memory database capabilities
    • Implement tabular data model in Analysis services
    • Implement Self-service BI solution
    • Execute SQL server database, big data solution with Microsoft Azure
    • Manage SQL Server 2012 and 2014
    • Implement security, high-availability, and data recovery techniques

    • Module 1: Introduction to SQL Server 2014
    • Module 2: What’s New in SQL Server Database Development
    • Module 3: In-Memory Database Capabilities
    • Module 4: Scripting SQL Server 2014
    • Module 5: Implementing Security in Microsoft SQL Server 2014
    • Module 6: High Availability and Data Recovery Enhancements
    • Module 7: New and Enhanced Features in SQL Server Integration Services
    • Module 8: Data Quality Services
    • Module 9: Master Data Services
    • Module 10: SQL Server 2014 Reporting Services
    • Module 11: Implementing an Analysis Services Tabular Data Model
    • Module 12: Self-Service BI with Microsoft Excel
    • Module 13: Introduction to Cloud Data Solutions
    • Module 14: Microsoft Azure SQL Database
    • Module 15: SQL Server in Microsoft Azure Virtual Machines
    • Module 16: Implementing Big Data Solutions

    • Database professionals
    • Business intelligence professionals

    The participants must have the experience as mentioned below

    • Create and manage

      • Database
      • Data warehouse
      • Business Intelligence solutions
    • Experience in
      • Windows Server operating system
      • Networking
      • Microsoft Server
      • Sharepoint Server

    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.