2014
Pluralsight
Dejan Sarka
2h 48m
English

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.

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

http://pluralsight.com/

Download File Size:547.99 MB

---