- Главная
- Курсы
- ORACLE
- Администрирование БД Oracle
- Администрирование БД Oracle 19c
Oracle Database 19c: SQL Tuning Workshop
Даты проведения курса
Array ( [5] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 64004 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 50000 [DISCOUNT_VALUE_NOVAT] => 50000 [ROUND_VALUE_VAT] => 50000 [ROUND_VALUE_NOVAT] => 50000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 50000 [DISCOUNT_VALUE] => 50000 [DISCOUNT_DIFF] => 58000 [DISCOUNT_DIFF_PERCENT] => 54 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 108 000 руб. [PRINT_VALUE_VAT] => 108 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 50 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 50 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [PRINT_DISCOUNT_DIFF] => 58 000 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 64004 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 50000 [DISCOUNT_VALUE_NOVAT] => 50000 [ROUND_VALUE_VAT] => 50000 [ROUND_VALUE_NOVAT] => 50000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 50000 [DISCOUNT_VALUE] => 50000 [DISCOUNT_DIFF] => 58000 [DISCOUNT_DIFF_PERCENT] => 54 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 108 000 руб. [PRINT_VALUE_VAT] => 108 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 50 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 50 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [PRINT_DISCOUNT_DIFF] => 58 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] => 64004 [~CATALOG_PRICE_ID_1] => 64004 [CATALOG_PRICE_1] => 108000.00 [~CATALOG_PRICE_1] => 108000.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] => 61611 [~ID] => 61611 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 60351 [~PROPERTY_85_VALUE] => 60351 [PROPERTY_85_VALUE_ID] => 5134425 [~PROPERTY_85_VALUE_ID] => 5134425 [PROPERTY_DATE_FROM_VALUE] => 22.08.2022 [~PROPERTY_DATE_FROM_VALUE] => 22.08.2022 [PROPERTY_DATE_FROM_VALUE_ID] => 5134432 [~PROPERTY_DATE_FROM_VALUE_ID] => 5134432 [NAME] => Oracle Database 19c: SQL Tuning Workshop [~NAME] => Oracle Database 19c: SQL Tuning 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] => 71ccb2623f895d10decbfff0236d2f56 [LINK_ELEMENT_ID] => 60351 [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] => 60351 [PROPERTY_VALUE_ID] => 5134425 [DESCRIPTION] => [~VALUE] => 60351 [~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] => 5134434 [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] => 22.08.2022 [PROPERTY_VALUE_ID] => 5134432 [DESCRIPTION] => [~VALUE] => 22.08.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] => 24.08.2022 [PROPERTY_VALUE_ID] => 5134433 [DESCRIPTION] => [~VALUE] => 24.08.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] => 24 [PROPERTY_VALUE_ID] => 5134428 [DESCRIPTION] => [~VALUE] => 24 [~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] => 3 [PROPERTY_VALUE_ID] => 5134429 [DESCRIPTION] => [~VALUE] => 3 [~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] => O19cTSQL [PROPERTY_VALUE_ID] => 5134430 [DESCRIPTION] => [~VALUE] => O19cTSQL [~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] => 5134431 [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] => 5134426 [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] => 108000 [PROPERTY_VALUE_ID] => 5134427 [DESCRIPTION] => [~VALUE] => 108000 [~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] => 70 [PROPERTY_VALUE_ID] => 5134435 [DESCRIPTION] => [~VALUE] => 70 [~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] => 24.08.2022 [PROPERTY_VALUE_ID] => 5134433 [DESCRIPTION] => [~VALUE] => 24.08.2022 [~DESCRIPTION] => [DISPLAY_VALUE] => 24.08.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] => 108000 [UNROUND_PRICE] => 50000 [BASE_PRICE] => 108000 [PRICE] => 50000 [ID] => 64004 [PRICE_TYPE_ID] => 1 [CURRENCY] => RUB [DISCOUNT] => 58000 [PERCENT] => 54 [VAT] => 0 [QUANTITY_FROM] => [QUANTITY_TO] => [QUANTITY_HASH] => ZERO-INF [MEASURE_RATIO_ID] => [PRINT_BASE_PRICE] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 50 000 руб. [RATIO_PRICE] => 50000 [PRINT_RATIO_PRICE] => 50 000 руб. [PRINT_DISCOUNT] => 58 000 руб. [RATIO_DISCOUNT] => 58000 [PRINT_RATIO_DISCOUNT] => 58 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/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=BUY&id=61611 [BUY_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=BUY&id=61611 [~ADD_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD2BASKET&id=61611 [ADD_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD2BASKET&id=61611 [~SUBSCRIBE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=SUBSCRIBE_PRODUCT&id=61611 [SUBSCRIBE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=SUBSCRIBE_PRODUCT&id=61611 [~COMPARE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD_TO_COMPARE_LIST&id=61611 [COMPARE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD_TO_COMPARE_LIST&id=61611 [~COMPARE_DELETE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=DELETE_FROM_COMPARE_LIST&id=61611 [COMPARE_DELETE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=DELETE_FROM_COMPARE_LIST&id=61611 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 50000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [DISCOUNT_DIFF] => 58000 [PRINT_DISCOUNT_DIFF] => 58 000 руб. [DISCOUNT_DIFF_PERCENT] => 54 [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 ) [6] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 64005 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 50000 [DISCOUNT_VALUE_NOVAT] => 50000 [ROUND_VALUE_VAT] => 50000 [ROUND_VALUE_NOVAT] => 50000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 50000 [DISCOUNT_VALUE] => 50000 [DISCOUNT_DIFF] => 58000 [DISCOUNT_DIFF_PERCENT] => 54 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 108 000 руб. [PRINT_VALUE_VAT] => 108 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 50 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 50 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [PRINT_DISCOUNT_DIFF] => 58 000 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 64005 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 50000 [DISCOUNT_VALUE_NOVAT] => 50000 [ROUND_VALUE_VAT] => 50000 [ROUND_VALUE_NOVAT] => 50000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 50000 [DISCOUNT_VALUE] => 50000 [DISCOUNT_DIFF] => 58000 [DISCOUNT_DIFF_PERCENT] => 54 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 108 000 руб. [PRINT_VALUE_VAT] => 108 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 50 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 50 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [PRINT_DISCOUNT_DIFF] => 58 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] => 64005 [~CATALOG_PRICE_ID_1] => 64005 [CATALOG_PRICE_1] => 108000.00 [~CATALOG_PRICE_1] => 108000.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] => 61612 [~ID] => 61612 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 60351 [~PROPERTY_85_VALUE] => 60351 [PROPERTY_85_VALUE_ID] => 5134436 [~PROPERTY_85_VALUE_ID] => 5134436 [PROPERTY_DATE_FROM_VALUE] => 19.10.2022 [~PROPERTY_DATE_FROM_VALUE] => 19.10.2022 [PROPERTY_DATE_FROM_VALUE_ID] => 5134443 [~PROPERTY_DATE_FROM_VALUE_ID] => 5134443 [NAME] => Oracle Database 19c: SQL Tuning Workshop [~NAME] => Oracle Database 19c: SQL Tuning 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] => 71ccb2623f895d10decbfff0236d2f56 [LINK_ELEMENT_ID] => 60351 [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] => 60351 [PROPERTY_VALUE_ID] => 5134436 [DESCRIPTION] => [~VALUE] => 60351 [~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] => 5134445 [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.10.2022 [PROPERTY_VALUE_ID] => 5134443 [DESCRIPTION] => [~VALUE] => 19.10.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] => 21.10.2022 [PROPERTY_VALUE_ID] => 5134444 [DESCRIPTION] => [~VALUE] => 21.10.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] => 24 [PROPERTY_VALUE_ID] => 5134439 [DESCRIPTION] => [~VALUE] => 24 [~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] => 3 [PROPERTY_VALUE_ID] => 5134440 [DESCRIPTION] => [~VALUE] => 3 [~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] => O19cTSQL [PROPERTY_VALUE_ID] => 5134441 [DESCRIPTION] => [~VALUE] => O19cTSQL [~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] => 5134442 [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] => 5134437 [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] => 108000 [PROPERTY_VALUE_ID] => 5134438 [DESCRIPTION] => [~VALUE] => 108000 [~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] => 70 [PROPERTY_VALUE_ID] => 5134446 [DESCRIPTION] => [~VALUE] => 70 [~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] => 21.10.2022 [PROPERTY_VALUE_ID] => 5134444 [DESCRIPTION] => [~VALUE] => 21.10.2022 [~DESCRIPTION] => [DISPLAY_VALUE] => 21.10.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] => 108000 [UNROUND_PRICE] => 50000 [BASE_PRICE] => 108000 [PRICE] => 50000 [ID] => 64005 [PRICE_TYPE_ID] => 1 [CURRENCY] => RUB [DISCOUNT] => 58000 [PERCENT] => 54 [VAT] => 0 [QUANTITY_FROM] => [QUANTITY_TO] => [QUANTITY_HASH] => ZERO-INF [MEASURE_RATIO_ID] => [PRINT_BASE_PRICE] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 50 000 руб. [RATIO_PRICE] => 50000 [PRINT_RATIO_PRICE] => 50 000 руб. [PRINT_DISCOUNT] => 58 000 руб. [RATIO_DISCOUNT] => 58000 [PRINT_RATIO_DISCOUNT] => 58 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/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=BUY&id=61612 [BUY_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=BUY&id=61612 [~ADD_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD2BASKET&id=61612 [ADD_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD2BASKET&id=61612 [~SUBSCRIBE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=SUBSCRIBE_PRODUCT&id=61612 [SUBSCRIBE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=SUBSCRIBE_PRODUCT&id=61612 [~COMPARE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD_TO_COMPARE_LIST&id=61612 [COMPARE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=ADD_TO_COMPARE_LIST&id=61612 [~COMPARE_DELETE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=DELETE_FROM_COMPARE_LIST&id=61612 [COMPARE_DELETE_URL] => /courses/O19cTSQL/?ELEMENT_CODE=O19cTSQL&action=DELETE_FROM_COMPARE_LIST&id=61612 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 50000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 50 000 руб. [DISCOUNT_DIFF] => 58000 [PRINT_DISCOUNT_DIFF] => 58 000 руб. [DISCOUNT_DIFF_PERCENT] => 54 [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 ) )
- 22.08.2022 Москва записаться
- 19.10.2022 Москва записаться
Курс Oracle SQL Tuning for Developers Workshop поможет вам изучить, как настраиваются планы выполнения операторов Oracle SQL.
Вы узнаете, как сразу писать хорошо настроенные SQL-операторы, полностью подходящие для СУБД Oracle.
Развиваемые и закрепляемые навыки:
Предварительная подготовка:
1. Введение в курс.
Семинар 1: Повышение производительности оператора SQL-запроса.
2. Введение в SQL Tuning.
Быстрая стратегия настройки SQL. Семинар 2: Обзор этапов выполнения инструкции SQL. Практика 2-1: Использование SQL Developer.
3. Использование инструментов трассировки приложений.
Утилита Trcsess. Семинар 3: Как учиться настраивать операцию сортировки с помощью индекса в предложениях ORDER BY. Практика 3-1: Отслеживание приложений (Часть 01). Практика 3-1: Отслеживание приложений (Часть 02).
4. Основы оптимизатора.
Основы оптимизатора. Оценка запросов: селективность и мощность. Генератор планов. Семинар 4: Идентификация и настройка плохо написанного SQL-оператора. Практика 4-1: Понимание решений оптимизатора (Необязательно).
5. Генерация и отображение планов выполнения.
Автотрассировка. Автоматическое хранилище рабочей нагрузки. Семинар 5: Эффекты изменения порядка столбцов в составном индексе. Практика 5-1: Извлечение плана выполнения с помощью SQL Developer. Практика 5-2: Извлечение планов выполнения.
6. Интерпретация планов выполнения и совершенствование кода.
Семинар-6: Использование информации в файле 10053 для настройки SQL-оператора. Практика 6-1: Использование динамических планов.
7. Оптимизатор: Пути использования таблиц и индексов.
Индексы: Обзор. Bitmap Индексы. Общие возможности. Семинар 7: Понимание того, какие решения принимает оптимизатор. Практика 7-1: Использование различных конструкций запроса (Часть 01). Практика 7-1: Использование различных конструкций запроса (Часть 02). Практика 7-1: Использование различных конструкций запроса (Часть 03). Практика 7-1: Использование различных конструкций запроса (Часть 04).
8. Оптимизатор: Операторы соединения.
Семинар 8: Стратегия настройки. Практика 8: Использование соединений.
9. Другие операции оптимизатора.
Семинар 9: Использование базового плана SQL для создания лучшего плана исполнения. Практика 9-1: Использование кэша результатов. Практика 9-2: Использование других вариантов конструкции запроса (Необязательно).
10. Введение в концепцию оптимизационной статистики.
Статистика: Гистограммы. Статистика по конкретным сеансам для глобальных временных таблиц. Практика 10-1: Фактор кластеризации индексов. Практика 10-2: Создание статистики выражений. Практика 10-3: Включение автоматического сбора статистики (необязательно) (Часть 01). Практика 10-3: Включение автоматического сбора статистики (необязательно) (Часть 02). Практика 10-4: Использование системной статистики (необязательно).
11. Использование Bind переменных.
Совершенствование совместного использования курсоров. Практика 11-1: Использование адаптивного совместного использования курсоров. Практика 11-2: Использование CURSOR_SHARING (необязательно).
12. Управление планами выполнения SQL запросов.
Настройка управления планами запросов SQL. Возможные сценарии управляемости SQL-планом. Практика 12-1: Использование SQL Plan Management SPM (часть 01). Практика 12-1: Использование SQL Plan Management SPM (Часть 02).
13. Семинар.