Введение в базы данных
направление: Системный и бизнес-анализ
вендор:
Даты проведения курса
Array
(
[1] => Array
(
[PRICES] => Array
(
[BASE] => Array
(
[PRICE_ID] => 1
[ID] => 64685
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 24000
[VALUE_NOVAT] => 24000
[DISCOUNT_VALUE_VAT] => 24000
[DISCOUNT_VALUE_NOVAT] => 24000
[ROUND_VALUE_VAT] => 24000
[ROUND_VALUE_NOVAT] => 24000
[VALUE] => 24000
[UNROUND_DISCOUNT_VALUE] => 24000
[DISCOUNT_VALUE] => 24000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 24 000 руб.
[PRINT_VALUE_VAT] => 24 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 24 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 24 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 24 000 руб.
[PRINT_DISCOUNT_VALUE] => 24 000 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
)
[PRICE_MATRIX] =>
[MIN_PRICE] => Array
(
[PRICE_ID] => 1
[ID] => 64685
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 24000
[VALUE_NOVAT] => 24000
[DISCOUNT_VALUE_VAT] => 24000
[DISCOUNT_VALUE_NOVAT] => 24000
[ROUND_VALUE_VAT] => 24000
[ROUND_VALUE_NOVAT] => 24000
[VALUE] => 24000
[UNROUND_DISCOUNT_VALUE] => 24000
[DISCOUNT_VALUE] => 24000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 24 000 руб.
[PRINT_VALUE_VAT] => 24 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 24 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 24 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 24 000 руб.
[PRINT_DISCOUNT_VALUE] => 24 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] => 64685
[~CATALOG_PRICE_ID_1] => 64685
[CATALOG_PRICE_1] => 24000.00
[~CATALOG_PRICE_1] => 24000.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] => 62319
[~ID] => 62319
[IBLOCK_ID] => 24
[~IBLOCK_ID] => 24
[PROPERTY_85_VALUE] => 56487
[~PROPERTY_85_VALUE] => 56487
[PROPERTY_85_VALUE_ID] => 5143230
[~PROPERTY_85_VALUE_ID] => 5143230
[PROPERTY_DATE_FROM_VALUE] => 29.06.2022
[~PROPERTY_DATE_FROM_VALUE] => 29.06.2022
[PROPERTY_DATE_FROM_VALUE_ID] => 5143237
[~PROPERTY_DATE_FROM_VALUE_ID] => 5143237
[NAME] => Введение в базы данных
[~NAME] => Введение в базы данных
[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] => d907a56a69be46556d0929f010de36f5
[LINK_ELEMENT_ID] => 56487
[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] => 56487
[PROPERTY_VALUE_ID] => 5143230
[DESCRIPTION] =>
[~VALUE] => 56487
[~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] => 5143239
[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] => 29.06.2022
[PROPERTY_VALUE_ID] => 5143237
[DESCRIPTION] =>
[~VALUE] => 29.06.2022
[~DESCRIPTION] =>
)
[DATE_TO] => Array
(
[ID] => 102
[IBLOCK_ID] => 24
[NAME] => Окончание курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_TO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Окончание курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 01.07.2022
[PROPERTY_VALUE_ID] => 5143238
[DESCRIPTION] =>
[~VALUE] => 01.07.2022
[~DESCRIPTION] =>
)
[FLAG_SALE] => Array
(
[ID] => 141
[IBLOCK_ID] => 24
[NAME] => Скидки
[ACTIVE] => Y
[SORT] => 500
[CODE] => FLAG_SALE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Скидки
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[IN_ACTION] => Array
(
[ID] => 142
[IBLOCK_ID] => 24
[NAME] => Участвует в акциях
[ACTIVE] => Y
[SORT] => 500
[CODE] => IN_ACTION
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 30
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => EList
[USER_TYPE_SETTINGS] => Array
(
[size] => 1
[width] => 0
[group] => N
[multiple] => N
)
[HINT] =>
[~NAME] => Участвует в акциях
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[NEW] => Array
(
[ID] => 144
[IBLOCK_ID] => 24
[NAME] => Новинка
[ACTIVE] => Y
[SORT] => 500
[CODE] => NEW
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Новинка
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[DURATION_HOURS] => Array
(
[ID] => 174
[IBLOCK_ID] => 24
[NAME] => Длитеность, часов
[ACTIVE] => Y
[SORT] => 500
[CODE] => DURATION_HOURS
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Длитеность, часов
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 24
[PROPERTY_VALUE_ID] => 5143233
[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] => 5143234
[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] => IntBD
[PROPERTY_VALUE_ID] => 5143235
[DESCRIPTION] =>
[~VALUE] => IntBD
[~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] => TSA
[PROPERTY_VALUE_ID] => 5143236
[DESCRIPTION] =>
[~VALUE] => TSA
[~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] => 5143231
[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] => 24000
[PROPERTY_VALUE_ID] => 5143232
[DESCRIPTION] =>
[~VALUE] => 24000
[~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] => 5143240
[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] => 01.07.2022
[PROPERTY_VALUE_ID] => 5143238
[DESCRIPTION] =>
[~VALUE] => 01.07.2022
[~DESCRIPTION] =>
[DISPLAY_VALUE] => 01.07.2022
)
)
[PRODUCT] => Array
(
[TYPE] => 4
[AVAILABLE] => Y
[MEASURE] =>
[VAT_ID] =>
[VAT_RATE] =>
[VAT_INCLUDED] => N
[QUANTITY] => 0
[QUANTITY_TRACE] => N
[CAN_BUY_ZERO] => N
[SUBSCRIPTION] =>
[BUNDLE] => N
)
[ITEM_PRICE_MODE] => S
[ITEM_PRICES] => Array
(
[0] => Array
(
[UNROUND_BASE_PRICE] => 24000
[UNROUND_PRICE] => 24000
[BASE_PRICE] => 24000
[PRICE] => 24000
[ID] => 64685
[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] => 24 000 руб.
[RATIO_BASE_PRICE] => 24000
[PRINT_RATIO_BASE_PRICE] => 24 000 руб.
[PRINT_PRICE] => 24 000 руб.
[RATIO_PRICE] => 24000
[PRINT_RATIO_PRICE] => 24 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/IntBD/?ELEMENT_CODE=IntBD&action=BUY&id=62319
[BUY_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=BUY&id=62319
[~ADD_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=ADD2BASKET&id=62319
[ADD_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=ADD2BASKET&id=62319
[~SUBSCRIBE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=SUBSCRIBE_PRODUCT&id=62319
[SUBSCRIBE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=SUBSCRIBE_PRODUCT&id=62319
[~COMPARE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=ADD_TO_COMPARE_LIST&id=62319
[COMPARE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=ADD_TO_COMPARE_LIST&id=62319
[~COMPARE_DELETE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=DELETE_FROM_COMPARE_LIST&id=62319
[COMPARE_DELETE_URL] => /courses/IntBD/?ELEMENT_CODE=IntBD&action=DELETE_FROM_COMPARE_LIST&id=62319
[CATALOG_MEASURE_RATIO] => 1
[OFFER_GROUP] =>
[RATIO_PRICE] => Array
(
[VALUE] => 24000
[DISCOUNT_VALUE] => 24000
[PRINT_VALUE] => 24 000 руб.
[PRINT_DISCOUNT_VALUE] => 24 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
)
)
- 29.06.2022 Москва записаться
Курс «Введение в базы данных» направления «Подготовка системного аналитика» создан специально для подготовки аналитиков к работе с данными и призван снабдить слушателей знаниями и навыками, необходимыми для построения моделей данных, проектирования таблиц базы данных и написания запросов к БД. Курс читается опытным специалистом Учебного центра РДТЕХ, который готов ответить на все вопросы слушателей, возникающие по ходу курса. Одним из преимуществ курса является выполнение слушателями большого количества практических работ, основанных на реальных кейсах.
После успешного прохождения курса «Введение в базы данных» слушатели:
1. Поймут, что такое реляционная модель хранения данных;
2. Смогут самостоятельно спроектировать таблицы базы данных;
3. Смогут перечислить самые популярные СУБД и рассказать об их особенностях;
4. Получат знания и навыки, необходимые для написания SQL-запросов к БД;
5. Будут обладать навыками для создания сущностей в БД.
Преподаватель курса - Кошкарова Екатерина
После успешного прохождения курса «Введение в базы данных» слушатели:
1. Поймут, что такое реляционная модель хранения данных;
2. Смогут самостоятельно спроектировать таблицы базы данных;
3. Смогут перечислить самые популярные СУБД и рассказать об их особенностях;
4. Получат знания и навыки, необходимые для написания SQL-запросов к БД;
5. Будут обладать навыками для создания сущностей в БД.
Преподаватель курса - Кошкарова Екатерина
День 1.
Как хранятся данные?
Что такое данные? Свойства данных. Что такое база данных? Виды баз данных: реляционная, сетевая, иерархическая и т.д.
Реляционная модель хранения данных
Что такое сущность. Связи между сущностями. Ключи. Нормальные формы.
СУБД
Что такое СУБД? Самые популярные СУБД и их особенности.
День 2.
Язык SQL
Типы данных. Операторы DDL, DML, DCL. Создание таблицы в БД. Заполнение таблицы данными. Построение простых запросов. Изменение структуры таблицы. Задание ограничений. Создание представлений. Выдача прав на работу с таблицами.
День 3.
Практика.
Как хранятся данные?
Что такое данные? Свойства данных. Что такое база данных? Виды баз данных: реляционная, сетевая, иерархическая и т.д.
Реляционная модель хранения данных
Что такое сущность. Связи между сущностями. Ключи. Нормальные формы.
СУБД
Что такое СУБД? Самые популярные СУБД и их особенности.
День 2.
Язык SQL
Типы данных. Операторы DDL, DML, DCL. Создание таблицы в БД. Заполнение таблицы данными. Построение простых запросов. Изменение структуры таблицы. Задание ограничений. Создание представлений. Выдача прав на работу с таблицами.
День 3.
Практика.