- Главная
- Курсы
- ORACLE
- Курсы Oracle
- Администрирование БД Oracle
- Администрирование БД Oracle 12c
Oracle Database 12c R2: New Features for Administrators Part 2
Даты проведения курса
Array
(
[3] => Array
(
[PRICES] => Array
(
[BASE] => Array
(
[PRICE_ID] => 1
[ID] => 64603
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 140000
[VALUE_NOVAT] => 140000
[DISCOUNT_VALUE_VAT] => 70000
[DISCOUNT_VALUE_NOVAT] => 70000
[ROUND_VALUE_VAT] => 70000
[ROUND_VALUE_NOVAT] => 70000
[VALUE] => 140000
[UNROUND_DISCOUNT_VALUE] => 70000
[DISCOUNT_VALUE] => 70000
[DISCOUNT_DIFF] => 70000
[DISCOUNT_DIFF_PERCENT] => 50
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 140 000 руб.
[PRINT_VALUE_VAT] => 140 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 70 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 70 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 140 000 руб.
[PRINT_DISCOUNT_VALUE] => 70 000 руб.
[PRINT_DISCOUNT_DIFF] => 70 000 руб.
)
)
[PRICE_MATRIX] =>
[MIN_PRICE] => Array
(
[PRICE_ID] => 1
[ID] => 64603
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 140000
[VALUE_NOVAT] => 140000
[DISCOUNT_VALUE_VAT] => 70000
[DISCOUNT_VALUE_NOVAT] => 70000
[ROUND_VALUE_VAT] => 70000
[ROUND_VALUE_NOVAT] => 70000
[VALUE] => 140000
[UNROUND_DISCOUNT_VALUE] => 70000
[DISCOUNT_VALUE] => 70000
[DISCOUNT_DIFF] => 70000
[DISCOUNT_DIFF_PERCENT] => 50
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 140 000 руб.
[PRINT_VALUE_VAT] => 140 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 70 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 70 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 140 000 руб.
[PRINT_DISCOUNT_VALUE] => 70 000 руб.
[PRINT_DISCOUNT_DIFF] => 70 000 руб.
)
[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] => 64603
[~CATALOG_PRICE_ID_1] => 64603
[CATALOG_PRICE_1] => 140000.00
[~CATALOG_PRICE_1] => 140000.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] => 62237
[~ID] => 62237
[IBLOCK_ID] => 24
[~IBLOCK_ID] => 24
[PROPERTY_85_VALUE] => 54925
[~PROPERTY_85_VALUE] => 54925
[PROPERTY_85_VALUE_ID] => 5330429
[~PROPERTY_85_VALUE_ID] => 5330429
[PROPERTY_DATE_FROM_VALUE] => 19.12.2022
[~PROPERTY_DATE_FROM_VALUE] => 19.12.2022
[PROPERTY_DATE_FROM_VALUE_ID] => 5330436
[~PROPERTY_DATE_FROM_VALUE_ID] => 5330436
[NAME] => Oracle Database 12c R2: New Features for Administrators Part 2
[~NAME] => Oracle Database 12c R2: New Features for Administrators Part 2
[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] =>
[~CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[~CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[~CATALOG_HEIGHT] =>
[CATALOG_MEASURE] =>
[~CATALOG_MEASURE] =>
[CATALOG_VAT] =>
[~CATALOG_VAT] =>
[CATALOG_VAT_ID] =>
[~CATALOG_VAT_ID] =>
[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] =>
[~CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_TRIAL_PRICE_ID] =>
[~CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[~CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[~CATALOG_SELECT_BEST_PRICE] => N
[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] => 1130a596740b7ee5a8d6ceb80363e4d2
[LINK_ELEMENT_ID] => 54925
[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] => 54925
[PROPERTY_VALUE_ID] => 5330429
[DESCRIPTION] =>
[~VALUE] => 54925
[~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] => 5330438
[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] => 19.12.2022
[PROPERTY_VALUE_ID] => 5330436
[DESCRIPTION] =>
[~VALUE] => 19.12.2022
[~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] => 23.12.2022
[PROPERTY_VALUE_ID] => 5330437
[DESCRIPTION] =>
[~VALUE] => 23.12.2022
[~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] => 40
[PROPERTY_VALUE_ID] => 5330432
[DESCRIPTION] =>
[~VALUE] => 40
[~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] => 5
[PROPERTY_VALUE_ID] => 5330433
[DESCRIPTION] =>
[~VALUE] => 5
[~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] => O12cNFA_2
[PROPERTY_VALUE_ID] => 5330434
[DESCRIPTION] =>
[~VALUE] => O12cNFA_2
[~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] => 5330435
[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] => 5330430
[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] => 140000
[PROPERTY_VALUE_ID] => 5330431
[DESCRIPTION] =>
[~VALUE] => 140000
[~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] => 100
[PROPERTY_VALUE_ID] => 5330439
[DESCRIPTION] =>
[~VALUE] => 100
[~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] => 23.12.2022
[PROPERTY_VALUE_ID] => 5330437
[DESCRIPTION] =>
[~VALUE] => 23.12.2022
[~DESCRIPTION] =>
[DISPLAY_VALUE] => 23.12.2022
)
)
[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] => 140000
[UNROUND_PRICE] => 70000
[BASE_PRICE] => 140000
[PRICE] => 70000
[ID] => 64603
[PRICE_TYPE_ID] => 1
[CURRENCY] => RUB
[DISCOUNT] => 70000
[PERCENT] => 50
[VAT] => 0
[QUANTITY_FROM] =>
[QUANTITY_TO] =>
[QUANTITY_HASH] => ZERO-INF
[MEASURE_RATIO_ID] =>
[PRINT_BASE_PRICE] => 140 000 руб.
[RATIO_BASE_PRICE] => 140000
[PRINT_RATIO_BASE_PRICE] => 140 000 руб.
[PRINT_PRICE] => 70 000 руб.
[RATIO_PRICE] => 70000
[PRINT_RATIO_PRICE] => 70 000 руб.
[PRINT_DISCOUNT] => 70 000 руб.
[RATIO_DISCOUNT] => 70000
[PRINT_RATIO_DISCOUNT] => 70 000 руб.
[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
(
[0] => Array
(
[ID] => 0
[RATIO] => 1
[IS_DEFAULT] => Y
)
)
[ITEM_MEASURE] => Array
(
[ID] =>
[TITLE] => место
[~TITLE] => место
)
[ITEM_MEASURE_RATIO_SELECTED] => 0
[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/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=BUY&id=62237
[BUY_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=BUY&id=62237
[~ADD_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=ADD2BASKET&id=62237
[ADD_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=ADD2BASKET&id=62237
[~SUBSCRIBE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=SUBSCRIBE_PRODUCT&id=62237
[SUBSCRIBE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=SUBSCRIBE_PRODUCT&id=62237
[~COMPARE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=ADD_TO_COMPARE_LIST&id=62237
[COMPARE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=ADD_TO_COMPARE_LIST&id=62237
[~COMPARE_DELETE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=DELETE_FROM_COMPARE_LIST&id=62237
[COMPARE_DELETE_URL] => /courses/O12cNFA_2/?ELEMENT_CODE=O12cNFA_2&action=DELETE_FROM_COMPARE_LIST&id=62237
[CATALOG_MEASURE_RATIO] => 1
[OFFER_GROUP] =>
[RATIO_PRICE] => Array
(
[VALUE] => 140000
[DISCOUNT_VALUE] => 70000
[PRINT_VALUE] => 140 000 руб.
[PRINT_DISCOUNT_VALUE] => 70 000 руб.
[DISCOUNT_DIFF] => 70000
[PRINT_DISCOUNT_DIFF] => 70 000 руб.
[DISCOUNT_DIFF_PERCENT] => 50
[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
)
)
- 19.12.2022 Москва записаться
Курс состоит из 5 модулей: «Обеспечение безопасности данных», «Обеспечение доступности данных», «Партиционирование данных», «Управление информационным жизненным циклом», а также «Мониторинг DB операций и управление производительностью».
Слушатели получают хорошие знания о новых и расширенных возможностях Oracle Database 12c Release 2 в таких областях администрирования, как Unified Auditing, Transparent Data Encryption (TDE) и в других вопросах безопасности, Recovery Manager, online операций, Oracle Data Pump, SQL*Loader, новых методов партиционирования, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching и Automatic Big Table Caching.
Слушатели обучаются:
Новым и расширенным возможностям Oracle Database 12c Release 2 (12.2.0.1) в таких областях, как безопасность, доступность, партиционирование, производительность и and Information Lifecycle Management (ILM).
Достоинства курса
Слушатели получают хорошие знания по различным вопросам:
Необходимая предварительная подготовка
Предполагаемая предварительная подготовка
Цель курса:
Аудитория курса:
Введение
Общие задачи курса. Группировка уроков по модулям. Расписание на неделю.
Аудит с помощью Unified Audit
Беглый обзор реализации 11g R2 audit trail. Обзор Unified Audit Trail. Создание и обеспечение политики аудита для всех пользователей, которым роль выдается непосредственно. Захват VPD (Virtual Private Database) генерируемых предикатов.
Управление доступом к данным с помощью привилегий и профилей
Новые административные привилегии в 12.2. Расширения для файла паролей. Расширения безопасности административных пользователей. Обеспечение соблюдения ограничений на пароли профилей. Использование обязательной привилегии INHERIT PRIVILEGES для выполнения процедуры с правами вызывающего. Использование обязательной привилегии INHERIT PRIVILEGES для осуществления выборки из BEQUEATH представлений текущего пользователя. Использование новой привилегии INHERIT (ANY) REMOTE PRIVILEGES.
Управление безопасностью с помощью Privilege Analysis
Обзор of database privilege analysis. Granting the CAPTURE_ADMIN role to enable management of privilege captures. Creating and starting/stopping privilege captures and runs. Viewing privilege analysis result. Querying DBA_PRIV_CAPTURES.
Редактирование данных
Обзор of Oracle Data Redaction. Types of Data Redaction Policies. New redaction format library in EM GUI. Redaction policy expression. Redacting with Nullify redaction function.
Шифрование данных
Шифрование / дешифровка / rekey табличных пространств online. Конфигурирование автоматического шифрования табличного пространства.
Управление безопасностью с помощью Transparent Sensitive Data Protection
Конфигурирование и применение TSDP с помощью VPD. Конфигурирование и применение TSDP с помощью Data Redaction. Конфигурирование и применение TSDP с помощью Unified Auditing. Конфигурирование и применение TSDP с помощью Fine-Grained Auditing (FGA). Конфигурирование и применение TSDP с помощью Transparent Data Encryption (TDE).
Обеспечение доступности данных с помощью RMAN
Расширения RMAN. Передача данных между платформами. Восстановление таблиц. Автоматизация процесса ручного восстановления с помощью Recover Database Until Available Redo. Расширенная команда REPAIR FAILURE.
Обеспечение доступности данных с помощью Oracle Data Pump, SQL*Loader и внешних таблиц
Расширения Oracle Data Pump. Расширения SQL*Loader. Запросы к внешним таблицам и переписывание предложений внешних таблиц.
Обеспечение доступности данных с помощью Online операций
Поддержка онлайн переопределения. Перемещение и сжатие табличных партиций ONLINE.
Партиционирование данных
Включение reference partitioning с помощью interval partitioned parent tables. Учет опции CASCADE для операций TRUNCATE PARTITION и EXCHANGE [SUB]PARTITION. Преобразования партиционирования Range в Interval и наоборот. Преобразования субпартиционирования Range в Interval и наоборот. Упрощение сопровождения (суб) партиционированных таблиц. Сложное партиционирование.
Управление информационным жизненным циклом с помощью ADO
Классификация данных в 12c: уровни табличного пространства, группы, объекта, строки. Конфигурирование heat map. Автоматическое перемещение и сжатие. Уровни и типы сжатия. Объявление политики. Настраиваемое автоматическое выполнение действий с помощью пользовательских функций. Выполнение в scheduled maintenance windows и с помощью MMON. Настройка расписания с помощью пакета DBMS_ILM.
Управление жизненным циклом с использованием возможностей In-Database Archiving and Temporal
Проблемы старых данных в таблицах и их решения в 11g. Новые решения для In-database архивирования. Использование ROW ARCHIVAL предложения для включения состояния жизненного цикла строки для приложений. Установка ROW ARCHIVAL VISIBILITY для управления session level visibility. Использование предиката на ORA_ARCHIVE_STATE столбец. Temporal Validity vs. Temporal History (Transaction Time of FDA). Установка Temporal Validity с помощью PERIOD FOR предложения CREATE / ALTER TABLE. Новый SQL Temporal тип данных.
Мониторинг DB операций и производительности
Обзор. Варианты. Имеющиеся средства. Определение DB операции. Мониторинг: Bracketing операции. Мониторинг выполнения операции. Тюнинг DB Operation. DB Operation Active Report.
Конфигурирование In-Memory Column Store
Задачи и достоинства In-Memory Database. Формат строк и формат столбцов. Новая SGA компонента. Развертывание. Сжатие и priority in-memory атрибуты сегментов. Таблицы словаря, добавленные столбцы, IM статистики и IM Advisor. IM FastStart. Взаимодействие с другими продуктами.
Использование In-Memory Column Store
Кэширование результатов часто вычисляемых выражений и виртуальных столбцов. Оптимизация соединений столбцов путем создания групп соединений.
Повышение производительности с помощью In-Memory Caching
Настойка Full Database In-Memory Caching. Два алгоритма замены буфера для Automatic Big Table Caching.Конфигурирование Automatic Big Table Caching с помощью инициализационного параметра B_BIG_TABLE_CACHE_PERCENT_TARGET. Использование Automatic Big Table Caching.
Повышение производительности SQL
Улучшение производительности сбора статистики: Optimizer Statistics Advisor. Адаптивный план выполнения. Преимущества автоматического динамического сэмплинга.
Использование расширений Real Application Testing
Расширения SQL Performance Analyzer. Расширения SQL Plan Management. Расширения Database Replay.
Повышение производительности с помощью других возможностей
Управление ограничениями PGA сеанса. Множественные индексы над одним и тем же наборов столбцов. Описание уровня HIGH для Advanced Row Compression и Avanced Index Compression. Reduce Cursor Invalidations для DDLs. Определение материализованных представлений реального времени с помощью вычислений при выполнении запросов и ON STATEMENT обновления материализованных представлений. Использование многопроцессной многопоточной Oracle архитектуры. Расширения Database Smart Flash Cache. Использование временного undo для ваших временных таблиц.