- Главная
- Курсы
- ORACLE
- Администрирование БД Oracle
- Администрирование БД Oracle 12c
Oracle Database 12c R2: Administration Workshop
Даты проведения курса
Array
(
[3] => Array
(
[PRICES] => Array
(
[BASE] => Array
(
[PRICE_ID] => 1
[ID] => 61708
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 111750
[VALUE_NOVAT] => 111750
[DISCOUNT_VALUE_VAT] => 111750
[DISCOUNT_VALUE_NOVAT] => 111750
[ROUND_VALUE_VAT] => 111750
[ROUND_VALUE_NOVAT] => 111750
[VALUE] => 111750
[UNROUND_DISCOUNT_VALUE] => 111750
[DISCOUNT_VALUE] => 111750
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 111 750 руб.
[PRINT_VALUE_VAT] => 111 750 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 111 750 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 111 750 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 111 750 руб.
[PRINT_DISCOUNT_VALUE] => 111 750 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
)
[PRICE_MATRIX] =>
[MIN_PRICE] => Array
(
[PRICE_ID] => 1
[ID] => 61708
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 111750
[VALUE_NOVAT] => 111750
[DISCOUNT_VALUE_VAT] => 111750
[DISCOUNT_VALUE_NOVAT] => 111750
[ROUND_VALUE_VAT] => 111750
[ROUND_VALUE_NOVAT] => 111750
[VALUE] => 111750
[UNROUND_DISCOUNT_VALUE] => 111750
[DISCOUNT_VALUE] => 111750
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 111 750 руб.
[PRINT_VALUE_VAT] => 111 750 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 111 750 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 111 750 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 111 750 руб.
[PRINT_DISCOUNT_VALUE] => 111 750 руб.
[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] => 61708
[~CATALOG_PRICE_ID_1] => 61708
[CATALOG_PRICE_1] => 111750.00
[~CATALOG_PRICE_1] => 111750.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] => 59182
[~ID] => 59182
[IBLOCK_ID] => 24
[~IBLOCK_ID] => 24
[PROPERTY_85_VALUE] => 48246
[~PROPERTY_85_VALUE] => 48246
[PROPERTY_85_VALUE_ID] => 4585059
[~PROPERTY_85_VALUE_ID] => 4585059
[PROPERTY_DATE_FROM_VALUE] => 07.12.2020
[~PROPERTY_DATE_FROM_VALUE] => 07.12.2020
[PROPERTY_DATE_FROM_VALUE_ID] => 4585066
[~PROPERTY_DATE_FROM_VALUE_ID] => 4585066
[NAME] => Oracle Database 12c R2: Administration Workshop
[~NAME] => Oracle Database 12c R2: Administration Workshop
[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] => c5fd62b8f8e4db7721cbbfda1d18ce6c
[LINK_ELEMENT_ID] => 48246
[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] => 48246
[PROPERTY_VALUE_ID] => 4585059
[DESCRIPTION] =>
[~VALUE] => 48246
[~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] => 4585068
[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] => 07.12.2020
[PROPERTY_VALUE_ID] => 4585066
[DESCRIPTION] =>
[~VALUE] => 07.12.2020
[~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] => 11.12.2020
[PROPERTY_VALUE_ID] => 4585067
[DESCRIPTION] =>
[~VALUE] => 11.12.2020
[~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] => 4585062
[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] => 4585063
[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] => O12cDBA
[PROPERTY_VALUE_ID] => 4585064
[DESCRIPTION] =>
[~VALUE] => O12cDBA
[~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] => 4585065
[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] => 4585060
[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] => 111750
[PROPERTY_VALUE_ID] => 4585061
[DESCRIPTION] =>
[~VALUE] => 111750
[~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] => 50
[PROPERTY_VALUE_ID] => 4585069
[DESCRIPTION] =>
[~VALUE] => 50
[~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] => 11.12.2020
[PROPERTY_VALUE_ID] => 4585067
[DESCRIPTION] =>
[~VALUE] => 11.12.2020
[~DESCRIPTION] =>
[DISPLAY_VALUE] => 11.12.2020
)
)
[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] => 111750
[UNROUND_PRICE] => 111750
[BASE_PRICE] => 111750
[PRICE] => 111750
[ID] => 61708
[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] => 111 750 руб.
[RATIO_BASE_PRICE] => 111750
[PRINT_RATIO_BASE_PRICE] => 111 750 руб.
[PRINT_PRICE] => 111 750 руб.
[RATIO_PRICE] => 111750
[PRINT_RATIO_PRICE] => 111 750 руб.
[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
(
[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/O12cDBA/?ELEMENT_CODE=O12cDBA&action=BUY&id=59182
[BUY_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=BUY&id=59182
[~ADD_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=ADD2BASKET&id=59182
[ADD_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=ADD2BASKET&id=59182
[~SUBSCRIBE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=SUBSCRIBE_PRODUCT&id=59182
[SUBSCRIBE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=SUBSCRIBE_PRODUCT&id=59182
[~COMPARE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=ADD_TO_COMPARE_LIST&id=59182
[COMPARE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=ADD_TO_COMPARE_LIST&id=59182
[~COMPARE_DELETE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=DELETE_FROM_COMPARE_LIST&id=59182
[COMPARE_DELETE_URL] => /courses/O12cDBA/?ELEMENT_CODE=O12cDBA&action=DELETE_FROM_COMPARE_LIST&id=59182
[CATALOG_MEASURE_RATIO] => 1
[OFFER_GROUP] =>
[RATIO_PRICE] => Array
(
[VALUE] => 111750
[DISCOUNT_VALUE] => 111750
[PRINT_VALUE] => 111 750 руб.
[PRINT_DISCOUNT_VALUE] => 111 750 руб.
[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
)
)
- 07.12.2020 Москва записаться
Данный курс создает надежный фундамент в администрировании базы данных Oracle. Курс обеспечивает концептуальное понимание архитектуры базы данных Oracle и навыки эффективного управления базой данных Oracle.
Слушатели обучаются:
Достоинства курса
Слушатели получают подробную информацию об архитектуре базы данных и экземпляра базы данных Oracle, что позволит им эффективно управлять ресурсами базы данных. Слушатели узнают, как создавать структуры хранения в базе данных, подходящие для бизнес-приложений, поддерживаемых базой данных. Кроме того, слушатели Обучаются созданию пользователей и управлению безопасностью базы данных для обеспечения требований бизнеса. Рассматриваются также основы техники резервного копирования и восстановления information.
Для обеспечения приемлемого времени отклика для пользователей и эффективного управления ресурсами рассмотрены вопросы мониторинга базы данных и управления производительностью.
Необходимая предварительная подготовка
Предполагаемая предварительная подготовка
Цель курса:
Аудитория курса:
Первое знакомство
Цели курса.
Исследование архитектуры базы данных Oracle
Введение в базу данных Oracle. Модели реляционных баз данных. Oracle SQL и PL/SQL. Архитектура сервера базы данных Oracle. Подключение к базам данных Oracle. Средства базы данных Oracle. Учетные записи пользователей, предоставляемые Oracle. Запрос к словарю данных Oracle.
Управление экземплярами базы данных
Файлы инициализационных параметров. Запуск баз данных Oracle. Остановка баз данных Oracle. Открытие и закрытие PDBs. Работа с Automatic Diagnostic Repository (ADR). Запросы к динамическим представлениям производительности.
Создание PDBs
Методы и средства создания PDBs. Создание PDBs из Seed с помощью SQL*Plus. Клонирование PDBs с помощью SQL*Plus. Unplugging и Pluggin In PDBs с помощью SQL*Plus. Удаление PDBs с помощью SQL*Plus.
Конфигурирование сетевого окружения Oracle
Oracle Net Services. Как работает Listener. Конфигурирование Listeners для динамической регистрации сервиса.Конфигурирование Listeners для статической регистрации сервиса. Конфигурирование Local Naming для подключений. Тестирование Oracle Net Connectivity с помощью tnsping. Конфигурирование коммуникации между базами данных. Сравнение конфигураций выделенного и разделяемого сервера.
Управление безопасностью пользователей
Создание пользователей. Предоставление привилегий. Создание и предоставление ролей. Отзыв привилегий и ролей. Создание и приписывание профилей. Аутентификация пользователей. Предоставление квот пользователям. Применение Principal of Least Privilege.
Создание табличных пространств и управление ими
Как хранятся данные таблицы. Создание табличных пространств в SQL*Plus. Изменение и удаление табличных пространств в SQL*Plus. Просмотр информации о табличных пространствах в SQL*Plus. Реализация файлов, управляемых Oracle. Перемещение и переименование Online файлов данных в SQL*Plus.
Управление пространством хранения
Особенности управления пространством базы данных Oracle. Управление пространством блоков. Соединение строк в цепочки и миграция. Управление свободным пространством внутри сегментов. Типы сегментов. Аллокация экстентов. Представление об отложенном (Deferred) создании сегмента. Возможности сохранения пространства.
Управление UNDO данными
Undo данные: обзор. Транзакции и Undo данные. Хранение Undo информации. Сравнение Undo и Redo данных. Управление Undo. Сравнение локальной и разделяемой Undo мод. Конфигурирование Undo Retension. Категории Undo.
Перемещение данных
Перемещение данных: общая архитектура. Oracle Data Pump: обзор. Oracle Data Pump: достоинства. Data Pump Export и Import клиенты. Data Pump утилита: интерфейсы и моды. Data Pump Import: преобразования. Обзор SQL*Loader. Методы загрузки.
Концепции резервного копирования и восстановления
Обязанности DBA. Категории сбоев. Что такое восстановление экземпляра. Типы резервного копирования. Сравнение полного и неполного восстановления. Oracle решения для защиты данных. Flashback технология.
Мониторинг и тюнинг производительности базы данных
Управление активностями производительности. Планирование производительности. Сопровождение базы данных. Automatic Workload Repository (AWR). Automatic Database Diagnostic Monitor. Мониторинг производительности. Методология настройки производительности. Статистики и метрики сервера базы данных.
SQL тюнинг
Процесс SQL тюнинга. Оптимизатор Oracle. Статистики оптимизатора. Директивы SQL плана. Адаптивные планы выполнения. SQL Tuning Advisor. SQL Access Advisor. SQL Performance Analyzer.
Oracle Database Resource Manager
Oracle Database Resource Manager: обзор. Элементы Resource Manager. Использование Resource Manager для аллокации ресурсов. Создание простого ресурсного плана. Создание сложного ресурсного плана. Использование Active Session Pool. Ограничение потребления CPU на уровне базы данных. Ограничение потребления CPU на уровне сервера.
Enterprise Manager Cloud Control
Управление Enterprise Manager Cloud Control Framework. Запуск Enterprise Manager Cloud Control Framework. Остановка Enterprise Manager Cloud Control Framework.
Введение в Oracle Database Cloud Service
Oracle Cloud: обзор. Предложения Database Cloud Service. Архитектура DBCS. Возможности и средства. Дополнительные конфигурационные опции базы данных.
Создание развертываний DBCS базы данных
Автоматизация Database Provisioning. Создание развертывания базы данных. Использование SSH Key Pairs. Создание SSH Key Pair. Хранилище для файлов базы данных.
Управление развертыванием DBCS базы данных
Облачные средства. Доступ к средствам и настройкам из DBCS консоли. Управление Compute Node, связанным с развертыванием базы данных. Управление сетевым доступом к DBCS. Обеспечение доступа к порту Compute Node. Масштабирование развертывания базы данных.
Резервное копирование и восстановление развертывания DBCS базы данных
Резервное копирование и развертывание баз данных на DBCS. Резервное копирование Destination Choices. Резервное копирование конфигурации. Создание резервной копии по требованию. Настройка конфигурации резервного копирования. Осуществление восстановления Recovery с помощью консоли. Осуществление восстановления с помощью утилиты dbaascli.
Пэтчинг развертываний DBCS базы данных
Пэтчинг DBCS. Использование DBCS консоли для управления пэтчами. Использование утилиты dbaascli для управления пэтчами.
Создание мастер-ключей шифрования для PDBs
Мастер-ключи шифрования для CDB и PDB. Определение необходимости создания и активации ключа шифрования для PDB. Создание и активация ключа шифрования.
Шифрование табличного пространства по умолчанию
Шифрование табличного пространства по умолчанию в DBCS. Обзор прозрачного шифрования данных (TDE). Компоненты TDE. Применение TDE. Определение местоположения хранилища ключей. Управление шифрованием табличного пространства по умолчанию. Управление хранилищем ключей и мастер-ключом шифрования программного обеспечения. Управление хранилищем ключей в CDBs и PDBs.