Introduction to SQL Database

Session Detail:    Classroom, Virtual 5 Day

This five-day instructor-led course provides existing SQL Server 2008 database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2014. The course covers the major advancements made in the SQL Server platform since SQL Server 2008, including new features in the SQL Server 2014 release.

Microsoft Azure and Office 365 are required or used as part of the lab for this course, which may not be available in all countries. Please check with your Microsoft training provider that this cloud service is available in your area. Training Providers, please reference the course setup guide for more details.

Prerequisites

This course requires that you meet the following prerequisites:

  • 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

Who Can Benefit

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.

Session Outline

Class Outline

Module 1: Introduction to SQL Server 2014

  • Lesson 1: Overview of SQL Server 2014
  • Lesson 2: SQL Server 2014 Editions and Components
  • Lesson 3: Installing SQL Server 2014
  • Lesson 4: Enhancements to SQL Server Management Studio

After completing this module, you will be able to:

  • Describe common workloads for SQL Server 2014
  • Describe the SQL Server 2014 Editions and Components
  • Install SQL Server 2014 Components
  • Use new features in SQL Server Management Studio

Module 2: What’s New in SQL Server Database Development

  • Lesson 1: Transact-SQL Enhancements
  • Lesson 2: New and Enhanced Transact-SQL Functions
  • Lesson 3: Enhancements to Spatial Data Support
  • Lesson 4: Storing and Querying Documents with SQL Server 2014

After completing this module, you will be able to:

  • Describe enhancements to Transact-SQL
  • Describe new and enhanced Transact-SQL functions
  • Describe Enhancements to Spatial Data Support
  • Explain how to store and query documents with SQL Server 2014

Module 3: In-Memory Database Capabilities

  • Lesson 1: The Buffer pool Extension
  • Lesson 2: Columnstore Indexes
  • Lesson 3: Memory-Optimized Tables

After completing this module, you will be able to:

  • Use the Buffer Pool Extension to improve performance for read-heavy OLTP workloads
  • Use Columnstore Indexes to improve performance in data warehouse query workloads
  • Use memory-optimized tables to improve performance for latch-bound workloads

Module 4: Scripting SQL Server 2014

  • Lesson 1: New and Enhanced Dynamic Management Views
  • Lesson 2: Using PowerShell to Manage SQL Server

After completing this module, you will be able to:

  • Describe new and enhanced dynamic management views
  • Describe how to use PowerShell to Manage SQL Server

Module 5: Implementing Security in Microsoft SQL Server 2014

  • Lesson 1: Security Management Enhancements
  • Lesson 2: Contained Databases

After completing this module, you will be able to:

  • Describe the security enhancements in SQL Server 2014
  • Explain how to use contained databases

Module 6: High Availability and Data Recovery Enhancements

  • Lesson 1: AlwaysOn High Availability
  • Lesson 2: Enhancements to Data Recovery

After completing this module, you will be able to:

  • Describe high availability features in SQL Server 2014
  • Describe data recovery enhancements in SQL Server 2014

Module 7: New and Enhanced Features in SQL Server Integration Services

  • Lesson 1: Using the CDC Control Task for Incremental Data Loads
  • Lesson 2: Deploying and Operating SSIS Packages

After completing this module, you will be able to:

  • Use the CDC Control task to perform incremental data extractions in an ETL solution
  • Deploy and operate an SSIS project

Module 8: Data Quality Services

  • Lesson 1: Introduction to Data Quality
  • Lesson 2: Using Data Quality Services to Cleanse Data
  • Lesson 3: Using Data Quality Services to Match Data

After completing this module, you will be able to:

  • Describe how Data Quality Services can help you manage data quality
  • Use Data Quality Services to cleanse your data
  • Use Data Quality Services to match data

Module 9: Master Data Services

  • Lesson 1: Introduction to Master Data Services
  • Lesson 2: Implementing a Master Data Services Model
  • Lesson 3: Using the Master Data Services Add-in for Excel

After completing this module, you will be able to:

  • Describe key Master Data Services concepts
  • Implement a Master Data Services model
  • Use Master Data Services tools to manage master data
  • Use Master Data Services tools to create a master data hub

Module 10: SQL Server 2014 Reporting Services

  • Lesson 1: Reporting Services Overview
  • Lesson 2: Reporting Services and Microsoft SharePoint Server
  • Lesson 3: Introduction to Data Alerts

After completing this module, you will be able to:

  • Describe the key capabilities of Reporting Services
  • Install and configure Reporting Services in SharePoint Mode
  • Use data alerts to notify users of changes to report data

Module 11: Implementing an Analysis Services Tabular Data Model

  • Lesson 1: Introduction to Analysis Services Tabular Data Model Projects
  • Lesson 2: Creating a Tabular Model
  • Lesson 3: Using an Analysis Services Tabular Data Model in the Enterprise

After completing this module, you will be able to:

  • Describe Analysis Services tabular data model projects
  • Implement an Analysis Services tabular data model
  • Use an Analysis Services tabular data model

Module 12: Self-Service BI with Microsoft Excel

  • Lesson 1: PowerPivot for Excel
  • Lesson 2: PowerPivot for SharePoint Server
  • Lesson 3: Power Query
  • Lesson 4: Power View
  • Lesson 5: Power Map
  • Lesson 6: Collaborative Analysis with Power BI for Office 365

After completing this module, you will be able to:

  • Use PowerPivot to create tabular data models in Excel
  • Share PowerPivot workbooks in SharePoint Server
  • Use Power Query to discover and import data from multiple data sources into Excel
  • Use Power View to create interactive data visualizations in Excel and SharePoint Server
  • Use Power Map to create visualizations of geographic data
  • Use Power BI for Office 365 to create a cloud-based collaborative solution for self-service BI

Module 13: Introduction to Cloud Data Solutions

  • Lesson 1: Overview of Cloud Computing
  • Lesson 2: Microsoft Azure Services for Data

After completing this module, you will be able to:

  • Describe key features and benefits of cloud computing
  • Describe Microsoft Azure service for data

Module 14: Microsoft Azure SQL Database

  • Lesson 1: Introduction to Microsoft Azure SQL Database
  • Lesson 2: Microsoft Azure SQL Database Security
  • Lesson 3: Implementing and Managing Databases

After completing this module, you will be able to:

  • Describe key features and benefits of Microsoft Azure SQL Database
  • Implement security for Microsoft Azure SQL Database
  • Implement and manage databases in Microsoft Azure SQL Database

Module 15: SQL Server in Microsoft Azure Virtual Machines

  • Lesson 1: Introduction to Microsoft Azure Virtual Machines
  • Lesson 2: Microsoft Azure Virtual Machine Connectivity and Security
  • Lesson 3: Creating Databases in a Microsoft Azure Virtual Machine

After completing this module, you will be able to:

  • Describe considerations for using Virtual Machines in Microsoft Azure
  • Create and configure Microsoft Azure virtual machines
  • Create databases in Microsoft Azure virtual machines

Module 16: Implementing Big Data Solutions

  • Lesson 1: Introduction to Big Data
  • Lesson 2: Microsoft Azure HDInsight
  • Lesson 3: Consuming HDInsight Results in Excel
  • Lesson 4: Obtaining Data from the Microsoft Azure Marketplace

After completing this module, you will be able to:

  • Describe key features of big data
  • Process big data with Microsoft Azure HDInsight
  • Consume big data processing results from Microsoft Azure HDInsight in Microsoft Excel

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Introduction to SQL Database

5 Day
Classroom, Virtual

$3,095.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now