Oracle Database 12c: Analytic SQL for Data Warehousing

направление: Oracle
вендор:
Даты проведения курса
Array
(
    [1] => Array
        (
            [PRICES] => Array
                (
                    [BASE] => Array
                        (
                            [PRICE_ID] => 1
                            [ID] => 57743
                            [CAN_ACCESS] => Y
                            [CAN_BUY] => Y
                            [MIN_PRICE] => Y
                            [CURRENCY] => RUB
                            [VALUE_VAT] => 44700
                            [VALUE_NOVAT] => 44700
                            [DISCOUNT_VALUE_VAT] => 44700
                            [DISCOUNT_VALUE_NOVAT] => 44700
                            [ROUND_VALUE_VAT] => 44700
                            [ROUND_VALUE_NOVAT] => 44700
                            [VALUE] => 44700
                            [UNROUND_DISCOUNT_VALUE] => 44700
                            [DISCOUNT_VALUE] => 44700
                            [DISCOUNT_DIFF] => 0
                            [DISCOUNT_DIFF_PERCENT] => 0
                            [VATRATE_VALUE] => 0
                            [DISCOUNT_VATRATE_VALUE] => 0
                            [ROUND_VATRATE_VALUE] => 0
                            [PRINT_VALUE_NOVAT] => 44 700 руб.
                            [PRINT_VALUE_VAT] => 44 700 руб.
                            [PRINT_VATRATE_VALUE] => 0 руб.
                            [PRINT_DISCOUNT_VALUE_NOVAT] => 44 700 руб.
                            [PRINT_DISCOUNT_VALUE_VAT] => 44 700 руб.
                            [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
                            [PRINT_VALUE] => 44 700 руб.
                            [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                            [PRINT_DISCOUNT_DIFF] => 0 руб.
                        )

                )

            [PRICE_MATRIX] => 
            [MIN_PRICE] => Array
                (
                    [PRICE_ID] => 1
                    [ID] => 57743
                    [CAN_ACCESS] => Y
                    [CAN_BUY] => Y
                    [MIN_PRICE] => Y
                    [CURRENCY] => RUB
                    [VALUE_VAT] => 44700
                    [VALUE_NOVAT] => 44700
                    [DISCOUNT_VALUE_VAT] => 44700
                    [DISCOUNT_VALUE_NOVAT] => 44700
                    [ROUND_VALUE_VAT] => 44700
                    [ROUND_VALUE_NOVAT] => 44700
                    [VALUE] => 44700
                    [UNROUND_DISCOUNT_VALUE] => 44700
                    [DISCOUNT_VALUE] => 44700
                    [DISCOUNT_DIFF] => 0
                    [DISCOUNT_DIFF_PERCENT] => 0
                    [VATRATE_VALUE] => 0
                    [DISCOUNT_VATRATE_VALUE] => 0
                    [ROUND_VATRATE_VALUE] => 0
                    [PRINT_VALUE_NOVAT] => 44 700 руб.
                    [PRINT_VALUE_VAT] => 44 700 руб.
                    [PRINT_VATRATE_VALUE] => 0 руб.
                    [PRINT_DISCOUNT_VALUE_NOVAT] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE_VAT] => 44 700 руб.
                    [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
                    [PRINT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_DIFF] => 0 руб.
                )

            [CATALOG_GROUP_ID_1] => 1
            [~CATALOG_GROUP_ID_1] => 1
            [CATALOG_GROUP_NAME_1] => Базовая цена
            [~CATALOG_GROUP_NAME_1] => Базовая цена
            [CATALOG_CAN_ACCESS_1] => Y
            [~CATALOG_CAN_ACCESS_1] => Y
            [CATALOG_CAN_BUY_1] => Y
            [~CATALOG_CAN_BUY_1] => Y
            [CATALOG_PRICE_ID_1] => 57743
            [~CATALOG_PRICE_ID_1] => 57743
            [CATALOG_PRICE_1] => 44700.00
            [~CATALOG_PRICE_1] => 44700.00
            [CATALOG_CURRENCY_1] => RUB
            [~CATALOG_CURRENCY_1] => RUB
            [CATALOG_QUANTITY_FROM_1] => 
            [~CATALOG_QUANTITY_FROM_1] => 
            [CATALOG_QUANTITY_TO_1] => 
            [~CATALOG_QUANTITY_TO_1] => 
            [CATALOG_EXTRA_ID_1] => 
            [~CATALOG_EXTRA_ID_1] => 
            [ID] => 55170
            [~ID] => 55170
            [IBLOCK_ID] => 24
            [~IBLOCK_ID] => 24
            [PROPERTY_85_VALUE] => 48323
            [~PROPERTY_85_VALUE] => 48323
            [PROPERTY_85_VALUE_ID] => 3321757
            [~PROPERTY_85_VALUE_ID] => 3321757
            [PROPERTY_DATE_FROM_VALUE] => 30.07.2018
            [~PROPERTY_DATE_FROM_VALUE] => 30.07.2018
            [PROPERTY_DATE_FROM_VALUE_ID] => 3321764
            [~PROPERTY_DATE_FROM_VALUE_ID] => 3321764
            [NAME] => Oracle Database 12c: Analytic SQL for Data Warehousing
            [~NAME] => Oracle Database 12c: Analytic SQL for Data Warehousing
            [PREVIEW_PICTURE] => 
            [~PREVIEW_PICTURE] => 
            [DETAIL_PICTURE] => 
            [~DETAIL_PICTURE] => 
            [CATALOG_QUANTITY] => 0
            [~CATALOG_QUANTITY] => 0
            [CATALOG_QUANTITY_RESERVED] => 0
            [~CATALOG_QUANTITY_RESERVED] => 0
            [CATALOG_QUANTITY_TRACE] => N
            [~CATALOG_QUANTITY_TRACE] => N
            [CATALOG_QUANTITY_TRACE_ORIG] => D
            [~CATALOG_QUANTITY_TRACE_ORIG] => D
            [CATALOG_CAN_BUY_ZERO] => N
            [~CATALOG_CAN_BUY_ZERO] => N
            [CATALOG_CAN_BUY_ZERO_ORIG] => D
            [~CATALOG_CAN_BUY_ZERO_ORIG] => D
            [CATALOG_NEGATIVE_AMOUNT_TRACE] => N
            [~CATALOG_NEGATIVE_AMOUNT_TRACE] => N
            [CATALOG_NEGATIVE_AMOUNT_ORIG] => D
            [~CATALOG_NEGATIVE_AMOUNT_ORIG] => D
            [CATALOG_SUBSCRIBE] => N
            [~CATALOG_SUBSCRIBE] => N
            [CATALOG_SUBSCRIBE_ORIG] => D
            [~CATALOG_SUBSCRIBE_ORIG] => D
            [CATALOG_AVAILABLE] => Y
            [~CATALOG_AVAILABLE] => Y
            [CATALOG_WEIGHT] => 0
            [~CATALOG_WEIGHT] => 0
            [CATALOG_WIDTH] => 0
            [~CATALOG_WIDTH] => 0
            [CATALOG_LENGTH] => 0
            [~CATALOG_LENGTH] => 0
            [CATALOG_HEIGHT] => 0
            [~CATALOG_HEIGHT] => 0
            [CATALOG_MEASURE] => 
            [~CATALOG_MEASURE] => 
            [CATALOG_VAT] => 
            [~CATALOG_VAT] => 
            [CATALOG_VAT_ID] => 0
            [~CATALOG_VAT_ID] => 0
            [CATALOG_VAT_INCLUDED] => N
            [~CATALOG_VAT_INCLUDED] => N
            [CATALOG_PRICE_TYPE] => S
            [~CATALOG_PRICE_TYPE] => S
            [CATALOG_RECUR_SCHEME_TYPE] => D
            [~CATALOG_RECUR_SCHEME_TYPE] => D
            [CATALOG_RECUR_SCHEME_LENGTH] => 0
            [~CATALOG_RECUR_SCHEME_LENGTH] => 0
            [CATALOG_TRIAL_PRICE_ID] => 
            [~CATALOG_TRIAL_PRICE_ID] => 
            [CATALOG_WITHOUT_ORDER] => N
            [~CATALOG_WITHOUT_ORDER] => N
            [CATALOG_SELECT_BEST_PRICE] => Y
            [~CATALOG_SELECT_BEST_PRICE] => Y
            [CATALOG_PURCHASING_PRICE] => 
            [~CATALOG_PURCHASING_PRICE] => 
            [CATALOG_PURCHASING_CURRENCY] => 
            [~CATALOG_PURCHASING_CURRENCY] => 
            [CATALOG_TYPE] => 4
            [~CATALOG_TYPE] => 4
            [CATALOG_BUNDLE] => N
            [~CATALOG_BUNDLE] => N
            [SORT_HASH] => 2e337e21f0af0ee5f1ddcebacfcc2c95
            [LINK_ELEMENT_ID] => 48323
            [PROPERTIES] => Array
                (
                    [CML2_LINK] => Array
                        (
                            [ID] => 85
                            [IBLOCK_ID] => 24
                            [NAME] => Элемент каталога
                            [ACTIVE] => Y
                            [SORT] => 5
                            [CODE] => CML2_LINK
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => E
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => CML2_LINK
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 25
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => SKU
                            [USER_TYPE_SETTINGS] => Array
                                (
                                    [VIEW] => A
                                    [SHOW_ADD] => N
                                    [MAX_WIDTH] => 0
                                    [MIN_HEIGHT] => 24
                                    [MAX_HEIGHT] => 1000
                                    [BAN_SYM] => ,;
                                    [REP_SYM] =>  
                                    [OTHER_REP_SYM] => 
                                    [IBLOCK_MESS] => N
                                )

                            [HINT] => 
                            [~NAME] => Элемент каталога
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 48323
                            [PROPERTY_VALUE_ID] => 3321757
                            [DESCRIPTION] => 
                            [~VALUE] => 48323
                            [~DESCRIPTION] => 
                        )

                    [CITY] => Array
                        (
                            [ID] => 92
                            [IBLOCK_ID] => 24
                            [NAME] => Город проведения
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => CITY
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => Y
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Город проведения
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => Москва
                            [PROPERTY_VALUE_ID] => 3321766
                            [DESCRIPTION] => 
                            [~VALUE] => Москва
                            [~DESCRIPTION] => 
                        )

                    [MAX_COUNT] => Array
                        (
                            [ID] => 100
                            [IBLOCK_ID] => 24
                            [NAME] => Исходное количество мест
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => MAX_COUNT
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Исходное количество мест
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [DATE_FROM] => Array
                        (
                            [ID] => 101
                            [IBLOCK_ID] => 24
                            [NAME] => Начало курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_FROM
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Начало курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 30.07.2018
                            [PROPERTY_VALUE_ID] => 3321764
                            [DESCRIPTION] => 
                            [~VALUE] => 30.07.2018
                            [~DESCRIPTION] => 
                        )

                    [DATE_TO] => Array
                        (
                            [ID] => 102
                            [IBLOCK_ID] => 24
                            [NAME] => Окончание курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_TO
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Окончание курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 31.07.2018
                            [PROPERTY_VALUE_ID] => 3321765
                            [DESCRIPTION] => 
                            [~VALUE] => 31.07.2018
                            [~DESCRIPTION] => 
                        )

                    [FLAG_SALE] => Array
                        (
                            [ID] => 141
                            [IBLOCK_ID] => 24
                            [NAME] => Скидки
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => FLAG_SALE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Скидки
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                    [IN_ACTION] => Array
                        (
                            [ID] => 142
                            [IBLOCK_ID] => 24
                            [NAME] => Участвует в акциях
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => IN_ACTION
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => E
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => Y
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 30
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => EList
                            [USER_TYPE_SETTINGS] => Array
                                (
                                    [size] => 1
                                    [width] => 0
                                    [group] => N
                                    [multiple] => N
                                )

                            [HINT] => 
                            [~NAME] => Участвует в акциях
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [NEW] => Array
                        (
                            [ID] => 144
                            [IBLOCK_ID] => 24
                            [NAME] => Новинка
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => NEW
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Новинка
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                    [DURATION_HOURS] => Array
                        (
                            [ID] => 174
                            [IBLOCK_ID] => 24
                            [NAME] => Длитеность, часов
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DURATION_HOURS
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Длитеность, часов
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 16
                            [PROPERTY_VALUE_ID] => 3321760
                            [DESCRIPTION] => 
                            [~VALUE] => 16
                            [~DESCRIPTION] => 
                        )

                    [DURATION_DAYS] => Array
                        (
                            [ID] => 175
                            [IBLOCK_ID] => 24
                            [NAME] => Длитеность, дней
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DURATION_DAYS
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Длитеность, дней
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 2
                            [PROPERTY_VALUE_ID] => 3321761
                            [DESCRIPTION] => 
                            [~VALUE] => 2
                            [~DESCRIPTION] => 
                        )

                    [COURSE_CODE] => Array
                        (
                            [ID] => 176
                            [IBLOCK_ID] => 24
                            [NAME] => Код курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => COURSE_CODE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Код курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => O12cSQLWH
                            [PROPERTY_VALUE_ID] => 3321762
                            [DESCRIPTION] => 
                            [~VALUE] => O12cSQLWH
                            [~DESCRIPTION] => 
                        )

                    [ACTION_NUMBER] => Array
                        (
                            [ID] => 177
                            [IBLOCK_ID] => 24
                            [NAME] => Номер акции
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => ACTION_NUMBER
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Номер акции
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [MARKER] => Array
                        (
                            [ID] => 178
                            [IBLOCK_ID] => 24
                            [NAME] => Маркер
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => MARKER
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Маркер
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => Or
                            [PROPERTY_VALUE_ID] => 3321763
                            [DESCRIPTION] => 
                            [~VALUE] => Or
                            [~DESCRIPTION] => 
                        )

                    [HINT] => Array
                        (
                            [ID] => 179
                            [IBLOCK_ID] => 24
                            [NAME] => Примечание
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => HINT
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Примечание
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [B_SPECIAL_PRICE] => Array
                        (
                            [ID] => 180
                            [IBLOCK_ID] => 24
                            [NAME] => B_SPECIAL_PRICE
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => B_SPECIAL_PRICE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => B_SPECIAL_PRICE
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 0
                            [PROPERTY_VALUE_ID] => 3321758
                            [DESCRIPTION] => 
                            [~VALUE] => 0
                            [~DESCRIPTION] => 
                        )

                    [NORMAL_PRICE] => Array
                        (
                            [ID] => 181
                            [IBLOCK_ID] => 24
                            [NAME] => Стандартная цена для 1 чел.
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => NORMAL_PRICE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Стандартная цена для 1 чел.
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 44700
                            [PROPERTY_VALUE_ID] => 3321759
                            [DESCRIPTION] => 
                            [~VALUE] => 44700
                            [~DESCRIPTION] => 
                        )

                    [SECTION_CODE] => Array
                        (
                            [ID] => 186
                            [IBLOCK_ID] => 24
                            [NAME] => Подкатегория курса 4
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => SECTION_CODE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Подкатегория курса 4
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 30
                            [PROPERTY_VALUE_ID] => 3321767
                            [DESCRIPTION] => 
                            [~VALUE] => 30
                            [~DESCRIPTION] => 
                        )

                    [SHOW_TO_MAIN] => Array
                        (
                            [ID] => 189
                            [IBLOCK_ID] => 24
                            [NAME] => Показывать на главной
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => SHOW_TO_MAIN
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Показывать на главной
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                )

            [DISPLAY_PROPERTIES] => Array
                (
                    [DATE_TO] => Array
                        (
                            [ID] => 102
                            [IBLOCK_ID] => 24
                            [NAME] => Окончание курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_TO
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Окончание курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 31.07.2018
                            [PROPERTY_VALUE_ID] => 3321765
                            [DESCRIPTION] => 
                            [~VALUE] => 31.07.2018
                            [~DESCRIPTION] => 
                            [DISPLAY_VALUE] => 31.07.2018
                        )

                )

            [PRODUCT] => Array
                (
                    [TYPE] => 4
                    [AVAILABLE] => Y
                    [MEASURE] => 
                    [VAT_ID] => 
                    [VAT_RATE] => 
                    [VAT_INCLUDED] => N
                    [QUANTITY] => 0
                    [QUANTITY_TRACE] => N
                    [CAN_BUY_ZERO] => N
                    [SUBSCRIPTION] => 
                    [BUNDLE] => N
                )

            [ITEM_PRICE_MODE] => S
            [ITEM_PRICES] => Array
                (
                    [0] => Array
                        (
                            [UNROUND_BASE_PRICE] => 44700
                            [UNROUND_PRICE] => 44700
                            [BASE_PRICE] => 44700
                            [PRICE] => 44700
                            [ID] => 57743
                            [PRICE_TYPE_ID] => 1
                            [CURRENCY] => RUB
                            [DISCOUNT] => 0
                            [PERCENT] => 0
                            [VAT] => 0
                            [QUANTITY_FROM] => 
                            [QUANTITY_TO] => 
                            [QUANTITY_HASH] => ZERO-INF
                            [MEASURE_RATIO_ID] => 
                            [PRINT_BASE_PRICE] => 44 700 руб.
                            [RATIO_BASE_PRICE] => 44700
                            [PRINT_RATIO_BASE_PRICE] => 44 700 руб.
                            [PRINT_PRICE] => 44 700 руб.
                            [RATIO_PRICE] => 44700
                            [PRINT_RATIO_PRICE] => 44 700 руб.
                            [PRINT_DISCOUNT] => 0 руб.
                            [RATIO_DISCOUNT] => 0
                            [PRINT_RATIO_DISCOUNT] => 0 руб.
                            [PRINT_VAT] => 0 руб.
                            [RATIO_VAT] => 0
                            [PRINT_RATIO_VAT] => 0 руб.
                            [MIN_QUANTITY] => 1
                        )

                )

            [ITEM_QUANTITY_RANGES] => Array
                (
                    [ZERO-INF] => Array
                        (
                            [HASH] => ZERO-INF
                            [QUANTITY_FROM] => 
                            [QUANTITY_TO] => 
                            [SORT_FROM] => 0
                            [SORT_TO] => INF
                        )

                )

            [ITEM_MEASURE_RATIOS] => Array
                (
                    [1658] => Array
                        (
                            [ID] => 1658
                            [RATIO] => 1
                            [IS_DEFAULT] => Y
                            [PRODUCT_ID] => 55170
                        )

                )

            [ITEM_MEASURE] => Array
                (
                    [ID] => 
                    [TITLE] => место
                    [~TITLE] => место
                )

            [ITEM_MEASURE_RATIO_SELECTED] => 1658
            [ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF
            [ITEM_PRICE_SELECTED] => 0
            [CHECK_QUANTITY] => 
            [CATALOG_MEASURE_NAME] => место
            [~CATALOG_MEASURE_NAME] => место
            [CAN_BUY] => 1
            [ITEM_PRICES_CAN_BUY] => 1
            [~BUY_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=BUY&id=55170
            [BUY_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=BUY&id=55170
            [~ADD_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=ADD2BASKET&id=55170
            [ADD_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=ADD2BASKET&id=55170
            [~SUBSCRIBE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=SUBSCRIBE_PRODUCT&id=55170
            [SUBSCRIBE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=SUBSCRIBE_PRODUCT&id=55170
            [~COMPARE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=ADD_TO_COMPARE_LIST&id=55170
            [COMPARE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=ADD_TO_COMPARE_LIST&id=55170
            [~COMPARE_DELETE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=DELETE_FROM_COMPARE_LIST&id=55170
            [COMPARE_DELETE_URL] => /courses/O12cSQLWH/?ELEMENT_CODE=O12cSQLWH&action=DELETE_FROM_COMPARE_LIST&id=55170
            [CATALOG_MEASURE_RATIO] => 1
            [OFFER_GROUP] => 
            [RATIO_PRICE] => Array
                (
                    [VALUE] => 44700
                    [DISCOUNT_VALUE] => 44700
                    [PRINT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                    [DISCOUNT_DIFF] => 0
                    [PRINT_DISCOUNT_DIFF] => 0 руб.
                    [DISCOUNT_DIFF_PERCENT] => 0
                    [CURRENCY] => RUB
                )

            [MORE_PHOTO] => Array
                (
                    [0] => Array
                        (
                            [SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png
                            [WIDTH] => 150
                            [HEIGHT] => 150
                        )

                )

            [MORE_PHOTO_COUNT] => 1
        )

)

Курс  обучает концепции иерархического запроса, созданию структурированного отчета, форматированию иерархических данных. Обсуждается использование регулярных выражений для обработки символьной строки.

Обзор курса:

  • Использование SQL с операторами агрегации SQL для функций, используемых для анализа и отчетности
  • Группировка и агрегация данных при помощи операторов ROLLUP и CUBE, функция GROUPING, составные столбцы и сцепленные группировки
  • Анализ данных и отчетность с использованием ранжирующих функций, а также LAG/LEAD . Использование PIVOT и UNPIVOT в запросах.
  • Выполнение выборки данных при помощи MATCH_RECOGNIZE
  • Использование регулярных выражений для обработки символьной строки

    Необходимая предварительная подготовка:

  • Хорошее знание SQL и практические навыки его использования

    Рекомендуемая предварительная подготовка:

  • Практический опыт реализации хранилища данных
  • Oracle Database 12c: Introduction to SQL
  • Oracle Database 12c: Introduction for Experienced SQL Users

  • Цель курса:

  • Группировка и агрегация данных при помощи операторов ROLLUP и CUBE
  • Анализ данных и отчетность с использованием ранжирующих функций, LAG/LEAD,FIRST/LAST
  • Использование предложения MODEL для создания многомерного массива в отчете
  • Использование аналитического SQL для агрегации анализа, отчетности и моделирования данных
  • Интерпретация концепции иерархического запроса, создание структурированного отчета, формат иерархических данных, исключение отдельных узлов и ветвей при обходе дерева
  • Использование регулярных выражений для поиска соответствий и замены в символьных строках. Выполнение pattern matching при помощи предложения MATCH_RECOGNIZE

  • Круг слушателей:

  • Разработчики приложения
  • Разработчики хранилища
  • Инженеры по поддержке
  • Аналитики хранилища
  • Архитекторы базы данных
  • Администраторы базы данных