Introduction to Dates, Times and Intervals in Oracle [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Introduction to Dates, Times and Intervals in Oracle

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/
Автор: Scott Hecht
Продолжительность: 2h 24m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: The Introduction to Dates, Time and Intervals in Oracle course details how to use the DATE, TIMESTAMP and INTERVAL data types as well as the many date- and time-related functions available to the SQL programmer such as TO_DATE(), TO_CHAR(), MONTHS_BETWEEN(), as well as many others.

Введение в дат, времени и интервалы в Oracle дистанциями, как использовать дата, отметка и интервальных типов данных, а также много даты и времени, связанных функций, доступных в SQL программист, такие как TO_DATE (), TO_CHAR (), MONTHS_BETWEEN (), а также многие другие.
[spoiler="Содержание"]
Код: │ intro-dates-times-intervals-oracle.zip
│
├───01. Getting Started
│ 01. Introduction and Course Contents.wmv
│ 02. Database Version.wmv
│ 03. Data used in Course.wmv
│ 04. The DUAL Table.wmv
│ 05. Missing Content.wmv
│ 06. Summary.wmv
│
├───02. Overview
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. Data Types.wmv
│ 04. Congruence.wmv
│ 05. Literals.wmv
│ 06. Conversion Functions.wmv
│ 07. Additional Functions.wmv
│ 08. Summary.wmv
│
├───03. Date Data Type
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. The DATE Data Type.wmv
│ 04. Storage.wmv
│ 05. Initialization.wmv
│ 06. Operations.wmv
│ 07. Summary.wmv
│
├───04. TIMESTAMP Data Type
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. The TIMESTAMP Data Type.wmv
│ 04. Storage.wmv
│ 05. Initialization.wmv
│ 06. Operations.wmv
│ 07. Summary.wmv
│
├───05. INTERVAL Data Types
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. The INTERVAL Data Types.wmv
│ 04. Storage.wmv
│ 05. Initialization.wmv
│ 06. Operations.wmv
│ 07. Summary.wmv
│
├───06. Literals
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. A Literal Overview.wmv
│ 04. The DATE Literal.wmv
│ 05. The TIMESTAMP Literal.wmv
│ 06. A Warning About Default Formats.wmv
│ 07. The INTERVAL YEAR TO MONTH Literal.wmv
│ 08. The INTERVAL DAY TO SECOND Literal.wmv
│ 09. Summary.wmv
│
├───07. Conversion Functions
│ 01. Introduction.wmv
│ 02. Module Contents.wmv
│ 03. TO_CHAR() Conversion Function.wmv
│ 04. Format Models Introduction.wmv
│ 05. Format Models (YYYY MM DD).wmv
│ 06. Format Models (MONTH MON).wmv
│ 07. Format Models (DAY DY).wmv
│ 08. Format Models (DDD D).wmv
│ 09. Format Models (WW W).wmv
│ 10. Format Models (Q J).wmv
│ 11. Format Models (DS).wmv
│ 12. Format Models (DL).wmv
│ 13. Format Models (HH HH12 HH24 MI SS xFF).wmv
│ 14. TO_DATE() Conversion Function.wmv
│ 15. TO_TIMESTAMP() Conversion Function.wmv
│ 16. TO_YMINTERVAL() Conversion Function.wmv
│ 17. TO_DSINTERVAL() Conversion Function.wmv
│ 18. NUMTOYMINTERVAL() Conversion Function.wmv
│ 19. NUMTODSINTERVAL() Conversion Function.wmv
│ 20. CAST() Conversion Function.wmv
│ 21. EXTRACT() Conversion Function.wmv
│ 22. Summary.wmv
│
└───08. Additional Functions
01. Introduction.wmv
02. Module Contents.wmv
03. The ADD_MONTHS() Function.wmv
04. The MONTHS_BETWEEN() Function.wmv
05. The NEXT_DAY() Function.wmv
06. The LAST_DAY() Function.wmv
07. The ROUND() Function.wmv
08. The TRUNC() Function.wmv
09. The SYSDATE and CURRENT_DATE Functions.wmv
10. The SYSTIMESTAMP and CURRENT_TIMESTAMP Functions.wmv
11. Summary.wmv
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
[spoiler="audio\video"]
General
Complete name : C:\02. Database Version.wmv
Format : Windows Media
File size : 1.08 MiB
Duration : 46s 599ms
Overall bit rate mode : Variable
Overall bit rate : 194 Kbps
Maximum Overall bit rate : 180 Kbps
Movie name : intro-dates-times-intervals-oracle-m1-contents
Performer : Scott L. Hecht
Encoded date : UTC 2013-11-15 18:04:43.189

Video
ID : 2
Format : VC-1
Format profile : MP@HL
Codec ID : WMV3
Codec ID/Info : Windows Media Video 9
Codec ID/Hint : WMV3
Description of the codec : Windows Media Video 9
Duration : 46s 600ms
Bit rate mode : Variable
Bit rate : 14.6 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Compression mode : Lossy
Bits/(Pixel*Frame) : 0.001
Stream size : 82.9 KiB (7%)
Language : English (US)

Audio
ID : 1
Format : WMA
Format version : Version 2
Codec ID : 161
Codec ID/Info : Windows Media Audio
Description of the codec : Windows Media Audio 9.2 - 128 kbps, 44 kHz, stereo (A/V) 1-pass CBR
Duration : 46s 599ms
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Sampling rate : 44.1 KHz
Bit depth : 16 bits
Stream size : 728 KiB (66%)
Language : English (US)
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]