CareerVision Training

Time and Relational Theory Training Video

CareerVision Training

£ 202 - (237 )

Información importante

  • Training
  • Beginner
  • A distancia
  • Duración:
  • Cuándo:
    A elegir

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Información importante
Instalaciones y fechas

Dónde se imparte y en qué fechas

Inicio Ubicación
A elegir
Distance Learning

¿Qué aprendes en este curso?



Time and Relational Theory Training Video

  • Duration: 12 hours - 30 tutorial videos
  • Date Released: 2015-05-19
  • Works on: Windows PC or Mac
  • Format: DVD and Download
  • Instructor: Chris Date

A Practical Training Course That Teaches Real World Skills

In this project-based Time and Relational Theory video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Time and Relational Theory training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Time and Relational Theory subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Time and Relational Theory tutorial, online or offline... so you'll know the exact steps for your own projects.

Two recent trends-the plummeting cost of storage and the widespread adoption of data warehouse technology-have led to an increasing interest in temporal databases. Indeed, the idea of maintaining and processing historical data has become not just a goal but also a reality for many organizations. Consequently, the ability to deal properly with the time dimension in databases has become an increasingly important practical problem. And today's mainstream DBMS products are beginning to include features that are specifically designed to help with this important requirement-though it has to be said too that the support currently found in those products falls a long way short of the theoretical ideal. This Master Class video describes and explains that theoretical ideal-which, interestingly, is 100 percent consistent with the classical relational model-in depth. It also discusses, in depth, the new temporal support to be found in the SQL standard ("SQL:2011"). This video includes five major parts:

- A Review of Relational Concepts-consists of a careful review of the relational model, with emphasis on features that seem not to be as widely understood as they should be.
- Laying the Foundations-explains some of the basic problems of temporal databases (some of which are far from obvious, incidentally) and lays the groundwork for solving those problems.
- Building on the Foundations-uses the material from Part II as a basis for addressing a variety of practical issues, including temporal database design, temporal integrity constraints, and temporal querying and updating.
- SQL Support-explains the pertinent features of the SQL standard in detail..

Course Outline
01. Time And Relational Theory Introduction Types Relations 0104 Relational Algebra - Part 1 0105 Relational Algebra - Part 2 0106 Relation Variables 02. Laying The Foundations 0201 Time And The Database 0202 What Is The Problem? 0203 Intervals 0204 Expand And Collapse 0205 Pack And Unpack - The Single Attribute Case 0206 Pack And Unpack - The Multiattribute Case 0207 Generalizing The Relational Operators 03. Building On The Foundations 0301 Database Design Structure - Part 1 0302 Database Design Structure - Part 2 0303 Database Design Keys And Related Constraints - Part 1 0304 Database Design Keys And Related Constraints - Part 2 0305 Database Design - General Constraints 0306 Queries 0307 Updates - Part 1 0308 Updates - Part 2 0309 Logged Time And Stated Time 0310 Point And Interval Types Revisited 0311 Numeric Types 0312 Interval Types Revisited 04. SQL Support 0401 SQL Support - Periods 0402 SQL Support - Queries 0403 SQL Support - System Time 0404 SQL Support - Summary And Assessment 05. Appendices 0501 Appendices