Register for
Temporal Tables and Change Data Capture in SQL 2016

Feb 13 @ 10AM

Free Webinar: Temporal Tables and Change Data Capture in SQL 2016


Join Signzilla trainer and Expert Instructor Charles Hyman for a 2-hour complimentary webinar on Temporal Tables and Change Data Capture in SQL Server 2016.

 

Tuesday, 2/13/2018 @ 10am

 

SQL Server 2016 introduced support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time.

 

Real data sources are dynamic and more often than not business decisions rely on insights that analysts can get from data evolution. 
Use cases for temporal tables include:

  • Auditing all data changes and performing data forensics when necessary

  • Reconstructing state of the data as of any time in the past

  • Calculating trends over time

  • Maintaining a slowly changing dimension for decision support applications

  • Recovering from accidental data changes and application errors

Agenda: 
 

  • Creating System-Versioned Temporal Tables 

  • Working with Memory-Optimized System-Versioned Temporal Tables 

  • Modifying Data in a System-Versioned Temporal Table 

  • Querying Data in a System-Versioned Temporal Table 

  • Temporal Table Usage Scenarios 

  • Enable Change Data Capture for a Database

  • Administer and Monitor Change Data Capture 

  • Working with Change Data Using CDC with SSIS

About the Company 
Signzilla Training is based in Effort, Pennsylvania, with courses offered at convenient locations near major metropolitan areas, custom training on site at your own organization,
as well as fully online.

About Mr. Charles Hyman

Register NOW to win an Amazon Fire HD 8

SQLCodingCamp.com

© 2018 SQLCodingCamp is an offering of Signzilla Enterprises

Email: sales@signzillatraining.com

Phone: (475) 328-2227

.........