Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Upgrading Your SQL Server Skills to Microsoft SQL Server 2014
 Upgrading Your SQL Server Skills to Microsoft SQL Server 2014
 

10977: UPGRADING SQL SKILLS TO SQL SERVER 2014

The best source of Microsoft Certification Training Courses

A hands-on five-day course with free pre-course online skills testing
See Our Latest Reviews on TrustPilot:
COURSE OUTLINE

Full details of modules and topics covered in this five-day course

VERSIONS COVERED

This course covers 2014 versions

DURATION

This is a five-day training course structured into 32 modules

COURSE AIMS

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.

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.
Before attending this course, students must have:

  • 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.

AUTHORISED MICROSOFT TRAINING COURSE

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.


COURSE OBJECTIVES

Delegates will learn how to:

  • 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.


Want to see prices and options for delivery of your training?

MODULE 1:  Introduction to SQL Server 2014
Topics covered:
  • Overview of SQL Server 2014
  • SQL Server 2014 Editions and Components
  • Installing SQL Server 2014
  • Enhancements to SQL Server Management Studio
MODULE 2:  Lab : Exploring SQL Server 2014
Topics covered:
  • Reviewing Installed Components
  • Using SQL Server Management Studio
MODULE 3:  What's New in SQL Server Database Development
Topics covered:
  • Transact-SQL Enhancements
  • New and Enhanced Transact-SQL Functions
  • Enhancements to Spatial Data Support
  • Storing and Querying Documents with SQL Server 2014
MODULE 4:  Lab : Developing SQL Server 2014 Databases
Topics covered:
  • Using Sequence Objects
  • Using the THROW statement
  • Implementing Paging
  • Querying Documents
MODULE 5:  In-Memory Database Capabilities
Topics covered:
  • The Buffer pool Extension
  • Columnstore Indexes
  • Memory-Optimized Tables
MODULE 6:  Lab : Using In-Memory Database Capabilities
Topics covered:
  • Enabling the Buffer Pool Extension
  • Creating Columnstore Indexes
  • Working with Memory-Optimized Tables
MODULE 7:  Scripting SQL Server 2014
Topics covered:
  • Using PowerShell to Manage SQL Server
MODULE 8:  Lab : Managing SQL Server with Scripts
Topics covered:
  • Using PowerShell
  • Security Management Enhancements
  • Contained Databases
MODULE 9:  Lab : Implementing Security
MODULE 10:  High Availability and Data Recovery Enhancements
Topics covered:
  • AlwaysOn High Availability
  • Enhancements to Data Recovery
MODULE 11:  Lab : Using AlwaysOn Availability Groups
Topics covered:
  • Creating an AlwaysOn Availability Group
  • Using an AlwaysOn Availability Group
  • Observing Availability Group Failover Behavior
MODULE 12:  New and Enhanced Features in SQL Server Integration Services
Topics covered:
  • Using the CDC Control Task for Incremental Data Loads
  • Deploying and Operating SSIS Packages
MODULE 13:  Lab : Using SQL Server Integration Services
Topics covered:
  • Extracting Modified Data
  • Deploying and Operating an SSIS Project
MODULE 14:  Data Quality Services
Topics covered:
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
MODULE 15:  Lab : Cleansing Data
Topics covered:
  • Creating a DQS Knowledge Base
  • Using a DQS Project to Cleanse Data
  • Using DQS in an SSIS Package
MODULE 16:  Lab : Deduplicating Data
Topics covered:
  • Creating a Matching Policy
  • Using a DQS Project to Match Data
MODULE 17:  Master Data Services
Topics covered:
  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Using the Master Data Services Add-in for Excel
MODULE 18:  Lab : Implementing Master Data Services
Topics covered:
  • Creating a Basic Model
  • Editing a model by Using the Master Data Services Add-in for Excel
  • Loading Data into a Model
  • Enforcing Business Rules
  • Consuming Master Data Services Data
MODULE 19:  SQL Server 2014 Reporting Services
Topics covered:
  • Reporting Services Overview
  • Reporting Services and Microsoft SharePoint Server
  • Introduction to Data Alerts
MODULE 20:  Lab : Using SQL Server 2014 Reporting Services
Topics covered:
  • Viewing SharePoint Mode Configuration
  • Authoring, Publishing, and Viewing a Report
  • Creating and Managing Data Alerts
MODULE 21:  Implementing an Analysis Services Tabular Data Model
Topics covered:
  • Introduction to Analysis Services Tabular Data Model Projects
  • Creating a Tabular Model
  • Using an Analysis Services Tabular Data Model in the Enterprise
MODULE 22:  Lab : Working with an Analysis Services Tabular Data Model
Topics covered:
  • Creating an Analysis Services Tabular Data Model Project
  • Configuring Columns and Relationships
  • Using Custom DAX Expressions
  • Deploying an Analysis Services Tabular Data Model
MODULE 23:  Self-Service BI with Microsoft Excel
Topics covered:
  • PowerPivot for Excel
  • PowerPivot for SharePoint Server
  • Power Query
  • Power View
  • Power Map
  • Power BI for Office 365
MODULE 24:  Lab : Self-Service BI with Excel
Topics covered:
  • Creating a Data Model with PowerPivot
  • Importing Data with Power Query
  • Visualizing Data with Power View
  • Visualizing Geographic Data with Power Map
MODULE 25:  Introduction to Cloud Data Solutions
Topics covered:
  • Overview of Cloud Computing
  • Windows Azure Services for Data
MODULE 26:  Lab : Using Windows Azure
Topics covered:
  • Creating a Windows Azure Storage Account
  • Backing Up a Database to Windows Azure
MODULE 27:  Windows Azure SQL Database
Topics covered:
  • Introduction to Windows Azure SQL Database
  • Windows Azure SQL Database Security
  • Implementing and Managing Databases
MODULE 28:  Lab : Using Windows Azure SQL Database
Topics covered:
  • Provisioning Windows Azure SQL Database
  • Configuring Windows Azure SQL Database Security
  • Migrating a SQL Server Database to Windows Azure SQL Database
MODULE 29:  SQL Server in Windows Azure Virtual Machines
Topics covered:
  • Introduction to Windows Azure Virtual Machines
  • Windows Azure Virtual Machine Connectivity and Security
  • Creating Databases in a Windows Azure Virtual Machine
MODULE 30:  Lab : Using Windows Azure Virtual Machines
Topics covered:
  • Creating a Windows Azure Virtual Machine
  • Configuring Virtual Machine Security and Connectivity
  • Creating Databases on a Virtual Machine
MODULE 31:  Implementing Big Data Solutions
Topics covered:
  • Introduction to Big Data
  • Windows Azure HDInsight
  • Consuming HDInsight Results in Excel
  • Obtaining Data from the Windows Azure Marketplace
MODULE 32:  Lab : Creating a Big Data Solution
Topics covered:
  • Provisioning an HDInsight Cluster
  • Processing Data with HDInsight
  • Analyzing Big Data in Excel
  • Obtaining Data from the Windows Azure Marketplace

Want to see prices and options for delivery of your training?

RELATED COURSES

Analysing Data With SQL Server Reporting

COURSE OUTLINE
[Duration: five day]

Analysing Data With SQL Server Reporting

    20461: Querying Microsoft SQL Server 2014

    COURSE OUTLINE
    [Duration: five day]

    20461: Querying Microsoft SQL Server 2014

    • Introduction to Microsoft SQL Server 2014
    • Lab : Working with SQL Server 2014 Tools
    • Introduction to T-SQL Querying
    • Lab : Introduction to Transact-SQL Querying
    • Writing SELECT Queries
    • Lab : Writing Basic SELECT Statements
    • Querying Multiple Tables
    • Lab : Querying Multiple Tables
    • Sorting and Filtering Data
    • Lab : Sorting and Filtering Data
    • Working with SQL Server 2014 Data Types
    • Lab : Working with SQL Server 2014 Data Types
    • Using DML to Modify Data
    • Lab : Using DML to Modify Data
    • Using Built-In Functions
    • Lab : Using Built-In Functions
    • Grouping and Aggregating Data
    • Lab : Grouping and Aggregating Data
    • Using Subqueries
    • Lab : Using Subqueries
    • Using Table Expressions
    • Lab : Using Table Expressions
    • Using Set Operators
    • Lab : Using Set Operators
    • Using Window Ranking, Offset, and Aggregate Functions
    • Lab : Using Window Ranking, Offset and Aggregate Functions
    • Pivoting and Grouping Sets
    • Lab : Pivoting and Grouping Sets
    • Executing Stored Procedures
    • Lab : Executing Stored Procedures
    • Programming with T-SQL
    • Lab : Programming with T-SQL
    • Implementing Error Handling
    • Lab : Implementing Error Handling
    • Implementing Transactions
    • Lab : Implementing Transactions

    20462: Administering MS SQL Server Databases

    COURSE OUTLINE
    [Duration: five day]

    20462: Administering MS SQL Server Databases

    • Installing SQL Server 2014
    • Lab : Installing SQL Server 2014
    • Working with Databases
    • Lab : Creating and Configuring Databases
    • SQL Server 2014 Recovery Models
    • Lab : Understanding SQL Server Recovery Models
    • Backup of SQL Server 2014 Databases
    • Lab : Backing Up SQL Server Databases
    • Restoring SQL Server 2014 Databases
    • Lab : Restoring SQL Server Databases
    • Importing and Exporting Data
    • Lab : Importing and Exporting Data
    • Authenticating and Authorizing Users
    • Lab : Authenticating Users
    • Assigning Server and Database Roles
    • Lab : Assigning Server and Database Roles
    • Authorizing Users to Access Resources
    • Lab : Authorizing Users to Access Resources
    • Protecting Data by Using Encryption and Auditing
    • Lab : Using Auditing and Encryption
    • Automating SQL Server 2014 Management
    • Lab : Automating SQL Server Management
    • Configuring Security for SQL Server Agent
    • Lab : Configuring Security for SQL Server Agent
    • Monitoring SQL Server 2014 by Using Alerts and Notifications
    • Lab : Monitoring SQL Server by Using Alerts and Notifications
    • Performing Ongoing Database Maintenance
    • Lab : Performing Ongoing Database Maintenance
    • Tracing Access to SQL Server 2014
    • Lab : Tracing Access to SQL Server
    • Monitoring SQL Server 2014
    • Lab : Monitoring SQL Server

    20463: Implement a Data Warehouse with SQL Server

    COURSE OUTLINE
    [Duration: five day]

    20463: Implement a Data Warehouse with SQL Server

    • Introduction to Data Warehousing
    • Lab : Exploring a Data Warehousing Solution
    • Planning Data Warehouse Infrastructure
    • Lab : Planning Data Warehouse Infrastructure
    • Designing and Implementing a Data Warehouse
    • Lab : Implementing a Data Warehouse
    • Creating an ETL Solution with SSIS
    • Lab : Implementing Data Flow in an SSIS Package
    • Implementing Control Flow in an SSIS Package
    • Lab : Implementing Control Flow in an SSIS Package
    • Lab : Using Transactions and Checkpoints
    • Debugging and Troubleshooting SSIS Packages
    • Lab : Debugging and Troubleshooting an SSIS Package
    • Implementing a Data Extraction Solution
    • Lab : Extracting Modified Data
    • Loading Data into a Data Warehouse
    • Lab : Loading a Data Warehouse
    • Enforcing Data Quality
    • Lab : Cleansing Data
    • Master Data Services
    • Lab : Implementing Master Data Services
    • Extending SQL Server Integration Services
    • Lab : Using Custom Scripts
    • Deploying and Configuring SSIS Packages
    • Lab : Deploying and Configuring SSIS Packages
    • Consuming Data in a Data Warehouse
    • Lab : Using a Data Warehouse

    20464: Developing MS SQL Server 2014 Databases

    COURSE OUTLINE
    [Duration: five day]

    20464: Developing MS SQL Server 2014 Databases

    • Introduction to Database Development
    • Lab : Introduction to Database Development
    • Designing and Implementing Tables
    • Lab : Designing and Implementing Tables
    • Ensuring Data Integrity through Constraints
    • Lab : Ensuring Data Integrity through Constraints
    • Introduction to Indexing
    • Lab : Creating Indexes
    • Advanced Indexing
    • Lab : Planning for SQL Server 2014 Indexing
    • Columnstore Indexes
    • Lab : Using In-Memory Database Capabilities
    • Designing and Implementing Views
    • Lab : Designing and Implementing Views
    • Designing and Implementing Stored Procedures
    • Lab : Designing and Implementing Stored Procedures
    • Designing and Implementing User-Defined Functions
    • Lab : Designing and Implementing User-Defined Functions
    • Responding to Data Manipulation via Triggers
    • Lab : Responding to Data Manipulation via Triggers
    • Using In-Memory Tables
    • Lab : Using In-Memory Database Capabilities
    • Implementing Managed Code in SQL Server
    • Lab : Implementing Managed Code in SQL Server
    • Storing and Querying XML Data in SQL Server
    • Lab : Storing and Querying XML Data in SQL Server
    • Working with SQL Server Spatial Data
    • Lab : Working with SQL Server Spatial Data

    20465: Designing a Data Solution - SQL Server 2014

    COURSE OUTLINE
    [Duration: five day]

    20465: Designing a Data Solution - SQL Server 2014

    • Introduction to Enterprise Data Architecture
    • Lab : Assessing an Existing Enterprise Data Infrastructure
    • Multi-Server Configuration Management
    • Lab : Planning and Implementing Policy-Based Management
    • Consolidating Database Workloads with SQL Server 2014
    • Lab : SQL Server Consolidation
    • Introduction to Cloud Data Solutions
    • Lab : Preparing a SQL Server Installation in a Virtual Machine Template
    • Introduction to Windows Azure
    • Lab : Using Windows Azure
    • Windows Azure SQL Database
    • Lab : Using Windows Azure SQL Database
    • SQL Server in Windows Azure Virtual Machines
    • Lab : Using Windows Azure Virtual Machines
    • Introduction to High Availability in SQL Server 2014
    • Lab : Using Log Shipping
    • Clustering with Windows Server and SQL Server 2014
    • Lab : Implementing an AlwaysOn Failover Cluster Instance
    • AlwaysOn Availability Groups
    • Lab : Implementing and Testing an AlwaysOn Availability Group
    • Planning High Availability and Disaster Recovery
    • Lab : Planning High Availability and Disaster Recovery
    • Replicating Data
    • Lab : Planning and Implementing Replication

    20466: Implement Data Models with SQL Server 2014

    COURSE OUTLINE
    [Duration: five day]

    20466: Implement Data Models with SQL Server 2014

    • Introduction to Business Intelligence and Data Modeling
    • Lab : Exploring a BI Solution
    • Creating Multidimensional Databases
    • Lab : Creating a Multidimensional Database
    • Working with Cubes and Dimensions
    • Lab : Defining Dimensions
    • Working with Measures and Measure Groups
    • Lab : Configuring Measures and Measure Groups
    • Introduction to MDX
    • Lab : Using MDX
    • Enhancing a Cube
    • Lab : Customizing a Cube
    • Implementing an Analysis Services Tabular Data Model
    • Lab : Implementing an Analysis Services Tabular Data Model
    • Introduction to DAX
    • Lab : Using DAX to Enhance a Tabular Data Model
    • Implementing Reports with SQL Server Reporting Services
    • Lab : Creating a Report with Report Designer
    • Enhancing Reports with SQL Server Reporting Services
    • Lab : Enhancing a Report
    • Managing Report Execution and Delivery
    • Lab : Configuring Report Execution and Delivery
    • Delivering BI with SharePoint PerformancePoint Services
    • Lab : Implementing a SharePoint Server BI Solution
    • Performing Predictive Analysis with Data Mining
    • Lab : Using Data Mining to Support a Marketing Campaign

    20467: Business Intelligence (BI): SQL Server 2014

    COURSE OUTLINE
    [Duration: four day]

    20467: Business Intelligence (BI): SQL Server 2014

    • Introduction to Self-Service Business Intelligence
    • Lab : Exploring an Enterprise BI Solution
    • Self-Service Reporting
    • Lab : Implementing Self-Service Reporting
    • Self-Service Data Modeling with PowerPivot
    • Lab : Self-Service Data Modeling with PowerPivot
    • Importing Data with Power Query
    • Lab : Using Power Query
    • Visualizing Data with Power View in Microsoft Excel
    • Lab : Visualizing Data with Power View
    • Visualizing Geographic Data with Power Map
    • Lab : Visualizing Geographic Data with Power Map
    • Collaborative BI with Microsoft SharePoint Server
    • Lab : Using SharePoint Server for BI Collaboration
    • The Windows Azure Marketplace Data Market
    • Lab : Using the Windows Azure Marketplace
    • Cloud Collaboration with Power BI for Microsoft Office 365
    • Lab : Using Power BI
    • Introduction to Big Data and Windows Azure HDInsight
    • Lab : Using Windows Azure HDInsight
    • Processing Big Data with Pig and Hive
    • Lab : Processing Big Data with Pig and Hive
    • Implementing Big Data Processing Solutions with Windows Azure HDInsight
    • Lab : Creating a Big Data Solution

    MORE INFORMATION FOR
    UPGRADING YOUR SQL SERVER SKILLS TO MICROSOFT SQL SERVER 2014

    General Information

    All SQL Server training courses use the latest content, qualified and experienced trainers, and provide delegates with the best learning experience. Training is interactive and classroom-based, and the ability to ask questions reinforces knowledge acquisition during the class.

    Class Sizes

    Maximum class sizes vary, but there is always adequate time for delegates to ask questions of the instructor.

    How to book
    Course, dates and delegate numbers
    Decide on the SQL Server course you want, the date(s) you can attend, and the number of delegates involved
    Call us
    if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

    Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

    Also note: If you are a private individual you must pay by credit card at the time of booking.

    The confirmation process
    Course places allocated
    Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
    Booking confirmation
    You receive an official confirmation, with joining instructions (and directions if it's at our centre)
    Training invoice
    You receive a VAT invoice

    Note: Please allow 1 - 2 working days for your confirmation and invoice.

    What happens on the day

    If you are coming to our centre, dress code is smart casual.   The timetable is as follows:

    9:15

    ARRIVAL TIME

    9:30

    TRAINING STARTS

    11:00

    MID-MORNING BREAK



    1:00

    ONE HOUR LUNCH BREAK

    3:15

    MID-AFTERNOON BREAK

    4:30

    WRAP UP

    Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

    What you get

    With your SQL Server training course from Activia, you get a free workbook, so you can review and revise afterwards to reinforce your knowledge.



    GET IN TOUCH

    Call us on:
    0333 6000 111

       You can Email us direct (You'll usually get a response within 2-3 working hours)
       Or fill out the details below and we'll be in touch very soon:
    SEND MESSAGE

    Stay in touch
              TrustPilot
    CPD
    ILM
    ISO9001


    Back to top
    Quick Links
    More on This Page
    HOME
    Get your Attendance Certificate
    See Our SQL Server Courses
        2786: SQL Server 2005: Infrastructure Design
        2787: SQL Server 2005: Security
        2788: SQL Server 2005: Database Design
        2789: SQL Server 2005: Databases and Servers
        2790: SQL Server 2005: Database Servers
        50027: SQL Server: Querying & Processing Data
        2779: SQL Server 2005: Implementing a Database
        6232: Implementing SQL Server 2008 R2
        6231: Maintaining SQL Server 2008 R2
        6235: SQL Server 2008: Integration Services
        6236: SQL Server 2008: Reporting Services
        50401: SQL Server 2008: Database Solutions
        2778: SQL Server 2008: Writing Queries
        6235: SQL Server 2008: Integration Services
        2778: SQL Server 2008: Writing Queries
        QATSQL : Querying SQL Databases using T-SQL
        10774: Querying Microsoft SQL Server 2012
        10775: Administering SQL Server 2012 Databases
        10776: Developing SQL Server 2012 Databases
        10777: Data Warehousing with SQL Server 2012
        10778: Data Models & Reports with SQL Server 2012
        10977: Upgrading SQL Skills to SQL Server 2014
        Analysing Data With SQL Server Reporting
        20461: Querying Microsoft SQL Server 2014
        20462: Administering MS SQL Server Databases
        20463: Implement a Data Warehouse with SQL Server
        20464: Developing MS SQL Server 2014 Databases
        20465: Designing a Data Solution - SQL Server 2014
        20466: Implement Data Models with SQL Server 2014
        20467: Business Intelligence (BI): SQL Server 2014
    More About SQL Server Training
    REQUEST MORE INFORMATION
    View prices/options, and book
    We do not have classes for 10977: Upgrading SQL Skills to SQL Server 2014 scheduled at present but contact us to see how you can schedule your own

    OK
    Site Cookies
    We have placed cookies on your device to help make this website better.

    You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

    I'm fine with this