MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server 2012-2014 Native File Streaming

Course Summary

This course teaches unstructured data storage with FILESTREAM, hierarchyid, and FileTable. It explains T-SQL access, as well as streaming API access with SqlFileStream in client applications.


  • +

    Course Syllabus

    Getting Started with FILESTREAM
    - 53m 19s

    —Why Stream Files with SQL Server? 2m 25s
    —Introducing FILESTREAM 2m 24s
    —Traditional Options - BLOBs in the Database 2m 25s
    —Traditional Options - BLOBs Outside the Database 2m 49s
    —BLOB Storage with FILESTREAM 4m 24s
    —Enabling FILESTREAM - Introduction 2m 9s
    —Determining the FILESTREAM Access Level 2m 24s
    —Enabling FILESTREAM for Windows and SQL Server 3m 22s
    —Demo: Enabling FILESTREAM 5m 14s
    —Creating a FILESTREAM Database 3m 26s
    —Demo: Creating a FILESTREAM Database 4m 22s
    —Creating a Table with FILESTREAM Columns 2m 22s
    —Demo: Using T-SQL to Access FILESTREAM Data 9m 47s
    —Improving I/O Scalability 4m 5s
    —Summary 1m 33s
    Programming with SqlFileStream
    - 1h 8m

    —Storage vs. Access 2m 32s
    —Introducing SqlFileStream 4m 47s
    —Storing and Retrieving BLOBs with SqlFileStream 4m 22s
    —Demo: Storing BLOBs with SqlFileStream 20m 32s
    —Demo: Retrieving BLOBs with SqlFileStream 3m 23s
    —Building SqlFileStream Client Applications 4m 17s
    —Demo: Building a Client/Server SqlFileStream Application 15m 43s
    —Demo: Building an N-Tier SqlFileStream Application 11m 15s
    —Summary 1m 10s
    Working with hierarchyid
    - 39m 44s
    Using FileTable
    - 1h 10m


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top