QPT
Базы данных
16 ак. часов
PostgreSQL. Оптимизация запросов
0 0
Физлицам
19000 ₽
Юрлицам
19000 ₽
Очное обучение.
Курсы проводятся во всех региональных учебных центрах Академии АйТи или на базе заказчика.
Онлайн класс. Удаленное подключение к очным курсам.
Для обучения достаточно иметь доступ в Интернет.
Время онлайн трансляции курса устанавливается в зависимости от города проведения очного обучения. Предусмотрено предоставление записей слушателям в отдаленных часовых поясах.
-
Аннотация
Postgres Pro - Российская СУБД, разработанная компанией Postgres Professional на основе свободно-распространяемой СУБД PostgreSQL. Postgres Professional – это высоко функциональной СУБД корпоративного уровня, обеспечивающей лучшие показатели производительности, надежности и масштабируемости. Postgres Pro входит в реестр российского ПО.
Учебная программа данного курса разработана для специалистов, занимающихся администрированием баз данных и работающих с ОС Unix.
Пройдя курс «PostgreSQL 10. Оптимизация запросов», слушатели будут в деталях понимать механизмы планирования и выполнения запросов, смогут находить и оптимизировать проблемные запросы, а также производить настройку их параметров, повышая тем самым производительность СУБД.
-
Описание образовательной программы
После изучения курса слушатель будет:
Знать:
- механизмы планирования и выполнения запросов
- находить проблемные запросы и оптимизировать их,
- настраивать параметры экземпляра, связанные с производительностью
- технологиями оптимизации запросов
- выполнять запросы,
- настраивать их параметры, повышая производительность СУБД
Целевая аудитория
Администраторы баз данных
Разработчики баз данных
Содержание
1
Введение
2
Демобаза «Авиаперевозки»
3
Выполнение запросов
4
Последовательный доступ
5
Индексный доступ
6
Сканирование по битовой карте
7
Соединение вложенным циклом
8
Соединение хешированием
9
Соединение слиянием
10
Статистика
11
Профилирование
12
Приемы оптимизации
-
Получаемый документ
-
Необходимая подготовка
- общие сведения об архитектуре PostgreSQL;
- базовые знания об архитектуре, установке, настройке, обслуживании баз данных;
- уверенное владение SQL (знакомство с PL/pgSQL не обязательно, но полезно);
- владение ОС Unix.
Рекомендуемые курсы
Импортозамещение
Разработка серверной части приложений PostgreSQ...
DEV1
Postgres Professional
32 ак. часа
Физлицам
36000 ₽
Юрлицам
36000 ₽
- Использовать основные объекты БД: таблицы, индексы, представления.
- Программировать на стороне сервера на языках SQL и PL/pgSQL.
- Использовать основные типы данных, включая записи и массивы.
- Организовать взаимодействие с клиентской частью приложения.
Postgres Professional — российская компания, занимающаяся развитием отечественной экспертизы в области разработки СУБД.
Курс знакомит с архитектурой PostgreSQL, с установкой, базовой настройкой и запуском СУБД.
Успешное окончание обучения по программе курса позволит специалистам:
Курс знакомит с архитектурой 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. Настройка и монит...
DBA2
Postgres Professional
32 ак. часа
Физлицам
32000 ₽
Юрлицам
32000 ₽
- общие сведения об архитектуре PostgreSQL;
- базовые знания об архитектуре, установке, настройке, обслуживании баз данных;
- основы работы с SQL в PostgeSQL;
- владение ОС Unix.
0 отзывов
Об этом курсе отзывов пока нет. Будьте первым.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.