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

Working With Temporal Data in SQL Server

Course Summary

Although temporal data is part of many business applications, most RDBMS', including SQL Server, do not support it out of the box. However, before solving the problem, you need to understand it. After an introduction to temporal problems and constraints,


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Modules
    ● Temporal Databases, Problems, and Constraints
        ◦ Introduction
        ◦ Theoretical and Practical Background
        ◦ Temporal Databases
        ◦ Semi-Temporal Problems
        ◦ Full-Temporal Problems
        ◦ Additional Discussions
        ◦ Summary
    ● The Interval Data Type
        ◦ Introduction
        ◦ IntervalCID Data Type
        ◦ Allen's Interval Boolean Operators
        ◦ Allen's Interval Algebra Operators
        ◦ Full-Temporal Constraints Revisited
        ◦ Summary
    ● Packing and Unpacking Intervals
        ◦ Introduction
        ◦ Theoretical and Practical Background
        ◦ Temporal Databases
        ◦ Semi-Temporal Problems
        ◦ Full-Temporal Problems
        ◦ Additional Discussions
        ◦ Summary
    ● Optimizing Temporal Queries Part 1
        ◦ Introduction
        ◦ Classical T-SQL Solution
        ◦ Relational Interval Tree (RIT)
        ◦ RIT Calculation
        ◦ Querying RIT
        ◦ Summary
    ● Optimizing Temporal Queries Part 2
        ◦ Introduction
        ◦ Spatial Data Type
        ◦ XML Data Type
        ◦ Enhanced T-SQL Solution
        ◦ Summary
    ● Optimizing Temporal Queries Part 3
        ◦ Introduction
        ◦ IntervalCID Data Type
        ◦ Unpacked Form
        ◦ Compact Unpacked Form
        ◦ Summary
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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