PostgreSQL. Оптимизация запросов
0 0
-
Аннотация
Postgres Pro - Российская СУБД, разработанная компанией Postgres Professional на основе свободно-распространяемой СУБД PostgreSQL. Postgres Professional – это высоко функциональной СУБД корпоративного уровня, обеспечивающей лучшие показатели производительности, надежности и масштабируемости. Postgres Pro входит в реестр российского ПО.
Учебная программа данного курса разработана для специалистов, занимающихся администрированием баз данных и работающих с ОС Unix.
Пройдя курс «PostgreSQL 10. Оптимизация запросов», слушатели будут в деталях понимать механизмы планирования и выполнения запросов, смогут находить и оптимизировать проблемные запросы, а также производить настройку их параметров, повышая тем самым производительность СУБД.
-
Описание образовательной программы
После изучения курса слушатель будет:
Знать:
- механизмы планирования и выполнения запросов
- находить проблемные запросы и оптимизировать их,
- настраивать параметры экземпляра, связанные с производительностью
- технологиями оптимизации запросов
- выполнять запросы,
- настраивать их параметры, повышая производительность СУБД
Целевая аудитория
Администраторы баз данных
Разработчики баз данных
Содержание
Введение
Демобаза «Авиаперевозки»
Выполнение запросов
Последовательный доступ
Индексный доступ
Сканирование по битовой карте
Соединение вложенным циклом
Соединение хешированием
Соединение слиянием
Статистика
Профилирование
Приемы оптимизации
-
Получаемый документ
-
Необходимая подготовка
- общие сведения об архитектуре PostgreSQL;
- базовые знания об архитектуре, установке, настройке, обслуживании баз данных;
- уверенное владение SQL (знакомство с PL/pgSQL не обязательно, но полезно);
- владение ОС Unix.
Рекомендуемые курсы
- Использовать основные объекты БД: таблицы, индексы, представления.
- Программировать на стороне сервера на языках SQL и PL/pgSQL.
- Использовать основные типы данных, включая записи и массивы.
- Организовать взаимодействие с клиентской частью приложения.
Курс знакомит с архитектурой PostgreSQL, с установкой, базовой настройкой и запуском СУБД.
Успешное окончание обучения по программе курса позволит специалистам:
- Использовать основные объекты БД: таблицы, индексы, представления.
- Программировать на стороне сервера на языках SQL и PL/pgSQL.
- Использовать основные типы данных, включая записи и массивы.
- Организовать взаимодействие с клиентской частью приложения.
разработки серверной части приложений PostgreSQL. [TYPE] => HTML ) [~DESCRIPTION] => ) [AUDIT_CATALOG] => Array ( [ID] => 75 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория [ACTIVE] => Y [SORT] => 750 [CODE] => AUDIT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 75 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Целевая аудитория [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TRAIN_CATALOG] => Array ( [ID] => 76 [IBLOCK_ID] => 26 [NAME] => Необходимая подготовка [ACTIVE] => Y [SORT] => 800 [CODE] => TRAIN_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 76 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Необходимая подготовка [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <p align="left"> </p> <div> <ul> <li>Основы SQL. </li> <li>Опыт работы с каким-нибудь процедурным языком программирования. </li> <li>Минимальные сведения о работе в Unix</li> </ul> </div> <p align="left"> </p> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 21088243 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] =>
- Основы SQL.
- Опыт работы с каким-нибудь процедурным языком программирования.
- Минимальные сведения о работе в Unix
[TYPE] => HTML ) [~DESCRIPTION] => ) [CONTENT_CATALOG] => Array ( [ID] => 77 [IBLOCK_ID] => 26 [NAME] => Содержание [ACTIVE] => Y [SORT] => 850 [CODE] => CONTENT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 77 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Содержание [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_CATALOG] => Array ( [ID] => 78 [IBLOCK_ID] => 26 [NAME] => Сертификация [ACTIVE] => Y [SORT] => 900 [CODE] => SERTIF_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 78 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Сертификация [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DOC_CATALOG] => Array ( [ID] => 79 [IBLOCK_ID] => 26 [NAME] => Получаемый документ [ACTIVE] => Y [SORT] => 950 [CODE] => DOC_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 79 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Получаемый документ [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <img width="614" alt="DEV1.png" src="/upload/medialibrary/d2c/d2c926969f6edc3d4736fa2d699e1e1d.png" height="430" title="DEV1.png"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 21409483 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [~DESCRIPTION] => ) [LENGTH_CATALOG] => Array ( [ID] => 80 [IBLOCK_ID] => 26 [NAME] => Продолжительность обучения [ACTIVE] => Y [SORT] => 1000 [CODE] => LENGTH_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 80 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Продолжительность обучения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 32 ак. часа [PROPERTY_VALUE_ID] => 21088236 [DESCRIPTION] => [~VALUE] => 32 ак. часа [~DESCRIPTION] => ) [prepodavatel] => Array ( [ID] => 82 [IBLOCK_ID] => 26 [NAME] => Преподаватели [ACTIVE] => Y [SORT] => 1050 [CODE] => prepodavatel [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 82 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Преподаватели [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [FORUM_TOPIC_ID] => Array ( [ID] => 175 [IBLOCK_ID] => 26 [NAME] => Тема форума для комментариев [ACTIVE] => Y [SORT] => 1150 [CODE] => FORUM_TOPIC_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 175 [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] => Array ( ) [HINT] => [~NAME] => Тема форума для комментариев [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [FORUM_MESSAGE_CNT] => Array ( [ID] => 176 [IBLOCK_ID] => 26 [NAME] => Количество комментариев к элементу [ACTIVE] => Y [SORT] => 1200 [CODE] => FORUM_MESSAGE_CNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 176 [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] => Array ( ) [HINT] => [~NAME] => Количество комментариев к элементу [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [OPTIONS_CATALOG] => Array ( [ID] => 229 [IBLOCK_ID] => 26 [NAME] => Доп. опции [ACTIVE] => Y [SORT] => 1300 [CODE] => OPTIONS_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 229 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 60 [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] => ) [MOODLE_ID] => Array ( [ID] => 244 [IBLOCK_ID] => 26 [NAME] => ID курса в СДО [ACTIVE] => Y [SORT] => 1350 [CODE] => MOODLE_ID [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] => Array ( ) [HINT] => [~NAME] => ID курса в СДО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [COUNT_ORDER] => Array ( [ID] => 248 [IBLOCK_ID] => 26 [NAME] => Количество заказов [ACTIVE] => Y [SORT] => 1400 [CODE] => COUNT_ORDER [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] => Array ( ) [HINT] => [~NAME] => Количество заказов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [IN_ASO] => Array ( [ID] => 251 [IBLOCK_ID] => 26 [NAME] => Курс в АСО [ACTIVE] => Y [SORT] => 1450 [CODE] => IN_ASO [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [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] => Array ( ) [HINT] => [~NAME] => Курс в АСО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [VARIANTY_VIEZD] => Array ( [ID] => 384 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория (Новый блок) [ACTIVE] => Y [SORT] => 1500 [CODE] => VARIANTY_VIEZD [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 288 [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] => Array ( ) [HINT] => [~NAME] => Целевая аудитория (Новый блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 24412 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21358539 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 24412 ) [~DESCRIPTION] => Array ( [0] => ) ) [RAZPISANIE] => Array ( [ID] => 385 [IBLOCK_ID] => 26 [NAME] => Расписание [ACTIVE] => Y [SORT] => 1550 [CODE] => RAZPISANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 289 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 64 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 23976 [1] => 23977 [2] => 23978 [3] => 23979 [4] => 23980 [5] => 23981 [6] => 23982 [7] => 23983 [8] => 23984 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21358540 [1] => 21358541 [2] => 21358542 [3] => 21358543 [4] => 21358544 [5] => 21358545 [6] => 21358546 [7] => 21358547 [8] => 21358548 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => ) [~VALUE] => Array ( [0] => 23976 [1] => 23977 [2] => 23978 [3] => 23979 [4] => 23980 [5] => 23981 [6] => 23982 [7] => 23983 [8] => 23984 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => ) ) [VIDEO] => Array ( [ID] => 386 [IBLOCK_ID] => 26 [NAME] => Видео [ACTIVE] => Y [SORT] => 1600 [CODE] => VIDEO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 293 [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] => Array ( ) [HINT] => [~NAME] => Видео [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [EKSAMEN] => Array ( [ID] => 387 [IBLOCK_ID] => 26 [NAME] => Экзамены [ACTIVE] => Y [SORT] => 1650 [CODE] => EKSAMEN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 294 [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] => Array ( ) [HINT] => [~NAME] => Экзамены [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [prods] => Array ( [ID] => 83 [IBLOCK_ID] => 26 [NAME] => Похожие (связанные) продукты [ACTIVE] => Y [SORT] => 1670 [CODE] => prods [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 83 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Похожие (связанные) продукты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 12311 [1] => 12312 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21121440 [1] => 21121441 ) [DESCRIPTION] => Array ( [0] => [1] => ) [~VALUE] => Array ( [0] => 12311 [1] => 12312 ) [~DESCRIPTION] => Array ( [0] => [1] => ) ) [RECOMMENT_COURSE] => Array ( [ID] => 388 [IBLOCK_ID] => 26 [NAME] => Рекомендуемые курсы [ACTIVE] => Y [SORT] => 1700 [CODE] => RECOMMENT_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 295 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Рекомендуемые курсы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TARIF_PLAN] => Array ( [ID] => 389 [IBLOCK_ID] => 26 [NAME] => Тарифные планы [ACTIVE] => Y [SORT] => 1750 [CODE] => TARIF_PLAN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 296 [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] => Array ( ) [HINT] => [~NAME] => Тарифные планы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PODZAGOLOVOK_NAME] => Array ( [ID] => 390 [IBLOCK_ID] => 26 [NAME] => Подзаголовок для названия [ACTIVE] => Y [SORT] => 1800 [CODE] => PODZAGOLOVOK_NAME [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 309 [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] => Array ( ) [HINT] => [~NAME] => Подзаголовок для названия [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_PROGRAMM] => Array ( [ID] => 391 [IBLOCK_ID] => 26 [NAME] => Заголовок - Образовательная программа [ACTIVE] => Y [SORT] => 1850 [CODE] => TITLE_PROGRAMM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 310 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Образовательная программа [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_KURSE] => Array ( [ID] => 392 [IBLOCK_ID] => 26 [NAME] => Сертификаты (блок) [ACTIVE] => Y [SORT] => 1900 [CODE] => SERTIF_KURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 311 [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] => Array ( ) [HINT] => [~NAME] => Сертификаты (блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PACKET_PRED] => Array ( [ID] => 393 [IBLOCK_ID] => 26 [NAME] => Пакетные предложения [ACTIVE] => Y [SORT] => 1950 [CODE] => PACKET_PRED [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 312 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 63 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Пакетные предложения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SALE] => Array ( [ID] => 394 [IBLOCK_ID] => 26 [NAME] => Акция [ACTIVE] => Y [SORT] => 2000 [CODE] => SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 366 [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] => Array ( ) [HINT] => [~NAME] => Акция [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [TITLE_ANNOTATION] => Array ( [ID] => 395 [IBLOCK_ID] => 26 [NAME] => Заголовок - Аннотация [ACTIVE] => Y [SORT] => 2050 [CODE] => TITLE_ANNOTATION [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 370 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Аннотация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_COURSE] => Array ( [ID] => 396 [IBLOCK_ID] => 26 [NAME] => Заголовок - Цель курса [ACTIVE] => Y [SORT] => 2100 [CODE] => TITLE_CEL_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 371 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Цель курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_AUDITOR] => Array ( [ID] => 397 [IBLOCK_ID] => 26 [NAME] => Заголовок - Целевая аудитория [ACTIVE] => Y [SORT] => 2150 [CODE] => TITLE_CEL_AUDITOR [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 372 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Целевая аудитория [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SODERSHANIE] => Array ( [ID] => 398 [IBLOCK_ID] => 26 [NAME] => Заголовок - Содержание [ACTIVE] => Y [SORT] => 2200 [CODE] => TITLE_SODERSHANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 373 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Содержание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SERTIF] => Array ( [ID] => 399 [IBLOCK_ID] => 26 [NAME] => Заголовок - Сертификация [ACTIVE] => Y [SORT] => 2250 [CODE] => TITLE_SERTIF [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 374 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Сертификация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_DOCUMENT] => Array ( [ID] => 400 [IBLOCK_ID] => 26 [NAME] => Заголовок - Получаемый документ [ACTIVE] => Y [SORT] => 2300 [CODE] => TITLE_DOCUMENT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 375 [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] => Array ( ) [HINT] => [~NAME] => Заголовок - Получаемый документ [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [CONNECT_BUY] => Array ( [ID] => 401 [IBLOCK_ID] => 26 [NAME] => Курс можно купить [ACTIVE] => Y [SORT] => 2350 [CODE] => CONNECT_BUY [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 377 [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] => Array ( ) [HINT] => [~NAME] => Курс можно купить [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [OFFERTA] => Array ( [ID] => 402 [IBLOCK_ID] => 26 [NAME] => Файл оферты [ACTIVE] => Y [SORT] => 2400 [CODE] => OFFERTA [DEFAULT_VALUE] => [PROPERTY_TYPE] => F [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 399 [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] => Array ( ) [HINT] => [~NAME] => Файл оферты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [POPULAR_COURSE_SORT] => Array ( [ID] => 752 [IBLOCK_ID] => 26 [NAME] => Сортировка (Популярные курсы) [ACTIVE] => Y [SORT] => 2450 [CODE] => POPULAR_COURSE_SORT [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] => Array ( ) [HINT] => [~NAME] => Сортировка (Популярные курсы) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [RASPISANIE_TITLE] => Array ( [ID] => 761 [IBLOCK_ID] => 26 [NAME] => Расписание (Заголовок) [ACTIVE] => Y [SORT] => 2500 [CODE] => RASPISANIE_TITLE [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] => Array ( ) [HINT] => [~NAME] => Расписание (Заголовок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Содержание [PROPERTY_VALUE_ID] => 21371326 [DESCRIPTION] => [~VALUE] => Содержание [~DESCRIPTION] => ) [code] => Array ( [ID] => 180 [IBLOCK_ID] => 26 [NAME] => Код курса (служебное) [ACTIVE] => Y [SORT] => 2550 [CODE] => code [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 180 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Код курса (служебное) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => DEV1 [PROPERTY_VALUE_ID] => 21333017 [DESCRIPTION] => [~VALUE] => DEV1 [~DESCRIPTION] => ) [MARKET_CATEGOR] => Array ( [ID] => 762 [IBLOCK_ID] => 26 [NAME] => Категория Яндекс.Маркет [ACTIVE] => Y [SORT] => 3000 [CODE] => MARKET_CATEGOR [DEFAULT_VALUE] => 3205 [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] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => ym_service_category [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Категория Яндекс.Маркет [~DEFAULT_VALUE] => 3205 [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 3205 [PROPERTY_VALUE_ID] => 21389918 [DESCRIPTION] => [~VALUE] => 3205 [~DESCRIPTION] => ) [POST_TEACHERS] => ) [DISPLAY_PROPERTIES] => Array ( ) [IPROPERTY_VALUES] => Array ( [ELEMENT_META_DESCRIPTION] => <p> </p> <div> <b>Postgres Professional</b> — российская компания, занимающаяся развитием отечественной экспертизы в области разработки СУБД. <br> Курс знакомит с архитектурой PostgreSQL, с установкой, базовой настройкой и запуском СУБД. <br> <br> <b><span style="color: #f16522;">Успешное окончание обучения по программе курса позволит специалистам:</span></b> </div> <p> </p> <ul> <li>Использовать основные объекты БД: таблицы, индексы, представления. </li> <li>Программировать на стороне сервера на языках SQL и PL/pgSQL. </li> <li>Использовать основные типы данных, включая записи и массивы. </li> <li>Организовать взаимодействие с клиентской частью приложения.</li> </ul> [ELEMENT_META_TITLE] => Разработка серверной части приложений PostgreSQL. Базовый курс ) )
- общие сведения об архитектуре PostgreSQL;
- базовые знания об архитектуре, установке, настройке, обслуживании баз данных;
- основы работы с SQL в PostgeSQL;
- владение ОС Unix.
0 отзывов
Об этом курсе отзывов пока нет. Будьте первым.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.