- Главная
- Курсы
- ORACLE
- Базовые курсы Oracle
- Базовые курсы Oracle 12c
Oracle Database 12c R2: SQL Workshop I
Даты проведения курса
Array ( [1] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 62321 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 62321 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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] => 62321 [~CATALOG_PRICE_ID_1] => 62321 [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] => 59835 [~ID] => 59835 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 48231 [~PROPERTY_85_VALUE] => 48231 [PROPERTY_85_VALUE_ID] => 4816999 [~PROPERTY_85_VALUE_ID] => 4816999 [PROPERTY_DATE_FROM_VALUE] => 31.05.2021 [~PROPERTY_DATE_FROM_VALUE] => 31.05.2021 [PROPERTY_DATE_FROM_VALUE_ID] => 4817006 [~PROPERTY_DATE_FROM_VALUE_ID] => 4817006 [NAME] => Oracle Database 12c R2: SQL Workshop I [~NAME] => Oracle Database 12c R2: SQL Workshop I [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] => bf49995ed11d20dea65b90b3c57e109c [LINK_ELEMENT_ID] => 48231 [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] => 48231 [PROPERTY_VALUE_ID] => 4816999 [DESCRIPTION] => [~VALUE] => 48231 [~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] => 4817008 [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] => 31.05.2021 [PROPERTY_VALUE_ID] => 4817006 [DESCRIPTION] => [~VALUE] => 31.05.2021 [~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] => 02.06.2021 [PROPERTY_VALUE_ID] => 4817007 [DESCRIPTION] => [~VALUE] => 02.06.2021 [~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] => 4817002 [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] => 4817003 [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] => SQLI [PROPERTY_VALUE_ID] => 4817004 [DESCRIPTION] => [~VALUE] => SQLI [~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] => 4817005 [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] => 4817000 [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] => 4817001 [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] => 20 [PROPERTY_VALUE_ID] => 4817009 [DESCRIPTION] => [~VALUE] => 20 [~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] => 02.06.2021 [PROPERTY_VALUE_ID] => 4817007 [DESCRIPTION] => [~VALUE] => 02.06.2021 [~DESCRIPTION] => [DISPLAY_VALUE] => 02.06.2021 ) ) [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] => 108000 [BASE_PRICE] => 108000 [PRICE] => 108000 [ID] => 62321 [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] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 108 000 руб. [RATIO_PRICE] => 108000 [PRINT_RATIO_PRICE] => 108 000 руб. [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/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59835 [BUY_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59835 [~ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59835 [ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59835 [~SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59835 [SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59835 [~COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59835 [COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59835 [~COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59835 [COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59835 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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 ) [2] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 62322 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 62322 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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] => 62322 [~CATALOG_PRICE_ID_1] => 62322 [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] => 59836 [~ID] => 59836 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 48231 [~PROPERTY_85_VALUE] => 48231 [PROPERTY_85_VALUE_ID] => 4817010 [~PROPERTY_85_VALUE_ID] => 4817010 [PROPERTY_DATE_FROM_VALUE] => 26.07.2021 [~PROPERTY_DATE_FROM_VALUE] => 26.07.2021 [PROPERTY_DATE_FROM_VALUE_ID] => 4817017 [~PROPERTY_DATE_FROM_VALUE_ID] => 4817017 [NAME] => Oracle Database 12c R2: SQL Workshop I [~NAME] => Oracle Database 12c R2: SQL Workshop I [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] => bf49995ed11d20dea65b90b3c57e109c [LINK_ELEMENT_ID] => 48231 [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] => 48231 [PROPERTY_VALUE_ID] => 4817010 [DESCRIPTION] => [~VALUE] => 48231 [~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] => 4817019 [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] => 26.07.2021 [PROPERTY_VALUE_ID] => 4817017 [DESCRIPTION] => [~VALUE] => 26.07.2021 [~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] => 28.07.2021 [PROPERTY_VALUE_ID] => 4817018 [DESCRIPTION] => [~VALUE] => 28.07.2021 [~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] => 4817013 [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] => 4817014 [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] => SQLI [PROPERTY_VALUE_ID] => 4817015 [DESCRIPTION] => [~VALUE] => SQLI [~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] => 4817016 [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] => 4817011 [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] => 4817012 [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] => 20 [PROPERTY_VALUE_ID] => 4817020 [DESCRIPTION] => [~VALUE] => 20 [~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] => 28.07.2021 [PROPERTY_VALUE_ID] => 4817018 [DESCRIPTION] => [~VALUE] => 28.07.2021 [~DESCRIPTION] => [DISPLAY_VALUE] => 28.07.2021 ) ) [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] => 108000 [BASE_PRICE] => 108000 [PRICE] => 108000 [ID] => 62322 [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] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 108 000 руб. [RATIO_PRICE] => 108000 [PRINT_RATIO_PRICE] => 108 000 руб. [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/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59836 [BUY_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59836 [~ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59836 [ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59836 [~SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59836 [SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59836 [~COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59836 [COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59836 [~COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59836 [COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59836 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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 ) [3] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 62323 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 62323 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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] => 62323 [~CATALOG_PRICE_ID_1] => 62323 [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] => 59837 [~ID] => 59837 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 48231 [~PROPERTY_85_VALUE] => 48231 [PROPERTY_85_VALUE_ID] => 4817021 [~PROPERTY_85_VALUE_ID] => 4817021 [PROPERTY_DATE_FROM_VALUE] => 13.09.2021 [~PROPERTY_DATE_FROM_VALUE] => 13.09.2021 [PROPERTY_DATE_FROM_VALUE_ID] => 4817028 [~PROPERTY_DATE_FROM_VALUE_ID] => 4817028 [NAME] => Oracle Database 12c R2: SQL Workshop I [~NAME] => Oracle Database 12c R2: SQL Workshop I [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] => bf49995ed11d20dea65b90b3c57e109c [LINK_ELEMENT_ID] => 48231 [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] => 48231 [PROPERTY_VALUE_ID] => 4817021 [DESCRIPTION] => [~VALUE] => 48231 [~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] => 4817030 [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] => 13.09.2021 [PROPERTY_VALUE_ID] => 4817028 [DESCRIPTION] => [~VALUE] => 13.09.2021 [~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] => 15.09.2021 [PROPERTY_VALUE_ID] => 4817029 [DESCRIPTION] => [~VALUE] => 15.09.2021 [~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] => 4817024 [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] => 4817025 [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] => SQLI [PROPERTY_VALUE_ID] => 4817026 [DESCRIPTION] => [~VALUE] => SQLI [~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] => 4817027 [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] => 4817022 [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] => 4817023 [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] => 20 [PROPERTY_VALUE_ID] => 4817031 [DESCRIPTION] => [~VALUE] => 20 [~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] => 15.09.2021 [PROPERTY_VALUE_ID] => 4817029 [DESCRIPTION] => [~VALUE] => 15.09.2021 [~DESCRIPTION] => [DISPLAY_VALUE] => 15.09.2021 ) ) [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] => 108000 [BASE_PRICE] => 108000 [PRICE] => 108000 [ID] => 62323 [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] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 108 000 руб. [RATIO_PRICE] => 108000 [PRINT_RATIO_PRICE] => 108 000 руб. [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/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59837 [BUY_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59837 [~ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59837 [ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59837 [~SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59837 [SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59837 [~COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59837 [COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59837 [~COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59837 [COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59837 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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 ) [4] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 62324 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 62324 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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] => 62324 [~CATALOG_PRICE_ID_1] => 62324 [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] => 59838 [~ID] => 59838 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 48231 [~PROPERTY_85_VALUE] => 48231 [PROPERTY_85_VALUE_ID] => 4817032 [~PROPERTY_85_VALUE_ID] => 4817032 [PROPERTY_DATE_FROM_VALUE] => 25.10.2021 [~PROPERTY_DATE_FROM_VALUE] => 25.10.2021 [PROPERTY_DATE_FROM_VALUE_ID] => 4817039 [~PROPERTY_DATE_FROM_VALUE_ID] => 4817039 [NAME] => Oracle Database 12c R2: SQL Workshop I [~NAME] => Oracle Database 12c R2: SQL Workshop I [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] => bf49995ed11d20dea65b90b3c57e109c [LINK_ELEMENT_ID] => 48231 [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] => 48231 [PROPERTY_VALUE_ID] => 4817032 [DESCRIPTION] => [~VALUE] => 48231 [~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] => 4817041 [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] => 25.10.2021 [PROPERTY_VALUE_ID] => 4817039 [DESCRIPTION] => [~VALUE] => 25.10.2021 [~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] => 27.10.2021 [PROPERTY_VALUE_ID] => 4817040 [DESCRIPTION] => [~VALUE] => 27.10.2021 [~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] => 4817035 [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] => 4817036 [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] => SQLI [PROPERTY_VALUE_ID] => 4817037 [DESCRIPTION] => [~VALUE] => SQLI [~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] => 4817038 [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] => 4817033 [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] => 4817034 [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] => 20 [PROPERTY_VALUE_ID] => 4817042 [DESCRIPTION] => [~VALUE] => 20 [~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] => 27.10.2021 [PROPERTY_VALUE_ID] => 4817040 [DESCRIPTION] => [~VALUE] => 27.10.2021 [~DESCRIPTION] => [DISPLAY_VALUE] => 27.10.2021 ) ) [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] => 108000 [BASE_PRICE] => 108000 [PRICE] => 108000 [ID] => 62324 [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] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 108 000 руб. [RATIO_PRICE] => 108000 [PRINT_RATIO_PRICE] => 108 000 руб. [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/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59838 [BUY_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59838 [~ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59838 [ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59838 [~SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59838 [SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59838 [~COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59838 [COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59838 [~COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59838 [COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59838 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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 ) [5] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 62325 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 62325 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 108000 [VALUE_NOVAT] => 108000 [DISCOUNT_VALUE_VAT] => 108000 [DISCOUNT_VALUE_NOVAT] => 108000 [ROUND_VALUE_VAT] => 108000 [ROUND_VALUE_NOVAT] => 108000 [VALUE] => 108000 [UNROUND_DISCOUNT_VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [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] => 108 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 108 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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] => 62325 [~CATALOG_PRICE_ID_1] => 62325 [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] => 59839 [~ID] => 59839 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 48231 [~PROPERTY_85_VALUE] => 48231 [PROPERTY_85_VALUE_ID] => 4817043 [~PROPERTY_85_VALUE_ID] => 4817043 [PROPERTY_DATE_FROM_VALUE] => 13.12.2021 [~PROPERTY_DATE_FROM_VALUE] => 13.12.2021 [PROPERTY_DATE_FROM_VALUE_ID] => 4817050 [~PROPERTY_DATE_FROM_VALUE_ID] => 4817050 [NAME] => Oracle Database 12c R2: SQL Workshop I [~NAME] => Oracle Database 12c R2: SQL Workshop I [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] => bf49995ed11d20dea65b90b3c57e109c [LINK_ELEMENT_ID] => 48231 [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] => 48231 [PROPERTY_VALUE_ID] => 4817043 [DESCRIPTION] => [~VALUE] => 48231 [~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] => 4817052 [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] => 13.12.2021 [PROPERTY_VALUE_ID] => 4817050 [DESCRIPTION] => [~VALUE] => 13.12.2021 [~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] => 15.12.2021 [PROPERTY_VALUE_ID] => 4817051 [DESCRIPTION] => [~VALUE] => 15.12.2021 [~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] => 4817046 [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] => 4817047 [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] => SQLI [PROPERTY_VALUE_ID] => 4817048 [DESCRIPTION] => [~VALUE] => SQLI [~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] => 4817049 [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] => 4817044 [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] => 4817045 [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] => 20 [PROPERTY_VALUE_ID] => 4817053 [DESCRIPTION] => [~VALUE] => 20 [~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] => 15.12.2021 [PROPERTY_VALUE_ID] => 4817051 [DESCRIPTION] => [~VALUE] => 15.12.2021 [~DESCRIPTION] => [DISPLAY_VALUE] => 15.12.2021 ) ) [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] => 108000 [BASE_PRICE] => 108000 [PRICE] => 108000 [ID] => 62325 [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] => 108 000 руб. [RATIO_BASE_PRICE] => 108000 [PRINT_RATIO_BASE_PRICE] => 108 000 руб. [PRINT_PRICE] => 108 000 руб. [RATIO_PRICE] => 108000 [PRINT_RATIO_PRICE] => 108 000 руб. [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/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59839 [BUY_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=BUY&id=59839 [~ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59839 [ADD_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD2BASKET&id=59839 [~SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59839 [SUBSCRIBE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=SUBSCRIBE_PRODUCT&id=59839 [~COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59839 [COMPARE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=ADD_TO_COMPARE_LIST&id=59839 [~COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59839 [COMPARE_DELETE_URL] => /courses/SQLI/?ELEMENT_CODE=SQLI&action=DELETE_FROM_COMPARE_LIST&id=59839 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 108000 [DISCOUNT_VALUE] => 108000 [PRINT_VALUE] => 108 000 руб. [PRINT_DISCOUNT_VALUE] => 108 000 руб. [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 ) )
- 31.05.2021 Москва записаться
- 26.07.2021 Москва записаться
- 13.09.2021 Москва записаться
- 25.10.2021 Москва записаться
- 13.12.2021 Москва записаться
Этот курс предлагает введение в технологии Oracle 12c. Изучаются понятия реляционных баз данных и язык программирования SQL. Изучаются команды SQL, которые позволяют писать запросы к одной или нескольким таблицам, манипулировать данными и создавать объекты базы данных.
Слушатели изучат:
Необходимая предварительная подготовка:
Слушатели изучат:
- Команды SQL и реляционную базу данных Oracle.
- Использование SQL Developer.
- Создание отчетов при помощи команд SQL.
- Изменение данных в реляционных таблицах и сохранение изменений.
- Концепции реляционных баз данных и язык программирования SQL.
- Создание отчетов при помощи языка SQL
Необходимая предварительная подготовка:
- Представление о концепциях и методиках обработки данных
- Представление о языках программирования
Круг слушателей:
- Администраторы хранилищ данных
- Разработчики
- Разработчики приложений
- Разработчики PL/SQL
- Разработчики форм
- Системные аналитики
- Бизнес аналитики
Введение
Задачи курса, программа курса, приложения к курсу. Обзор основных возможностей базы данных Oracle 12c и сопутствующих продуктов. Обсуждение основных концепций, а также теоретических и физических аспектов реляционной базы данных. Введение в SQL и средства разработки на нем. Использование SQL Developer. Запуск SQL*Plus из Oracle SQL Developer. Схема Human Resource (HR). Таблицы, используемые в курсе.
Извлечение данных при помощи команды SELECT
Список возможностей команды SELECT. Использование арифметических операторов и неопределенных значений в команде SELECT. Псевдонимы столбцов. Использование оператора конкатенации, строк-литералов, альтернативного оператора цитирования и предложения DISTINCT. Использование команды DESCRIBE для вывода структуры таблицы.
Ограничение и сортировка данных
Использование предложения WHERE для выборки необходимых строк. Использование операторов сравнения и логических операторов в предложении WHERE. Переменные подстановки. Использование команд DEFINE и VERIFY.
Использование однострочных функций
Демонстрация различий между однострочными и многострочными функциями SQL. Преобразование строк при помощи символьных функций, используемых в списке SELECT и предложении WHERE. Преобразование чисел при помощи функций ROUND, TRUNC и MOD. Арифметические операции по отношению к типу данных DATE. Использование функций для работы с датами.
Использование функций преобразования и условных выражений
Описание явного и неявного преобразования типов данных. Использование функций преобразования TO_CHAR, TO_NUMBER и TO_DATE. Вложенные функции. Применение функций NVL, NULLIF и COALESCE к данным. Использование логических условий IF THEN ELSE в команде SELECT.
Агрегация данных при помощи групповых функций
Использование групповых функций в команде SELECT. Создание групп данных при помощи предложения GROUP BY. Исключение групп данных при помощи фразы HAVING.
Отображение данных из нескольких таблиц при помощи соединений
Синтаксис соединения таблиц для доступа к данным более чем одной таблицы. Типы соединений. Естественное соединение. Соединение таблицы само с собой. Соединения с условиями, отличными от равенства. Внешние соединения.
Использование подзапросов
Виды проблем, решаемые при помощи подзапросов. Однострочные подзапросы. Многострочные подзапросы.
Операторы работы над множествами
Описание операторов работы над множествами. Операторы UNION и UNION ALL. Оператор INTERSECT. Оператор MINUS. Сопоставление результатов SELECT. Сортировка результатов при использовании операторов работы над множествами.
Язык изменения данных (DML)
Описание команд DML. Транзакции базы данных.
Использование языка определения данных (DDL)
Описание команд DDL
Задачи курса, программа курса, приложения к курсу. Обзор основных возможностей базы данных Oracle 12c и сопутствующих продуктов. Обсуждение основных концепций, а также теоретических и физических аспектов реляционной базы данных. Введение в SQL и средства разработки на нем. Использование SQL Developer. Запуск SQL*Plus из Oracle SQL Developer. Схема Human Resource (HR). Таблицы, используемые в курсе.
Извлечение данных при помощи команды SELECT
Список возможностей команды SELECT. Использование арифметических операторов и неопределенных значений в команде SELECT. Псевдонимы столбцов. Использование оператора конкатенации, строк-литералов, альтернативного оператора цитирования и предложения DISTINCT. Использование команды DESCRIBE для вывода структуры таблицы.
Ограничение и сортировка данных
Использование предложения WHERE для выборки необходимых строк. Использование операторов сравнения и логических операторов в предложении WHERE. Переменные подстановки. Использование команд DEFINE и VERIFY.
Использование однострочных функций
Демонстрация различий между однострочными и многострочными функциями SQL. Преобразование строк при помощи символьных функций, используемых в списке SELECT и предложении WHERE. Преобразование чисел при помощи функций ROUND, TRUNC и MOD. Арифметические операции по отношению к типу данных DATE. Использование функций для работы с датами.
Использование функций преобразования и условных выражений
Описание явного и неявного преобразования типов данных. Использование функций преобразования TO_CHAR, TO_NUMBER и TO_DATE. Вложенные функции. Применение функций NVL, NULLIF и COALESCE к данным. Использование логических условий IF THEN ELSE в команде SELECT.
Агрегация данных при помощи групповых функций
Использование групповых функций в команде SELECT. Создание групп данных при помощи предложения GROUP BY. Исключение групп данных при помощи фразы HAVING.
Отображение данных из нескольких таблиц при помощи соединений
Синтаксис соединения таблиц для доступа к данным более чем одной таблицы. Типы соединений. Естественное соединение. Соединение таблицы само с собой. Соединения с условиями, отличными от равенства. Внешние соединения.
Использование подзапросов
Виды проблем, решаемые при помощи подзапросов. Однострочные подзапросы. Многострочные подзапросы.
Операторы работы над множествами
Описание операторов работы над множествами. Операторы UNION и UNION ALL. Оператор INTERSECT. Оператор MINUS. Сопоставление результатов SELECT. Сортировка результатов при использовании операторов работы над множествами.
Язык изменения данных (DML)
Описание команд DML. Транзакции базы данных.
Использование языка определения данных (DDL)
Описание команд DDL