Your Career
Training Marketplace

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

Course ID: 252791

e-Learning Bundle

Microsoft SQL Server 2012: Developing Databases Part 2

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

  • Instant Access
    From Anywhere
  • Unlimited
    Viewing
  • 6-12 Months
    To Complete

Agenda

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 Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • configure FILESTREAM in SQL Server 2012
  • recognize how to manage SQL Server 2012 FileTables in a given scenario
  • create a full-text index in a given scenario
  • describe how to use Full-Text Search to do searches on character-based data
  • recognize how to use Semantic Search to identify key phrases in unstructured data
  • describe how to manipulate data using query techniques in a given scenario
  • identify the considerations involved in creating spatial indexes
  • use SQL Server 2012 features to manage, search, and manipulate data
The relational database, such as SQL Server 2012, has been around for decades going back to E.F. Codd and his designs. Since then, many applications have been built upon this concept. In 1999, the internet was gaining momentum. Around the same time, a new hierarchica l concept for storing data was introduced: extensible markup language or XML. As the internet gained more prominence to its current ubiquitous standing, XML took on increasing significance for moving data around. Subsequently, it became equally important for relational and hierarchical data to be somewhat interchangeable between online data-based applications and services. This course introduces XML in relation to SQL Server and how to work with XML data in SQL Server 2012. 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 Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • describe the advantages of using XML data storage in SQL Server 2012
  • identify how to work with XML data in a given scenario
  • describe the characteristics of XML indexes in SQL Server 2012
  • recognize how to query relational data as XML in SQL Server 2012
  • recognize how to query XML data using XQuery() in SQL Server 2012
  • describe how to shred XML data in SQL Server 2012
  • store and query XML data in SQL Server 2012
With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. 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 Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • differentiate between tools for analyzing queries
  • recognize the functions of DMVs
  • determine the most appropriate transaction isolation level to used in a certain situation
  • identify sources where Extended Events correlate data from
  • troubleshoot poorly performing applications in a database
With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measurable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. 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 Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • identify methods for scheduling a job
  • describe a method to shrink a database
  • describe the advantages of encrypting data
  • describe the advantages of using change data capture
  • design, implement, and troubleshoot security, troubleshoot and resolve performance problems, design tables, create and alter tables (complex statements)

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

  • 50K+ Companies Trained

    Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com

  • 300K+ Courses & Videos

    Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers

  • 800+ Expert Instructors

    Industry-Leading Subject Matter Experts (SMEs).Tenured &
    Award-Winning Instructor Network

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