Microsoft SQL Server 2014

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

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20461: Querying Microsoft SQL Server 2014

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 25,000 + Tax


20461: Querying Microsoft SQL Server 2014 Boot Camp

Course Outline

 
View
Duration: 30 Hours
Course Fee: INR. 25,000 + Tax


20462: Administering Microsoft SQL Server 2014 Databases

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20462: Administering Microsoft SQL Server 2014 Databases Boot Camp

Course Outline

 
View
Duration: 30 Hours
Course Fee: INR. 30,000 + Tax


20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 Boot Camp

Course Outline

 
View
Duration: 30 Hours
Course Fee: INR. 30,000 + Tax


20464: Developing Microsoft SQL Server Databases (SQL Server 2014 Update)

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20465C: Designing a Data Solution with Microsoft SQL Server (SQL Server 2014 Update)

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20466: Implementing Data Models and Reports with Microsoft SQL Server (SQL Server 2014 Update)

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


20467C: Designing Self-Service Business Intelligence and Big Data Solutions with SQL Server (SQL Server 2014 Update)

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 40,000 + Tax


Course 55144B: SQL Server 2014 Performance Tuning and Optimization

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 40,000 + Tax


MCSA: SQL Server (2014 Update) Boot Camp

Course Outline

 
View(20461)
View(20462)
View(20463)

Duration: 90 Hours
Course Fee: INR. 75,000 + Tax


MCSA: SQL Server (2014 Update) Combo

Course Outline

 
View(20461)
View(20462)
View(20463)

Duration: 120 Hours
Course Fee: INR. 1,00,000 + Tax


MCSE: SQL Server Business Intelligence (2014 Update) Combo

Course Outline

 
View(20466)
View(20467)

Duration: 80 Hours
Course Fee: INR. 60,000 + Tax


MCSE: SQL Server Data Platform (2014 Update) Combo

Course Outline

 
View(20464)
View(20465)

Duration: 80 Hours
Course Fee: INR. 50,000 + tax


Updating Your SQL Server 2008 Skills to Microsoft SQL Server 2014

Course Outline

 

  • Introduction to SQL Server 2014
    • Overview of SQL Server 2014
    • SQL Server 2014 Editions and Components
    • Installing SQL Server 2014
    • Enhancements to SQL Server Management Studio
  • What’s New in SQL Server Database Development
    • Transact-SQL Enhancements and Functions
    • Enhancements to Spatial Data Support
    • Storing and Querying Documents with SQL Server 2014
  • In-Memory Database Capabilities
    • The Buffer Pool Extension
    • Columnstore Indexes and Memory-Optimized Tables
  • Scripting SQL Server 2014
    • Dynamic Management Views
    • Manage SQL Server using PowerShell
  • Implementing Security in Microsoft SQL Server 2014
    • Security Management Enhancements
    • Contained Databases
  • High Availability and Data Recovery Enhancements
    • AlwaysOn High Availability
    • Enhancements to Data Recovery
  • New and Enhanced Features in SQL Server Integration Services
    • Use CDC Control Task for Incremental Data Loads
    • Deploy and Operate SSIS Packages
  • Data Quality Services
    • Introduction to Data Quality
    • Use Data Quality Services to Cleanse and Match Data
  • Master Data Services
    • Introduction to Master Data Services
    • Implement a Master Data Services Model
    • Use the Master Data Services Add-in for Excel
  • SQL Server 2014 Reporting Services
    • Reporting Services Overview
    • Reporting Services and Microsoft SharePoint Server
    • Introduction to Data Alerts
  • Implementing an Analysis Services Tabular Data Model
    • Introduction to Analysis Services Tabular Data Model Projects
    • Creating a Tabular Model
    • Use an Analysis Services Tabular Data Model in the Enterprise
  • Self-Service Business Intelligence (BI) with Microsoft Excel
    • PowerPivot for Excel and SharePoint Server
    • Power Query, Power View, and Power Map
    • Power BI for Office 365
  • Introduction to Cloud Data Solutions
    • Overview of Cloud Computing
    • Microsoft Azure Services for Data
  • Microsoft Azure SQL Database
    • Introduction to Microsoft Azure SQL Database
    • Microsoft Azure SQL Database Security
    • Implementing and Managing Databases
  • SQL Server in Microsoft Azure Virtual Machines
    • Introduction to Microsoft Azure Virtual Machines
    • Microsoft Azure Virtual Machine Connectivity and Security
    • Creating Databases in a Microsoft Azure Virtual Machine
  • Implementing Big Data Solutions
    • Introduction to Big Data
    • Microsoft Azure HDInsight
    • Consuming HDInsight Results in Excel
    • Obtaining Data from the Microsoft Azure Marketplace
  • Labs
    • Lab 1: Exploring SQL Server 2014
    • Reviewing Installed Components
    • Use SQL Server Management Studio
  • Lab 2: Develop SQL Server 2014 Databases
    • Use Sequence Objects
    • Use the THROW statement
    • Implement Paging and Query Documents
  • Lab 3: Use In-Memory Database Capabilities
    • Enable the Buffer Pool Extension
    • Create Columnstore Indexes and work with Memory-Optimized Tables
  • Lab 4: Manage SQL Server with Scripts
    • Use Dynamic Management Views and PowerShell
  • Lab 5: Implement Security
    • Implement User-Defined Server Roles and implement Contained Databases
  • Lab 6: Use AlwaysOn Availability Groups
    • Create and use an AlwaysOn Availability Group
    • Observe Availability Group Failover Behavior
  • Lab 7: Use SQL Server Integration Services
    • Extract Modified Data
    • Deploy and Operate an SSIS Project
  • Lab 8A: Cleansing Data
    • Create a DQS Knowledge Base
    • Use a DQS Project to Cleanse Data
    • Use DQS in an SSIS Package
  • Lab 8B: Deduplicating Data
    • Create a Matching Policy and use DQS Project to Match Data
  • Lab 9: Implement Master Data Services
    • Create a Basic Model
    • Edit a Model by Using the Master Data Services Add-in for Excel
    • Load Data into a Model, Enforce Business Rules, and Consume Master Data Services Data
  • Lab 10: Using SQL Server 2014 Reporting Services
    • View SharePoint Mode Configuration
    • Authoring, Publishing, and Viewing a Report
    • Create and Manage Data Alerts
  • Lab 11: Work with Analysis Services Tabular Data Model
    • Create an Analysis Services Tabular Data Model Project
    • Configure Columns and Relationships
    • Use Custom DAX Expressions
    • Deploy an Analysis Services Tabular Data Model
  • Lab 12: Self-Service BI with Excel
    • Create a Data Model with PowerPivot
    • Import Data with Power Query and Visualize Data with Power View
    • Visualize Geographic Data with Power Map
  • Lab 13: Use Microsoft Azure
    • Create a Microsoft Azure Storage Account
    • Back Up a Database to Microsoft Azure
    • Storing Data Files in Microsoft Azure

 
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax