Microsoft SQL Server 2012 – Developing Databases: Working with Data

This course is included in our On-demand training solution.


SQL Server 2012 provides advanced features to enable large data to be stored and accessed within the database itself. By using the FILESTREAM and FileTable features documents are stored in the Windows file system but accessed through the database using T-SQL queries. SQL Server also allows these documents to be searched for words or phrases. Advanced query techniques can also be used to manipulate data to retrieve specific data. This course demonstrates how to configure FILESTREAM, FileTables, and Full-Text Search. It also demonstrates how to use advanced query technique such as PIVOT, UNPIVOT, CROSS | OUTER APPLY, and CTEs, as well as Spatial data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the MCSE: Data Platform certification path.

Target Audience

Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.



Expected Duration

90 min.

Course Objectives

Using FILESTREAM and FileTables in SQL Server 2012

  • configure FILESTREAM in SQL Server 2012
  • Using FileTables in SQL Server 2012

  • recognize how to manage SQL Server 2012 FileTables in a given scenario
  • Implementing Full-Text Search in SQL Server 2012

  • create a full-text index in a given scenario
  • Using Full-Text Search in SQL Server 2012

  • describe how to use Full-Text Search to do searches on character-based data
  • Using Semantic Search in SQL Server 2012

  • recognize how to use Semantic Search to identify key phrases in unstructured data
  • Using Querying Techniques to Manipulate Data

  • describe how to manipulate data using query techniques in a given scenario
  • Using Spatial Indexes in SQL Server 2012

  • identify the considerations involved in creating spatial indexes
  • Using SQL Server 2012 Querying Techniques