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