Instances & Storage Considerations

SQL Server 2016    |    Intermediate
  • 17 videos | 1h 36m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 19 users Rating 4.5 of 19 users (19)
SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. Explore SQL Server instances in IaaS and on-premises, and the various storage solutions in SQL Server 2016.

WHAT YOU WILL LEARN

  • Describe sql server instances
    Explain how to host a sql server instance using azure vms
    Recognize the benefits of using azure automation
    Explain how and when to use azure resource manager
    Demonstrate how to deploy sql server using templates
    Provide an introduction to data storage with sql server
    Discuss considerations when planning disk storage devices
    Explain the different types of raid configurations
    Differentiate between the five sql server system databases
  • Demonstrate how to create user databases in sql server 2016
    Explain the use of filegroups in sql server 2016
    Describe how sql server uses the buffer pool extension
    Demonstrate how to configure the storage buffer pool extension
    Explain how storage spaces can be used in sql server 2016
    Describe storage layout considerations when using virtual machines
    Describe other possible storage solutions, including nas, das, and san
    Determine effective disk or storage configuration for a given scenario

IN THIS COURSE

  • 5m 36s
    Upon completion of this video, you will be able to describe SQL Server instances. FREE ACCESS
  • 7m 36s
    After completing this video, you will be able to explain how to host a SQL Server instance using Azure VMs. FREE ACCESS
  • Locked
    3.  Azure Automation
    3m 41s
    After completing this video, you will be able to recognize the benefits of using Azure automation. FREE ACCESS
  • Locked
    4.  Azure Resource Manager
    4m 23s
    After completing this video, you will be able to explain how and when to use Azure resource manager . FREE ACCESS
  • Locked
    5.  Deploying SQL Server by Using Templates
    5m 25s
    In this video, you will learn how to deploy SQL Server using templates. FREE ACCESS
  • Locked
    6.  Data Storage Overview
    9m 49s
    After completing this video, you will be able to provide an introduction to data storage with SQL Server . FREE ACCESS
  • Locked
    7.  Storage Considerations
    6m 30s
    During this video, you will learn how to discuss considerations for planning disk storage devices. FREE ACCESS
  • Locked
    8.  Implementing RAID Levels
    8m 52s
    After completing this video, you will be able to explain the different types of RAID configurations. FREE ACCESS
  • Locked
    9.  SQL Server System Databases
    5m 40s
    In this video, you will learn the difference between the five SQL Server system databases. FREE ACCESS
  • Locked
    10.  Creating User Databases
    6m 13s
    In this video, you will learn how to create user databases in SQL Server 2016. FREE ACCESS
  • Locked
    11.  Filegroups
    6m 31s
    After completing this video, you will be able to explain the use of filegroups in SQL Server 2016. FREE ACCESS
  • Locked
    12.  Buffer Pool Extension
    3m 23s
    After completing this video, you will be able to describe how SQL Server uses the buffer pool extension. FREE ACCESS
  • Locked
    13.  Configuring the Buffer Pool Extension
    6m 52s
    In this video, you will learn how to configure the storage buffer pool extension. FREE ACCESS
  • Locked
    14.  Storage Spaces
    2m 55s
    After completing this video, you will be able to explain how storage spaces can be used in SQL Server 2016. FREE ACCESS
  • Locked
    15.  Storage Layouts for a SQL Server Virtual Machine
    4m 9s
    After completing this video, you will be able to describe storage layout considerations when using virtual machines. FREE ACCESS
  • Locked
    16.  Other Storage Options
    5m 21s
    After completing this video, you will be able to describe other possible storage solutions, including network-attached storage, direct-attached storage, and storage area network. FREE ACCESS
  • Locked
    17.  Exercise: Determining Storage Configuration
    3m 40s
    Learn how to determine an effective disk or storage configuration for a given scenario. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform, Second Edition
Course Data Engineering on Microsoft Azure: Storage Accounts
Rating 4.4 of 186 users Rating 4.4 of 186 users (186)
Course SQL Platform & Installation Best Practices
Rating 4.5 of 50 users Rating 4.5 of 50 users (50)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Dynamic Data Masking
Rating 4.3 of 9 users Rating 4.3 of 9 users (9)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Windows Server 2016 - Install, Store, & Compute: Server Storage Solutions
Rating 4.6 of 47 users Rating 4.6 of 47 users (47)