Microsoft SQL Server 2012: Managing Database Data


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
SQL Server 2012 provides various features and utilities to manage data stored in the databases within a SQL Server instance. This includes support for storing large unstructured data, such as files and documents within or outside the database. The ability to store large data is supported through the FILESTREAM database feature. This enables large unstructured data to be store outside the database on the file system by providing integration between the file system and SQL Server. FileTables is another database feature that allows large data to be store within tables, but accessed from the file system. SQL Server also provides data compression at the row and page level to compress data that is stored within a database which can help reduce its size. Bulk exporting and importing of data is another feature supported by SQL Server 2012 to allow data to be moved from outside sources into SQL Server or out of SQL Server to outside source or other SQL Server databases. This course provides an overview of the FILESTREAM and FileTable features, including how to enable and use them within a SQL Server 2012 database. It also covers data compression and how to use the bcp utility, BULK INSERT, and OPENROWSET(BULK) function to import and export data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2012: Managing Database Data

  • identify the characteristics of FILESTREAM
  • enable and configure FILESTREAM
  • identify the considerations involved in implementing FileTables
  • manage FileTables using Transact-SQL
  • determine the most appropriate method for populating FileTables for a given scenario
  • describe the considerations involved in using data compression
  • enable compression
  • use SQL Server 2012 features to manage the storage of files
  • implement a data compression solution for a given scenario
  • describe the considerations involved in working with bulk data in SQL Server 2012
  • use the bcp utility to move data
  • recognize how to create file formats
  • use the Transact-SQL statements that support bulk importing
  • use SQL Server 2012 data import and export tools
  • Course Number:
    md_msdb_a05_it_enus

    Expertise Level
    Beginner