Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.