Indexing, Querying and Analyzing Text with SQL Server 2012-2014

WEBRip | English | MP4 + Project files | 1024 x 768 | AVC ~227 kbps | 15 fps

AAC | 127 Kbps | 44.1 KHz | 2 channels | 2h 48mn | 565.3 MB

Genre: Video Tutorial

Working with textual data in SQL Server involves indexing, querying and analyzing texts. Improve transactional and analytical applications with Full-Text Search and analyze texts with Semantic Search and Text Mining.

It is hard to imagine searching for something on the Web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; end users would probably like to get powerful search inside document contents as well. Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents. Finally, the Term Extraction and Term Lookup components from SQL Server Integration Services also helps with text analysis.

Content:

01. Introduction

01. Introduction.mp4

02. Modules.mp4

02. Creating Full-Text Search Catalogs and Indexes

01. Introduction.mp4

02. FtsSsComponents12.mp4

03. FtsSsComponents34.mp4

04. FtsSsComponents56.mp4

05. DemoSetup.mp4

06. PropertyStop.mp4

07. CataIdx.mp4

08. DemoCreate.mp4

09. Demo2012.mp4

10. Summary.mp4

03. Queries with Full-Text Search Predicates

01. Overview.mp4

02. Introduction.mp4

03. Contains1Simple.mp4

04. Contains2Prefix.mp4

05. Contains3Proximity.mp4

06. DemoContains1.mp4

07. Contains4Inflectional.mp4

08. Contains5Synonyms.mp4

09. Contains6DocProperties.mp4

10. Freetext.mp4

11. DemoContains2Free.mp4

12. Demo2012.mp4

13. Summary.mp4

04. Full-Text and Semantic Search Table-Valued Functions

01. Overview.mp4

02. Introduction.mp4

03. FTSFunctions.mp4

04. ContainsTable.mp4

05. FreetextTable.mp4

06. DemoFTSFun.mp4

07. SemKeyPhrase.mp4

08. SemSimDetails.mp4

09. SemSimTable.mp4

10. DemoSSFun.mp4

11. Demo2012.mp4

12. Performance.mp4

13. Summary.mp4

05. Extracting Terms from Texts

01. Overview.mp4

02. Introduction.mp4

03. TermExt1.mp4

04. DemoTECroSlo.mp4

05. TermExt2.mp4

06. TermExt3.mp4

07. DemoTEEn.mp4

08. FTSDMFun12.mp4

09. FTSDMFun34.mp4

10. DemoFTSDMFun.mp4

11. Demo2012.mp4

12. Summary.mp4

06. Looking Up for Terms in Texts

01. Overview.mp4

02. Introduction.mp4

03. Term Lookup 1 Basics.mp4

04. Term Lookup 2 Advanced.mp4

05. Demo Term Lookup.mp4

06. SSIS Issues Basic Analysis.mp4

07. Demo SSRS PowerPivot.mp4

08. Advanced Analysis.mp4

09. Demo Data Mining.mp4

10. Demo2012.mp4

11. Summary.mp4